Release 421 (6 Jul 2023)#

General#

  • Add support for check constraints in an UPDATE statement. (#17195)

  • Improve performance for queries involving a year function within an IN predicate. (#18092)

  • Fix failure when cancelling a query with a window function. (#18061)

  • Fix failure for queries involving the concat_ws function on arrays with more than 254 values. (#17816)

  • Fix query failure or incorrect results when coercing a structural data type that contains a timestamp. (#17900)

JDBC driver#

  • Add support for using an alternative hostname with the hostnameInCertificate property when SSL verification is set to FULL. (#17939)

Delta Lake connector#

  • Add support for check constraints and column invariants in UPDATE statements. (#17195)

  • Add support for creating tables with the column mapping mode. (#12638)

  • Add support for using the OPTIMIZE procedure on column mapping tables. (#17527)

  • Add support for DROP COLUMN. (#15792)

Google Sheets connector#

Hive connector#

  • Add Hive partition projection column properties to the output of SHOW CREATE TABLE. (#18076)

  • Fix incorrect query results when using S3 Select with IS NULL or IS NOT NULL predicates. (#17563)

  • Fix incorrect query results when using S3 Select and a table’s null_format field is set. (#17563)

Iceberg connector#

  • Add support for migrating a bucketed Hive table into a non-bucketed Iceberg table. (#18103)

Kafka connector#

  • Add support for reading Protobuf messages containing the Any Protobuf type. This is disabled by default and can be enabled by setting the kafka.protobuf-any-support-enabled configuration property to true. (#17394)

MongoDB connector#

  • Improve query performance on tables with row columns when only a subset of fields is needed for the query. (#17710)

Redshift connector#

SPI#

  • Add the BLOCK_AND_POSITION_NOT_NULL argument convention. (#18035)

  • Add the BLOCK_BUILDER return convention that writes function results directly to a BlockBuilder. (#18094)

  • Add the READ_VALUE operator that can read a value from any argument convention to any return convention. (#18094)

  • Remove write methods from the BlockBuilder interface. (#17342)

  • Change array, map, and row build to use a single writeEntry. (#17342)