Release 393 (17 Aug 2022)#

General#

  • Add support for MERGE. (#7933)

  • Add query state and error code to the timeline log message. (#13698)

  • Improve performance of highly selective LIMIT queries by making them finish as soon as the required number of rows is produced. (#13616)

  • Disallow inserting NULL into non-nullable columns.. (#13462)

  • Fix queries over bucketed tables never completing. (#13655)

  • Fix potential query failure for GROUP BY queries involving aggregations with ORDER BY and FILTER clauses. (#13627)

Security#

  • Fix potential incorrect rejection of OAuth 2.0 refresh tokens. (#13168)

  • Fix incorrectly showing outdated OAuth 2.0 refresh tokens in the web UI. (#13168)

Docker image#

  • Add experimental image for ppc64le. (#13522)

ClickHouse connector#

  • Add support for the unsupported-type-handling catalog configuration property. (#13542)

  • Improve performance for queries with selective joins. (#13334)

Delta Lake connector#

  • Add support for MERGE. (#7933)

  • Add support for the NOT NULL column constraint. (#13436)

  • Fix writing incorrect results when the order of partition columns is different from the order in the table definition. (#13505)

  • Fix failure when reading a table which has partition columns renamed by another engine. (#13521)

Druid connector#

  • Improve performance for queries with selective joins. (#13334)

Hive connector#

  • Add support for MERGE. (#7933)

  • Add support for bucket filtering on bucketed columns of float, double, date, list, map and bounded varchar data types. (#13553)

  • Add exchange.azure.max-error-retries configuration property for the number of retries performed when accessing Azure blob storage. (#13663)

  • Improve performance of queries with S3 Select pushdown by not utilizing pushdown when it is unnecessary. (#13477)

  • Reduce Thrift metastore communication overhead when impersonation is enabled. (#13606)

  • Improve performance when retrieving table statistics from the metastore. (#13488)

  • Fix error when writing to a table with only date columns while using the Hive metastore. (#13502)

  • Fix error when reading a Hive view which has a column names with a reserved keyword. (#13450)

Iceberg connector#

  • Add support for MERGE. (#7933)

  • Improve performance when filtering on $file_modified_time column. (#13504)

  • Improve performance of read queries on Iceberg v2 tables with deletion-tracking files. (#13395)

  • Allow partitioning over columns which use whitespace in their names. (#12226)

  • Disallow specifying a NOT NULL constraint when adding a new column. Previously, the option was ignored. (#13673)

  • Fix error when querying tables which are empty and contain no table history. (#13576)

  • Prevent truncation of the table history in the $snapshots system table by certain DELETE queries. (#12843)

  • Prevent errors when optimizing an Iceberg table which is empty and contains no table history. (#13582)

  • Fix incorrect query results when reading from a materialized view that was created on a table which was empty and contained no history. (#13574)

Kafka connector#

  • Fix query failure when applying a negative timestamp predicate on the _timestamp column. (#13167)

Kudu connector#

MariaDB connector#

  • Improve performance for queries with selective joins. (#13334)

MongoDB connector#

  • Prevent renaming a table with a name longer than the max length supported by MongoDB. Previously, the name was truncated to the max length. (#13073)

MySQL connector#

  • Improve performance for queries with selective joins. (#13334)

Oracle connector#

  • Improve performance for queries with selective joins. (#13334)

Phoenix connector#

  • Improve performance for queries with selective joins. (#13334)

Pinot connector#

  • Add support for the Pinot bytes type. (#13427)

  • Add support for the json type. (#13428)

PostgreSQL connector#

  • Improve performance for queries with selective joins. (#13334)

  • Prevent using schema names or renaming a table with a name which is longer than the max length supported by PostgreSQL. Previously, long names were truncated to the max length. (#13307, #13073)

Raptor connector#

Redshift connector#

  • Improve performance for queries with selective joins. (#13334)

SingleStore (MemSQL) connector#

  • Improve performance for queries with selective joins. (#13334)

SQL Server connector#

  • Improve performance for queries with selective joins. (#13334)

  • Prevent renaming a table with a name longer than the max length supported by SQL Server. Previously, the name was truncated to the max length. (#13073)

SPI#

  • Add @Experimental annotation to designate SPIs that are still under active development. (#13302)

  • Deprecate io.trino.spi.block.MethodHandleUtil. (#13245)