Release 394 (29 Aug 2022)#
General#
Add support for JSON as an output format of
EXPLAIN
. (#12968)Improve performance of queries involving joins on a single
bigint
column. (#13432)Improve performance of
LIKE
expressions. (#13479)Ensure
UPDATE
queries cannot insert null values into columns with aNOT NULL
constraint. (#13435)Fix failure when an
UPDATE
query contains aWHERE
clause which always evaluates to false. (#12422)Fix potential failure for queries involving joins and implicit or explicit casts of
null
to a concrete type. (#13565)
Docker image#
Ensure Trino stops running with insufficient resources to avoid partial failures. (#13736)
BigQuery connector#
Add
query
table function for full query pass-through to the connector. (#12502)Add support for the
INSERT
statement. (#6868)Add support for the
CREATE TABLE ... AS SELECT ...
statement. (#6869)
Delta Lake connector#
Disallow adding a column with a
NOT NULL
constraint to a table which is not empty. (#13785)Fix failure when reading Parquet data that contains only null values. (#9424)
Fix potential failure of unrelated queries after dropping a schema. (#13810)
Druid connector#
Improve performance of queries that perform filtering on
varchar
columns that contain temporal data with the formatYYYY-MM-DD
. (#12925)
Elasticsearch connector#
Add support for multiple hosts in the
elasticsearch.host
configuration property. (#12530)
Hive connector#
Add support for a Kerberos credential cache. (#13482)
Fix failure when reading Parquet data that contains only null values. (#9424)
Fix failure when the metastore returns duplicated column statistics. (#13787)
Fix potential failure of unrelated queries after dropping a schema. (#13810)
Iceberg connector#
Improve query planning performance when a
varchar
partitioning column contains date values in theYYYY-MM-DD
format. (#12925)Fix query failure when using the
[VERSION | TIMESTAMP] AS OF
clause on a table created with Iceberg versions older than 0.12. (#13613)Fix failure when reading Parquet data that contains only null values. (#9424)
Oracle connector#
Improve performance of queries that perform filtering on
varchar
columns that contain temporal data with the formatYYYY-MM-DD
. (#12925)
Phoenix connector#
Improve performance of queries that perform filtering on
varchar
columns that contain temporal data with the formatYYYY-MM-DD
. (#12925)
Pinot connector#
Add support for TLS when connecting to the Pinot controllers and brokers. (#13410)
Fix query failure when using the
HAVING
clause. (#13429)
PostgreSQL connector#
Improve performance of queries that perform filtering on
varchar
columns that contain temporal data with the formatYYYY-MM-DD
. (#12925)Prevent using a column name which is longer than the maximum length supported by PostgreSQL. Previously, long names were truncated. (#13742)
SQL Server connector#
Prevent renaming a column to a name which is longer than the maximum length supported by SQL Server. Previously, long names were truncated. (#13742)
SPI#
Add the query plan in JSON format to
QueryCompletedEvent
, and allow connectors to request anonymized query plans in theQueryCompletedEvent
. (#12968)