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-bytesconfiguration property and- query_max_scan_physical_bytessession property. (#4075)
- Remove support for addition and subtraction between - TIMEand- INTERVAL YEAR TO MONTHtypes. (#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 - WITHclause contains hidden columns. (#4423)
- Fix failure when referring to type names with different case in a - GROUP BYclause. (#2960)
- Fix failure for queries involving - DISTINCTwhen expressions in- ORDER BYclause differ by case from expressions in- SELECTclause. (#4233)
- Fix incorrect type reporting for - TIMESTAMPand- TIMESTAMP WITH TIME ZONEfor legacy clients. (#4408)
- Fix failure when querying nested - TIMESTAMPor- TIMESTAMP WITH TIME ZONEfor legacy clients. (#4475, #4425)
- Fix failure when parsing timestamps with time zone with an offset of the form - +NNNN. (#4490)
JDBC driver#
- Fix reading - TIMESTAMPand- TIMESTAMP WITH TIME ZONEvalues with a negative year or a year higher than 9999. (#4364)
- Fix incorrect column size metadata for - TIMESTAMPand- TIMESTAMP WITH TIME ZONEtypes. (#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- useSessionTimeZoneJDBC connection parameter. (#4017)
Druid connector#
- Fix handling of table and column names containing non-ASCII characters. (#4312) 
Hive connector#
- Make - locationparameter optional for the- system.register_partitionprocedure. (#4443)
- Avoid creating tiny splits at the end of block boundaries. (#4485) 
- Remove requirement to configure - metastore.storage.schema.reader.implin 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 - realor- double- NaNvalues, if the file was written by a non-conforming writer. (#4267)
Kafka connector#
Kudu connector#
- Add support for grouped execution. It can be enabled with the - kudu.grouped-execution.enabledconfiguration property or the- grouped_executionsession property. (#3715)
MongoDB connector#
- Allow querying Azure Cosmos DB. (#4415) 
Oracle connector#
- Allow providing credentials via the - connection-userand- connection-passwordconfiguration 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 - DynamicFilterobject passed to- ConnectorSplitManager.getSplits(). (#4224)