13.184. Release 0.70

    This release contained a packaging error that resulted in an unusable server tarball. Do not use this release.

    See CREATE VIEW and for details and examples.

    DUAL Table

    There is a new project, , which can be used to verify a set of queries against two different clusters.

    Connector Improvements

    • Presto contains an extensive test suite to verify the correctness. This test suite has been extracted into the presto-test module for use during connector development. For an example, see TestRaptorDistributedQueries.

    General Changes

    • New comparison functions: greatest() and
    • New window functions: first_value(), , and nth_value()
    • We have added a config option to disable falling back to the interpreter when expressions fail to be compiled to bytecode. To set this option, add compiler.interpreter-enabled=false to etc/config.properties. This will force certain queries to fail rather than running slowly.
    • values are now implicitly coerced to TIMESTAMP and TIMESTAMP WITH TIME ZONE by setting the hour/minute/seconds to 0 with respect to the session timezone.
    • Minor performance optimization when planning queries over tables with tens of thousands of partitions or more.
    • Fixed a bug when planning ORDER BY ... LIMIT queries which could result in duplicate and un-ordered results under rare conditions.
    • Fix compiler cache for expressions.
    • Fix processing of empty or commented out statements in the CLI.
    • There are two new configuration options for the Hive connector, hive.max-initial-split-size, which configures the size of the initial splits, and hive.max-initial-splits, which configures the number of initial splits. This can be useful for speeding up small queries, which would otherwise have low parallelism.
    • The Hive connector will now consider all tables with a non-empty value for the table property presto_offline to be offline. The value of the property will be used in the error message.
    • We have added support for for DROP TABLE in the hive connector. By default, this feature is not enabled. To enable it, set hive.allow-drop-table=true in your Hive catalog properties file.
    • Ignore subdirectories when generating splits (this now matches the non-recursive behavior of Hive).
    • Fix handling of maps with null keys.