12.9. Release 321 (15 Oct 2019)

Warning

The server RPM is broken in this release.

General Changes

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)

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)

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)

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