Release 453 (25 Jul 2024)#

General#

  • Improve accuracy of the cosine_distance() function. (#22761)

  • Improve performance of non-equality joins. (#22521)

  • Improve performance for column masking with Open Policy Agent access control. (#21359)

  • Fix incorrect evaluation of repeated non-deterministic functions. (#22683)

  • Fix potential failure for queries involving GROUP BY, UNNEST, and filters over expressions that may produce an error for certain inputs. (#22731)

  • Fix planning failure for queries with a filter on an aggregation. (#22716)

  • Fix planning failure for queries involving multiple aggregations and CASE expressions. (#22806)

  • Fix optimizer timeout for certain queries involving aggregations and CASE expressions. (#22813)

Security#

  • Add support for IF EXISTS to DROP ROLE. (#21985)

JDBC driver#

  • Add support for using certificates from the operating system keystore. (#22341)

  • Add support for setting the default SQL PATH. (#22703)

  • Allow Trino host URI specification without port for the default ports 80 for HTTP and 443 for HTTPS. (#22724)

CLI#

  • Add support for using certificates from the operating system keystore. (#22341)

  • Add support for setting the default SQL PATH. (#22703)

  • Allow Trino host URI specification without port for the default ports 80 for HTTP and 443 for HTTPS. (#22724)

BigQuery connector#

  • Improve performance when querying information schema. (#22770)

Cassandra connector#

  • Add support for the execute procedure. (#22556)

ClickHouse connector#

  • Add support for the execute procedure. (#22556)

Delta Lake connector#

  • Add support for reading partition columns whose type changed via type widening. (#22433)

  • Add support for authenticating with Glue with a Kubernetes service account. This can be enabled via the hive.metastore.glue.use-web-identity-token-credentials-provider configuration property. (#15267)

  • Fix failure when executing the VACUUM procedure on tables without old transaction logs. (#22816)

Druid connector#

  • Add support for the execute procedure. (#22556)

Exasol connector#

  • Add support for the execute procedure. (#22556)

Hive connector#

  • Add support for authenticating with Glue with a Kubernetes service account. This can be enabled via the hive.metastore.glue.use-web-identity-token-credentials-provider configuration property. (#15267)

  • Fix failure to read Hive tables migrated to Iceberg with Apache Spark. (#11338)

  • Fix failure for CREATE FUNCTION with SQL UDF storage in Glue when hive.metastore.glue.catalogid is set. (#22717)

Hudi connector#

  • Add support for authenticating with Glue with a Kubernetes service account. This can be enabled via the hive.metastore.glue.use-web-identity-token-credentials-provider configuration property. (#15267)

Iceberg connector#

  • ⚠️ Breaking change: Change the schema version for the JDBC catalog database to V1. The previous value can be restored by setting the iceberg.jdbc-catalog.schema-version configuration property to V0. (#22576)

  • Add support for views with the JDBC catalog. Requires an upgrade of the schema for the JDBC catalog database to V1. (#22576)

  • Add support for specifying on which schemas to enforce the presence of a partition filter in queries. This can be configured query-partition-filter-required-schemas property. (#22540)

  • Add support for authenticating with Glue with a Kubernetes service account. This can be enabled via the hive.metastore.glue.use-web-identity-token-credentials-provider configuration property. (#15267)

  • Fix failure when executing DROP SCHEMA ... CASCADE using the REST catalog with Iceberg views. (#22758)

Ignite connector#

  • Add support for the execute procedure. (#22556)

MariaDB connector#

  • Add support for the execute procedure. (#22556)

MySQL connector#

  • Add support for the execute procedure. (#22556)

Oracle connector#

  • Add support for the execute procedure. (#22556)

Phoenix connector#

  • Add support for the execute procedure. (#22556)

PostgreSQL connector#

  • Add support for reading the vector type on pgvector. (#22630)

  • Add support for the execute procedure. (#22556)

Redshift connector#

  • Add support for the execute procedure. (#22556)

SingleStore connector#

  • Add support for the execute procedure. (#22556)

Snowflake connector#

  • Add support for the execute procedure. (#22556)

SQL Server connector#

  • Add support for the execute procedure. (#22556)

SPI#

  • Add SystemAccessControl.getColumnMasks as replacement for the deprecated SystemAccessControl.getColumnMask. (#21997)