Release 427 (26 Sep 2023)#
General#
- Add support for comparing IPv4 and IPv6 addresses and CIDRs with contains. (#18497) 
- Improve performance of - GROUP BYand- DISTINCT. (#19059)
- Reduce coordinator memory footprint when scannning tables. (#19009) 
- Fix failure due to exceeding node memory limits with - INSERTstatements. (#18771)
- Fix query hang for certain - LIKEpatterns involving a mix of- %and- _. (#19146)
Security#
- Ensure authorization is checked when accessing table comments with table redirections. (#18514) 
Delta Lake connector#
- Add support for reading tables with Deletion Vectors. (#16903) 
- Add support for writing columns with the - timestamp(p)type. (#16927)
- Reduce data read from Parquet files for queries with filters. (#19032) 
- Improve performance of writing to Parquet files. (#19122) 
- Fix error reading Delta Lake table history when the initial transaction logs have been removed. (#18845) 
Elasticsearch connector#
- Fix query failure when a - LIKEclause contains multi-byte characters. (#18966)
Hive connector#
- Add support for changing column comments when using the Glue catalog. (#19076) 
- Reduce data read from Parquet files for queries with filters. (#19032) 
- Improve performance of reading text files. (#18959) 
- Allow changing a column’s type from - doubleto- varcharin Hive tables. (#18930)
- Remove legacy Hive readers and writers. The - *_native_reader_enabledand- *_native_writer_enabledsession properties and- *.native-reader.enabledand- *.native-writer.enabledconfiguration properties are removed. (#18241)
- Remove support for S3 Select. The - s3_select_pushdown_enabledsession property and the- hive.s3select*configuration properties are removed. (#18241)
- Remove support for disabling optimized symlink listing. The - optimize_symlink_listingsession property and- hive.optimize-symlink-listingconfiguration property are removed. (#18241)
- Fix incompatibility with Hive OpenCSV deserialization. As a result, when the escape character is explicitly set to - ", a- \(backslash) must be used instead. (#18918)
- Fix performance regression when reading CSV files on AWS S3. (#18976) 
- Fix failure when creating a table with a - varchar(0)column. (#18811)
Hudi connector#
Iceberg connector#
- Add support for usage of - dateand- timestamparguments in- FOR TIMESTAMP AS OFexpressions. (#14214)
- Add support for using tags with - AS OF VERSIONqueries. (#19111)
- Reduce data read from Parquet files for queries with filters. (#19032) 
- Improve performance of writing to Parquet files. (#19090) 
- Improve performance of reading tables with many equality delete files. (#17114) 
Ignite connector#
- Add support for - UPDATE. (#16445)
MariaDB connector#
- Add support for - UPDATE. (#16445)
MongoDB connector#
- Fix query failure when mapping MongoDB - Decimal128values with leading zeros. (#19068)
MySQL connector#
Oracle connector#
PostgreSQL connector#
- Add support for - UPDATE. (#16445)
Redshift connector#
- Add support for - UPDATE. (#16445)
SingleStore connector#
- Add support for - UPDATE. (#16445)
SQL Server connector#
- Add support for - UPDATE. (#16445)
SPI#
- Change - BlockBuilderto no longer extend- Block. (#18738)