Release 321 (15 Oct 2019)#

Warning

The server RPM is broken in this release.

General#

  • Fix incorrect result of round() when applied to a tinyint, smallint, integer, or bigint type with negative decimal places. (#42)

  • Improve performance of queries with LIMIT over information_schema tables. (#1543)

  • Improve performance for broadcast joins by using dynamic filtering. This can be enabled via the experimental.enable-dynamic-filtering configuration option or the enable_dynamic_filtering session property. (#1686)

Security#

  • Improve the security of query results with one-time tokens. (#1654)

Hive connector#

  • Fix reading TEXT file collection delimiter set by Hive versions earlier than 3.0. (#1714)

  • Fix a regression that prevented Presto from using the AWS Glue metastore. (#1698)

  • Allow skipping header or footer lines for CSV format tables via the skip_header_line_count and skip_footer_line_count table properties. (#1090)

  • Rename table property textfile_skip_header_line_count to skip_header_line_count and textfile_skip_footer_line_count to skip_footer_line_count. (#1090)

  • Add support for LZOP compressed (.lzo) files. Previously, queries accessing LZOP compressed files would fail, unless all files were small. (#1701)

  • Add support for bucket-aware read of tables using bucketing version 2. (#538)

  • Add support for writing to tables using bucketing version 2. (#538)

  • Allow caching directory listings for all tables or schemas. (#1668)

  • Add support for dynamic filtering for broadcast joins. (#1686)

PostgreSQL connector#

  • Support reading PostgreSQL arrays as the JSON data type. This can be enabled by setting the postgresql.experimental.array-mapping configuration property or the array_mapping catalog session property to AS_JSON. (#682)

Elasticsearch connector#

  • Add support for Amazon Elasticsearch Service. (#1693)

Cassandra connector#

  • Add TLS support. (#1680)

JMX connector#

  • Add support for wildcards in configuration of history tables. (#1572)

SPI#

  • Fix QueryStatistics.getWallTime() to report elapsed time rather than total scheduled time. (#1719)