Release 0.180

    • Fix incorrect results when performing comparisons between values of approximate data types (REAL, DOUBLE) and columns of certain exact numeric types (INTEGER, BIGINT, ).

    • 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.

    • Add initial support for CROSS JOIN against LATERAL derived tables.

    • Add support for VARBINARY concatenation.

    • Add Thrift Connector 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

    • 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.

    • Add support for executing queries using a SOCKS or HTTP proxy.

    SPI Changes

    • Add running time limit and queued time limit to .