Release 356 (30 Apr 2021)#

General#

  • Add support for MATCH_RECOGNIZE. (#6111)

  • Add soundex() function. (#4022)

  • Introduce system.metadata.materialized_view_properties table for listing available materialized view properties. (#7615)

  • Add support for limiting the maximum planning time via the query.max-planning-time configuration property. (#7213)

  • Allow redirecting clients to an alternative location to fetch query information. This can be configured via the query.info-url-template configuration property. (#7678)

  • Allow cancellation of queries during planning phase. (#7213)

  • Improve performance of ORDER BY ... LIMIT queries over a LEFT JOIN. (#7028)

  • Improve performance of queries with predicates on boolean columns. (#7263)

  • Improve planning time for queries with large IN predicates. (#7556)

  • Improve performance of queries that contain joins on varchar keys of different length. (#7644)

  • Improve performance of queries when late materialization is enabled. (#7695)

  • Reduce coordinator network overhead when scheduling queries. (#7351)

  • Fix possible deadlock for JOIN queries when spilling is enabled. (#7455)

  • Fix incorrect results for queries containing full outer join with an input that is known to produce one row. (#7629)

  • Fix failure when quantified comparison expressions contain scalar subqueries. (#7792)

Security#

  • Materialized views require UPDATE privilege to be refreshed. (#7707)

  • Add dedicated access control for creating and dropping materialized views. (#7645)

  • Add dedicated access control for refreshing materialized views. Insert privilege on storage table is no longer required. (#7707)

  • Fix authentication failure when providing multiple scope values for http-server.authentication.oauth2.scopes. (#7706)

JDBC driver#

  • Add support for caching OAuth2 credentials in memory to avoid unnecessary authentication flows. (#7309)

BigQuery connector#

  • Add support for CREATE SCHEMA and DROP SCHEMA statements. (#7543)

  • Improve table listing performance when case insensitive matching is enabled. (#7628)

Cassandra connector#

  • Fix NullPointerException when reading an empty timestamp value. (#7433)

Hive connector#

  • Improve performance when reading dictionary-encoded Parquet files. (#7754)

  • Fix incorrect results when referencing nested fields with non-lowercase names from ORC files. (#7350)

  • Always use row-by-row deletes for ACID tables rather than dropping partitions. (#7621)

  • Allow reading from ORC ACID transactional tables when _orc_acid_version metadata files are missing. (#7579)

  • Add UPDATE support for ACID tables that were originally created as non-transactional. (#7622)

  • Add support for connection proxying for Azure ADLS endpoints. (#7509)

Iceberg connector#

  • Show Iceberg tables created by other engines in SHOW TABLES output. (#1592)

  • Improve performance when reading dictionary-encoded Parquet files. (#7754)

  • Improve query planning through table metadata caching. (#7336)

  • Fix failure querying materialized views that were created using the session catalog and schema. (#7711)

  • Fix listing of materialized views when using SHOW TABLES query. (#7790)

Kafka connector#

  • Add support for TLS security protocol. (#6929)

MemSQL connector#

  • Improve metadata caching hit rate. (#7039)

MongoDB connector#

  • Fix handling of non-lowercase MongoDB views. (#7491)

MySQL connector#

  • Improve metadata caching hit rate. (#7039)

  • Exclude an internal sys schema from schema listings. (#6337)

Oracle connector#

  • Improve metadata caching hit rate. (#7039)

Phoenix connector#

  • Improve metadata caching hit rate. (#7039)

PostgreSQL connector#

  • Improve metadata caching hit rate. (#7039)

  • Cancel query on PostgreSQL when the Trino query is cancelled. (#7306)

  • Discontinue support for PostgreSQL 9.5, which has reached end of life. (#7676)

Redshift connector#

  • Improve metadata caching hit rate. (#7039)

SQL Server connector#

  • Improve metadata caching hit rate. (#7039)

  • Fix query failure when snapshot isolation is disabled in target SQL Server database, but READ_COMMITTED_SNAPSHOT is still enabled. (#7548)

  • Fix reading date values before 1583-10-14. (#7634)

SPI#

  • Require that ConnectorMaterializedViewDefinition provides a view owner. (#7489)

  • Add Connector#getMaterializedViewPropertyManager for specifying materialized view properties. (#7615)

  • Add ConnectorAccessControl.checkCanCreateMaterializedView() and ConnectorAccessControl.checkCanDropMaterializedView() for authorizing creation and removal of materialized views. (#7645)

  • Allow a materialized view to return a storage table in a different catalog or schema. (#7638)

  • Add ConnectorAccessControl.checkCanRefreshMaterializedView() for authorizing refresh of materialized views. (#7707)