Release 370 (3 Feb 2022)#

General#

  • Add support for DEFAULT keyword in ALTER TABLE...SET PROPERTIES.... (#10331)

  • Improve performance of map and row types. (#10469)

  • Improve performance when evaluating expressions in WHERE and SELECT clauses. (#10322)

  • Prevent queries deadlock when using phased execution 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_schema query failure when an IS NOT NULL predicate is used. (#10861)

  • Fix failure when nested subquery contains a TABLESAMPLE clause. (#10764)

Security#

  • Reduced the latency of successful OAuth 2.0 authentication. (#10929)

  • Fix server start failure when using JWT and OAuth 2.0 authentication together (http-server.authentication.type=jwt,oauth2). (#10811)

CLI#

  • Add support for ARM64 processors. (#10177)

  • Allow to choose the way how external authentication is handled with the --external-authentication-redirect-handler parameter. (#10248)

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 uuid partitioned 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-driver flag when connecting to old servers. (#10541)

  • Remove the legacy allow-drop-table configuration 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-table configuration 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-writes to require auto-commit for writes. This can be used to disallow multi-statement write transactions. (#10820)

  • Fix sporadic query failure Partition no longer exists when working with wide tables using a AWS Glue catalog as metastore. (#10696)

  • Fix SHOW TABLES failure when hive.hide-delta-lake-tables is enabled, and Glue metastore references the table with no properties. (#10864)

Iceberg connector#

  • Fix query failure when reading from a table that underwent partitioning evolution. (#10770)

  • Fix data corruption when writing Parquet files. (#9749)

MySQL connector#

  • Remove the legacy allow-drop-table configuration 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-table configuration 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 date value is older than or equal to 1899-12-31. (#10749)

PostgreSQL connector#

  • Remove the legacy allow-drop-table configuration 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-table configuration 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-table configuration 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-table configuration 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 ConnectorNewTableLayout to ConnectorTableLayout. (#10587)

  • Connectors no longer need to explicitly declare handle classes. The ConnectorFactory.getHandleResolver and Connector.getHandleResolver methods are removed. (#10858, #10872)

  • Remove unnecessary Block.writePositionTo and BlockBuilder.appendStructure methods. Use of these methods can be replaced with the existing Type.appendTo or writeObject methods. (#10602)