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- biginttype with negative decimal places. (#42)
- Improve performance of queries with - LIMITover- information_schematables. (#1543)
- Improve performance for broadcast joins by using dynamic filtering. This can be enabled via the - experimental.enable-dynamic-filteringconfiguration option or the- enable_dynamic_filteringsession property. (#1686)
Security#
- Improve the security of query results with one-time tokens. (#1654) 
Hive connector#
- Fix reading - TEXTfile 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 - CSVformat tables via the- skip_header_line_countand- skip_footer_line_counttable properties. (#1090)
- Rename table property - textfile_skip_header_line_countto- skip_header_line_countand- textfile_skip_footer_line_countto- 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 - JSONdata type. This can be enabled by setting the- postgresql.experimental.array-mappingconfiguration property or the- array_mappingcatalog 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)