19.1. Release 0.208-e

Update 0.1

General Changes

  • Introduce cost-based plan optimizations.
  • Add support for ROLE management including CREATE ROLE, DROP ROLE, GRANT ROLE, REVOKE ROLE, SET ROLE, SHOW CURRENT ROLES, SHOW ROLES and SHOW ROLE GRANTS commands.
  • Support prepared statements that are longer than 4K bytes.
  • Fix timeout issue when getting stats on large number of partitions.
  • Improve statistics estimation for filter expressions
  • Fix data loss when writing bucketed sorted tables. Partitions would be missing arbitrary rows if any of the temporary files for a bucket had the same size. The numRows partition property contained the correct number of rows and can be used to detect if this occurred.
  • Update docs with memory-related configs introduced in 0.201
  • Fix EXPLAIN ANALYZE for index join

Hive Connector Changes

  • Implement ROLE management support.
  • Allow partitions without files for bucketed tables (via hive.empty-bucketed-partitions.enabled).
  • Allow multiple files per bucket for bucketed tables (via hive.multi-file-bucketing.enabled). There must be one or more files per bucket. File names must match the Hive naming convention.
  • Allow reading incompletely bucketed tables with missing files (via hive.empty-bucketed-partitions.enabled).
  • Add support for Azure Blob Storage
  • Add support for Azure Azure Data Lake Storage (ADLS)
  • Fix multi-file buckets when Presto does the insert
  • Support creating Avro tables with a custom schema using the avro_schema_url table property.
  • Support backward compatible Avro schema evolution.
  • Fix reading when Hadoop KMS is enabled

MySQL, PostgreSQL, Redshift, and SQL Server Changes

  • Allow for predicate pushdown of DECIMAL and CHAR predicates

Kafka Connector Changes

  • Support Avro formatted Kafka messages.
  • Support backward compatible Avro schema evolution.

Security Changes

  • Secured internal cluster communication over HTTPS using Kerberos or LDAP authentication.
  • Add support for cross-realm Kerberos authentication

Update 0.2

MySQL, PostgreSQL, Redshift, and SQL Server Changes

  • Do not push down predicate for not supported domain.

Update 0.3

General Changes

  • Flip the default value of “deprecated.legacy-char-to-varchar-coercion” property to “true”. So that CHAR to VARCHAR implicit coercion is allowed (and not the opposite). This returns the code to the state from Presto version 0.206.
  • Fix unaccounted memory usage in broadcast join in source stage.

Hive Connector Changes

  • Fix table statistics retrieval for column with single distinct value.

Update 0.4

General Changes

  • Improve inference of predicates for inner joins

Hive Connector Changes

  • Fix table statistics retrieval for column with null count equal to -1.
  • Add support for writing to tables located in HDFS encryption zones.
  • Add support for Avro tables with Avro schema url being an HDFS location.

MySQL, PostgreSQL, Redshift, and SQL Server Changes

  • Support schemas, tables and columns with names that are upper- or mixed-case.

Update 0.5

General Changes

  • Add toggle for limiting automatically broadcast table size

Hive Connector Changes

  • Improve error reporting from SerDe.

Memory Connector Changes

  • Improve memory connector pages size accounting

Web UI Changes

  • Fix protocol for redirects from / to /ui.

Update 0.6

General Changes

  • Add Generic JDBC connector
  • Fix bug where the vague error Query gone(server restarted?) was being propagated to clients instead of actual Exception message.
  • Add spill to disk for OrderBy
  • Add spill to disk for WindowOperator
  • Fix potential infinite yield in distributed sort and spill to disk for aggregations
  • Improve statistics computations for SMALLINT, TINYINT and VARBINARY literals
  • Add feature and session toggles for “top N row number” optimization

Hive Connector Changes

  • Fix query failure when querying partitioned Avro table with very long column type definition.

Security Changes

  • Support refreshing of FileBasedAccessControl and FileBasedSystemAccessControl with an optional property security.refresh-period.

Update 0.7

General Changes

  • Fix bug where SHOW CURRENT ROLES returned incorrect results from CLI.

Update 0.8

Hive Connector Changes

  • Add a tool for recording Hive Metastore API calls