13.72. Release 0.180

    • Fix a rare bug where rows containing only values are not returned to the client. This only occurs when an entire result page contains only null values. The only known case is a query over an ORC encoded Hive table that does not perform any transformation of the data.
    • Fix incorrect results when performing comparisons between values of approximate data types (REAL, DOUBLE) and columns of certain exact numeric types (INTEGER, BIGINT, DECIMAL).
    • Fix query failure due to NoClassDefFoundError when scalar functions declared in plugins are implemented with instance methods.
    • Improve performance of map subscript from O(n) to O(1) in all cases. Previously, only maps produced by certain functions and readers could take advantage of this improvement.
    • Skip unknown costs in EXPLAIN output.
    • Support Secure Internal Communication between Presto nodes.
    • Add initial support for CROSS JOIN against LATERAL derived tables.
    • Add support for VARBINARY concatenation.
    • Add that makes it possible to use Presto with external systems without the need to implement a custom connector.
    • Add experimental REST endpoint on coordinator.

    Hive Changes

    • Ignore partition bucketing if table is not bucketed. This allows dropping the bucketing from table metadata but leaving it for old partitions.
    • Improve error message for Hive partitions dropped during execution.
    • The optimized RCFile writer is enabled by default, but can be disabled with the hive.rcfile-optimized-writer.enabled config option. The writer supports validation which reads back the entire file after writing. Validation is disabled by default, but can be enabled with the hive.rcfile.writer.validate config option.
    • Add support for INSERT.
    • Add support for pushdown of non-equality predicates on clustering keys.

    JDBC Driver Changes

    • Add support for authenticating using Kerberos.
    • Allow configuring SSL/TLS and Kerberos properties on a per-connection basis.
    • Add support for executing queries using a SOCKS or HTTP proxy.

    SPI Changes

    • Add running time limit and queued time limit to ResourceGroupInfo.