Release 0.78

    The Presto session can now contain properties, which can be used by the Presto engine or connectors to customize the query execution. There is a separate namespace for the Presto engine and each catalog. A property for a catalog is simplify prefixed with the catalog name followed by . (dot). A connector can retrieve the properties for the catalog using ConnectorSession.getProperties().

    Session properties can be set using the --session command line argument to the Presto CLI. For example:

    For JDBC, the properties can be set by unwrapping the as follows:

      Note

      • Add storage_format session property to override format used for creating tables.

      • Add write support for VARBINARY, DATE and .

      • Add support for partition keys of type TIMESTAMP.

      • Add support for partition keys with null values (__HIVE_DEFAULT_PARTITION__).

      • Fix expression optimizer, so that it runs in linear time instead of exponential time.

      • Add cardinality() for maps.

      • Fix race condition in SqlTask creation which can cause queries to hang.

      • Fix option.