Release 0.189#
General#
Fix query failure while logging the query plan.
Fix a bug that causes clients to hang when executing
LIMIT
queries whenoptimizer.force-single-node-output
is disabled.Fix a bug in the
bing_tile_at()
andbing_tile_polygon()
functions where incorrect results were produced for points close to tile edges.Fix variable resolution when lambda argument has the same name as a table column.
Improve error message when running
SHOW TABLES
on a catalog that does not exist.Improve performance for queries with highly selective filters.
Execute USE on the server rather than in the CLI, allowing it to be supported by any client. This requires clients to add support for the protocol changes (otherwise the statement will be silently ignored).
Allow casting
JSON
toROW
even if theJSON
does not contain every field in theROW
.Add support for dereferencing row fields in lambda expressions.
Security#
Support configuring multiple authentication types, which allows supporting clients that have different authentication requirements or gracefully migrating between authentication types without needing to update all clients at once. Specify multiple values for
http-server.authentication.type
, separated with commas.Add support for TLS client certificates as an authentication mechanism by specifying
CERTIFICATE
forhttp-server.authentication.type
. The distinguished name from the validated certificate will be provided as ajavax.security.auth.x500.X500Principal
. The certificate authority (CA) used to sign client certificates will be need to be added to the HTTP server KeyStore (should technically be a TrustStore but separating them out is not yet supported).Skip sending final leg of SPNEGO authentication when using Kerberos.
JDBC driver#
Per the JDBC specification, close the
ResultSet
whenStatement
is closed.Add support for TLS client certificate authentication by configuring the
SSLKeyStorePath
andSSLKeyStorePassword
parameters.Add support for transactions using SQL statements or the standard JDBC mechanism.
Allow executing the
USE
statement. Note that this is primarily useful when running arbitrary SQL on behalf of users. For programmatic use, continuing to usesetCatalog()
andsetSchema()
onConnection
is recommended.Allow executing
SET SESSION
andRESET SESSION
.
Resource group#
Add
WEIGHTED_FAIR
resource group scheduling policy.
Hive#
Do not require setting
hive.metastore.uri
when using the file metastore.Reduce memory usage when reading string columns from ORC or DWRF files.
MySQL, PostgreSQL, Redshift, and SQL Server shanges#
Change mapping for columns with
DECIMAL(p,s)
data type from PrestoDOUBLE
type to the corresponding PrestoDECIMAL
type.
Kafka#
Fix documentation for raw decoder.
Thrift connector#
Add support for index joins.
SPI#
Deprecate
SliceArrayBlock
.Add
SessionPropertyConfigurationManager
plugin to enable overriding default session properties dynamically.