Release 421 (6 Jul 2023)#
General#
- Add support for check constraints in an - UPDATEstatement. (#17195)
- Improve performance for queries involving a - yearfunction within an- INpredicate. (#18092)
- Fix failure when cancelling a query with a window function. (#18061) 
- Fix failure for queries involving the - concat_wsfunction 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 - hostnameInCertificateproperty when SSL verification is set to- FULL. (#17939)
Delta Lake connector#
Google Sheets connector#
Hive connector#
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 - AnyProtobuf type. This is disabled by default and can be enabled by setting the- kafka.protobuf-any-support-enabledconfiguration property to- true. (#17394)
MongoDB connector#
- Improve query performance on tables with - rowcolumns when only a subset of fields is needed for the query. (#17710)
Redshift connector#
- Add support for table comments. (#16900) 
SPI#
- Add the - BLOCK_AND_POSITION_NOT_NULLargument convention. (#18035)
- Add the - BLOCK_BUILDERreturn convention that writes function results directly to a- BlockBuilder. (#18094)
- Add the - READ_VALUEoperator 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)