Release 465 (20 Nov 2024)#

General#

  • Add the cosine_similarity() function for dense vectors. (#23964)

  • Add support for reading geometries in EWKB format with the ST_GeomFromBinary() function. (#23824)

  • Add support for parameter of bigint type for the repeat() function. (#22867)

  • Add support for the ORDER BY clause in a windowed aggregate function. (#23929)

  • ⚠️ Breaking change: Change the data type for client_info in the MySQL event listener to MEDIUMTEXT. (#22362)

  • Improve performance of queries with selective joins. (#22824)

  • Improve performance when using various string functions in queries involving joins. (#24182)

  • Reduce chance of out of memory query failure when retry-policy is set to task. (#24114)

  • Prevent some query failures when retry-policy is set to task. (#24165)

JDBC driver#

  • Add support for LocalDateTime and Instant in getObject and setObject. (#22906)

CLI#

  • Fix incorrect quoting of output values when the CSV_UNQUOTED or the CSV_HEADER_UNQUOTED format is used. (#24113)

BigQuery connector#

  • Fix failure when reading views with timestamp columns. (#24004)

Cassandra connector#

  • ⚠️ Breaking change: Require setting the cassandra.security configuration property to PASSWORD along with cassandra.username and cassandra.password for password-based authentication. (#23899)

Clickhouse connector#

  • Fix insert of invalid time zone data for tables using the timestamp with time zone type. (#23785)

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Delta Lake connector#

  • Add support for customer-provided SSE key in S3 file system. (#22992)

  • Fix incorrect results for queries filtering on a partition columns and the NAME column mapping mode is used. (#24104)

Druid connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Exasol connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Faker connector#

  • Add the random_string() catalog function. (#23990)

  • Make generated data deterministic for repeated queries. (#24008)

  • Allow configuring locale with the faker.locale configuration property. (#24152)

Hive connector#

  • Add support for skipping archiving when committing to a table in the Glue metastore and the hive.metastore.glue.skip-archive configuration property is set to true. (#23817)

  • Add support for customer-provided SSE key in S3 file system. (#22992)

Hudi connector#

Iceberg connector#

  • Add support for reading and writing arbitrary table properties with the extra_properties table property. (#17427, #24031)

  • Add the spec_id, partition, sort_order_id, and readable_metrics columns to the $files metadata table. (#24102)

  • Add support for configuring an OAuth2 server URI with the iceberg.rest-catalog.oauth2.server-uri configuration property. (#23086)

  • Add support for retrying requests to a JDBC catalog with the iceberg.jdbc-catalog.retryable-status-codes configuration property. (#23095)

  • Add support for case-insensitive name matching in the REST catalog. (#23715)

  • Add support for customer-provided SSE key in S3 file system. (#22992)

  • Disallow adding duplicate files in the add_files and add_files_from_table procedures. (#24188)

  • Improve performance of Iceberg queries involving multiple table scans. (#23945)

  • Prevent MERGE, UPDATE, and DELETE query failures for tables with equality deletes. (#15952)

Ignite connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

MariaDB connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

MySQL connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Oracle connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

PostgreSQL connector#

  • Add support for the geometry type. (#5580)

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Redshift connector#

  • Add support pushing down casts from varchar to varchar and char to char into Redshift. (#23808)

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

SingleStore connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Snowflake connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

SQL Server connector#

  • Update required SQL Server version to SQL Server 2019 or higher. (#24173)

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

Vertica connector#

  • Fix connector initialization issue when multiple catalogs with the connector are configured. (#24058)

SPI#

  • ⚠️ Breaking change: Remove deprecated variants of checkCanExecuteQuery and checkCanSetSystemSessionProperty without a QueryId parameter from SystemAccessControl. (#23244)