Release 370 (3 Feb 2022)#
General#
- Add support for - DEFAULTkeyword in- ALTER TABLE...SET PROPERTIES.... (#10331)
- Improve performance of map and row types. (#10469) 
- Improve performance when evaluating expressions in - WHEREand- SELECTclauses. (#10322)
- Prevent queries deadlock when using - phasedexecution policy with dynamic filters in multi-join queries. (#10868)
- Fix query scheduling regression introduced in Trino 360 that caused coordinator slowness in assigning splits to workers. (#10839) 
- Fix - information_schemaquery failure when an- IS NOT NULLpredicate is used. (#10861)
- Fix failure when nested subquery contains a - TABLESAMPLEclause. (#10764)
Security#
CLI#
RPM package#
- Fix failure when operating system open file count is set too low. (#8819) 
Docker image#
- Change base image to - registry.access.redhat.com/ubi8/ubi, since CentOS 8 has reached end-of-life. (#10866)
Cassandra connector#
- Fix query failure when pushing predicates on - uuidpartitioned columns. (#10799)
ClickHouse connector#
- Support creating tables with Trino - timestamp(0)type columns.
- Drop support for ClickHouse servers older than version 20.7 to avoid using a deprecated driver. You can continue to use the deprecated driver with the - clickhouse.legacy-driverflag when connecting to old servers. (#10541)
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
Druid connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
Hive connector#
- Improve query performance when reading ORC data. (#10575) 
- Add configuration property - hive.single-statement-writesto require auto-commit for writes. This can be used to disallow multi-statement write transactions. (#10820)
- Fix sporadic query failure - Partition no longer existswhen working with wide tables using a AWS Glue catalog as metastore. (#10696)
- Fix - SHOW TABLESfailure when- hive.hide-delta-lake-tablesis enabled, and Glue metastore references the table with no properties. (#10864)
Iceberg connector#
MySQL connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
Oracle connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
Phoenix connector#
- Fix incorrect result when a - datevalue is older than or equal to- 1899-12-31. (#10749)
PostgreSQL connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
Redshift connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
SingleStore (MemSQL) connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
SQL Server connector#
- Remove the legacy - allow-drop-tableconfiguration property. This defaulted to- false, which disallowed dropping tables, but other modifications were still allowed. Use System access control instead, if desired. (#588)
SPI#
- Allow null property names in - ConnetorMetadata#setTableProperties. (#10331)
- Rename - ConnectorNewTableLayoutto- ConnectorTableLayout. (#10587)
- Connectors no longer need to explicitly declare handle classes. The - ConnectorFactory.getHandleResolverand- Connector.getHandleResolvermethods are removed. (#10858, #10872)
- Remove unnecessary - Block.writePositionToand- BlockBuilder.appendStructuremethods. Use of these methods can be replaced with the existing- Type.appendToor- writeObjectmethods. (#10602)