Skip to main content

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 a NOT NULL constraint. (#13435)
  • Fix failure when an UPDATE query contains a WHERE 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 format YYYY-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 the YYYY-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 format YYYY-MM-DD. (#12925)

Phoenix connector​

  • Improve performance of queries that perform filtering on varchar columns that contain temporal data with the format YYYY-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 format YYYY-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 the QueryCompletedEvent. (#12968)