12.68. Release 0.168

    • Fix correctness issues for certain queries that require implicit coercionsfor terms in the join criteria.
    • Fix invalid “No more locations already set” error.
    • Fix invalid “No more buffers already set” error.
    • Improve performance of DECIMAL type and operators.
    • Optimize window frame computation for empty frames.
    • json_extract() and now support escaping doublequotes or backslashes using a backslash with a JSON path subscript. This changesthe semantics of any invocation using a backslash, as backslashes were previouslytreated as normal characters.
    • Improve performance of filter() and lambda functions.
    • Add Memory Connector.
    • Add and functions.
    • 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 experimental.iterative-optimizer-timeout configuration option.
    • ROW types are now orderable if all of the field types are orderable.This allows using them in comparison expressions, ORDER BY andfunctions that require orderable types (e.g., ).

    JDBC Driver Changes

    • Update advertised JDBC version to 4.2, which part of Java 8.
    • Return correct driver and server versions rather than 1.0.
    • 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 thercfile_optimized_writer_enabled session property or the hive.rcfile-optimized-writer.enabledHive catalog property.

    Cassandra Changes

    • Add predicate pushdown for clustering key.
    • Allow SSL connections using the mongodb.ssl.enabled config flag.

    SPI Changes