20.81. Release 0.168
Fix correctness issues for certain
JOINqueries that require implicit coercions for terms in the join criteria.
Fix invalid “No more locations already set” error.
Fix invalid “No more buffers already set” error.
Temporarily revert empty join short-circuit optimization due to issue with hanging queries.
Improve performance of
DECIMALtype and operators.
Optimize window frame computation for empty frames.
json_extract_scalar()now support escaping double quotes or backslashes using a backslash with a JSON path subscript. This changes the semantics of any invocation using a backslash, as backslashes were previously treated as normal characters.
Add Memory Connector.
Allow concatenating more than two arrays with
concat()or maps with
Add a time limit for the iterative optimizer. It can be adjusted via the
iterative_optimizer_timeoutsession property or
ROWtypes are now orderable if all of the field types are orderable. This allows using them in comparison expressions,
ORDER BYand functions that require orderable types (e.g.,
JDBC Driver Changes
DatabaseMetaDatato reflect features that are now supported.
Update advertised JDBC version to 4.2, which part of Java 8.
Return correct driver and server versions rather than
Fix reading decimals for RCFile text format using non-optimized reader.
Fix bug which prevented the file based metastore from being used.
Enable optimized RCFile reader by default.
Common user errors are now correctly categorized.
Add new, experimental, RCFile writer optimized for Presto. The new writer can be enabled with the
rcfile_optimized_writer_enabledsession property or the
hive.rcfile-optimized-writer.enabledHive catalog property.
Add predicate pushdown for clustering key.
Allow SSL connections using the
ConnectorIndex now returns
RecordSet. Existing connectors that support index join can use the
RecordPageSourceto adapt to the new API.