13.185. 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().

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

      This feature is a work in progress and will change in a future release. Specifically, we are planning to require preregistration of properties so the user can list available session properties and so the engine can verify property values. Additionally, the Presto grammar will be extended to allow setting properties via a query.

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