20.46. Release 0.203
Fix spurious duplicate key errors from
Fix planning failure when a correlated subquery containing a
LIMITclause is used within
Fix out of memory error caused by missing pushback checks in data exchanges.
Fix execution failure for queries containing a cross join when using bucketed execution.
Fix execution failure for queries containing an aggregation function with
DISTINCTand a highly selective aggregation filter. For example:
sum(DISTINCT x) FILTER (WHERE y = 0)
Fix quoting in error message for
Eliminate redundant calls to check column access permissions.
Improve query creation reliability by delaying query start until the client acknowledges the query ID by fetching the first response link. This eliminates timeouts during the initial request for queries that take a long time to analyze.
Remove support for legacy
Distinguish between inner and left spatial joins in explain plans.
Fix sending authentication challenge when at least two of the
JWTauthentication types are configured.
Allow using PEM encoded (PKCS #8) keystore and truststore with the HTTP server and the HTTP client used for internal communication. This was already supported for the CLI and JDBC driver.
Server RPM Changes
Declare a dependency on
uuidgenprogram is required during installation of the Presto server RPM package and lack of it resulted in an invalid config file being generated during installation.
Hive Connector Changes
Fix complex type handling in the optimized Parquet reader. Previously, null values, optional fields, and Parquet backward compatibility rules were not handled correctly.
Fix an issue that could cause the optimized ORC writer to fail with a
Improve error message for max open writers.
Thrift Connector Changes
Fix retry of requests when the remote Thrift server indicates that the error is retryable.
Local File Connector Changes
Fix parsing of timestamps when the JVM time zone is UTC (#9601).