Release 339 (21 Jul 2020)#

General#

  • Add approx_most_frequent(). (#3425)

  • Physical bytes scan limit for queries can be configured via query.max-scan-physical-bytes configuration property and query_max_scan_physical_bytes session property. (#4075)

  • Remove support for addition and subtraction between TIME and INTERVAL YEAR TO MONTH types. (#4308)

  • Fix planning failure when join criteria contains subqueries. (#4380)

  • Fix failure when subquery appear in window function arguments. (#4127)

  • Fix failure when subquery in WITH clause contains hidden columns. (#4423)

  • Fix failure when referring to type names with different case in a GROUP BY clause. (#2960)

  • Fix failure for queries involving DISTINCT when expressions in ORDER BY clause differ by case from expressions in SELECT clause. (#4233)

  • Fix incorrect type reporting for TIMESTAMP and TIMESTAMP WITH TIME ZONE for legacy clients. (#4408)

  • Fix failure when querying nested TIMESTAMP or TIMESTAMP WITH TIME ZONE for legacy clients. (#4475, #4425)

  • Fix failure when parsing timestamps with time zone with an offset of the form +NNNN. (#4490)

JDBC driver#

  • Fix reading TIMESTAMP and TIMESTAMP WITH TIME ZONE values with a negative year or a year higher than 9999. (#4364)

  • Fix incorrect column size metadata for TIMESTAMP and TIMESTAMP WITH TIME ZONE types. (#4411)

  • Return correct value from ResultSet.getDate(), ResultSet.getTime() and ResultSet.getTimestamp() methods when session zone is set to a different zone than the default zone of the JVM the JDBC is run in. The previous behavior can temporarily be restored using useSessionTimeZone JDBC connection parameter. (#4017)

Druid connector#

  • Fix handling of table and column names containing non-ASCII characters. (#4312)

Hive connector#

  • Make location parameter optional for the system.register_partition procedure. (#4443)

  • Avoid creating tiny splits at the end of block boundaries. (#4485)

  • Remove requirement to configure metastore.storage.schema.reader.impl in Hive 3.x metastore to let Presto access CSV tables. (#4457)

  • Fail query if there are bucket files outside of the bucket range. Previously, these extra files were skipped. (#4378)

  • Fix a query failure when reading from Parquet file containing real or double NaN values, if the file was written by a non-conforming writer. (#4267)

Kafka connector#

  • Add insert support for Avro. (#4418)

  • Add insert support for CSV. (#4287)

Kudu connector#

  • Add support for grouped execution. It can be enabled with the kudu.grouped-execution.enabled configuration property or the grouped_execution session property. (#3715)

MongoDB connector#

  • Allow querying Azure Cosmos DB. (#4415)

Oracle connector#

  • Allow providing credentials via the connection-user and connection-password configuration properties. These properties were previously ignored if connection pooling was enabled. (#4430)

Phoenix connector#

  • Fix handling of row key definition with white space. (#3251)

SPI#

  • Allow connectors to wait for dynamic filters before splits are generated via the new DynamicFilter object passed to ConnectorSplitManager.getSplits(). (#4224)