Release 370 (3 Feb 2022)#
General#
Add support for
DEFAULT
keyword inALTER TABLE...SET PROPERTIES...
. (#10331)Improve performance of map and row types. (#10469)
Improve performance when evaluating expressions in
WHERE
andSELECT
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 anIS NOT NULL
predicate is used. (#10861)Fix failure when nested subquery contains a
TABLESAMPLE
clause. (#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
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 tofalse
, 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 tofalse
, 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 whenhive.hide-delta-lake-tables
is enabled, and Glue metastore references the table with no properties. (#10864)
Iceberg connector#
MySQL connector#
Remove the legacy
allow-drop-table
configuration property. This defaulted tofalse
, 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 tofalse
, 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 to1899-12-31
. (#10749)
PostgreSQL connector#
Remove the legacy
allow-drop-table
configuration property. This defaulted tofalse
, 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 tofalse
, 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 tofalse
, 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 tofalse
, 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
toConnectorTableLayout
. (#10587)Connectors no longer need to explicitly declare handle classes. The
ConnectorFactory.getHandleResolver
andConnector.getHandleResolver
methods are removed. (#10858, #10872)Remove unnecessary
Block.writePositionTo
andBlockBuilder.appendStructure
methods. Use of these methods can be replaced with the existingType.appendTo
orwriteObject
methods. (#10602)