Presto 0.191 Documentation

11.25. Release 0.167

11.25. Release 0.167

General Changes

  • Fix planning failure when a window function depends on the output of another window function.
  • Fix planning failure for certain aggregation with both DISTINCT and GROUP BY.
  • Fix incorrect aggregation of operator summary statistics.
  • Fix a join issue that could cause joins that produce and filter many rows to monopolize worker threads, even after the query has finished.
  • Expand plan predicate pushdown capabilities involving implicitly coerced types.
  • Short-circuit inner and right join when right side is empty.
  • Optimize constant patterns for LIKE predicates that use an escape character.
  • Validate escape sequences in LIKE predicates per the SQL standard.
  • Reduce memory usage of min_by() and max_by().
  • Add transform_keys(), transform_values() and zip_with() lambda functions.
  • Add levenshtein_distance() function.
  • Add JMX stat for the elapsed time of the longest currently active split.
  • Add JMX stats for compiler caches.
  • Raise required Java version to 8u92.

Security Changes

  • The http.server.authentication.enabled config option that previously enabled Kerberos has been replaced with http-server.authentication.type=KERBEROS.
  • Add support for LDAP Authentication using username and password.
  • Add a read-only System Access Control named read-only.
  • Allow access controls to filter the results of listing catalogs, schemas and tables.
  • Add access control checks for SHOW SCHEMAS and SHOW TABLES.

Web UI Changes

  • Add operator-level performance analysis.
  • Improve visibility of blocked and reserved query states.
  • Lots of minor improvements.

JDBC Driver Changes

  • Allow escaping in DatabaseMetaData patterns.

Hive Changes

  • Fix write operations for ViewFileSystem by using a relative location.
  • Remove support for the hive-cdh4 and hive-hadoop1 connectors which support CDH 4 and Hadoop 1.x, respectively.
  • Remove the hive-cdh5 connector as an alias for hive-hadoop2.
  • Remove support for the legacy S3 block-based file system.
  • Add support for KMS-managed keys for S3 server-side encryption.

Cassandra Changes

  • Add support for Cassandra 3.x by removing the deprecated Thrift interface used to connect to Cassandra. The following config options are now defunct and must be removed: cassandra.thrift-port, cassandra.thrift-connection-factory-class, cassandra.transport-factory-options and cassandra.partitioner.

SPI Changes

  • Add methods to SystemAccessControl and ConnectorAccessControl to filter the list of catalogs, schemas and tables.
  • Add access control checks for SHOW SCHEMAS and SHOW TABLES.
  • Add beginQuery and cleanupQuery notifications to ConnectorMetadata.