Release 374 (17 Mar 2022)#
General#
- Add support for query parameters in - CREATE SCHEMA. (#11485)
- Improve performance when reading from S3-based spool for fault-tolerant execution. (#11050) 
- Improve performance of queries with - GROUP BYclauses. (#11392)
- Improve performance of - GROUP BYwith a large number of groups. (#11011)
- Improve handling of queries where individual tasks require lots of memory when - retry-policyis set to- TASK. (#10432)
- Produce better query plans by improving cost-based-optimizer estimates in the presence of correlated columns. (#11324) 
- Fix memory accounting and improve performance for queries involving certain variable-width data types such as - varcharor- varbinary. (#11315)
- Fix performance regression for - GROUP BYqueries. (#11234)
- Fix - trim,- ltrimand- rtimfunction results when the argument is- chartype. Previously, it returned padded results as- chartype. It returns- varchartype without padding now. (#11440)
JDBC driver#
CLI#
- Add support for selecting Vim or Emacs editing modes with the - --editing-modecommand line argument. (#3377)
Cassandra connector#
- Add support for TRUNCATE TABLE. (#11425) 
- Fix incorrect query results for certain complex queries. (#11083) 
ClickHouse connector#
- Add support for - uint8,- uint16,- uint32and- uint64types. (#11490)
Delta Lake connector#
Hive connector#
Iceberg connector#
MongoDB connector#
- Add support for - CREATE SCHEMAand- DROP SCHEMA. (#11409)
- Add support for - COMMENT ON TABLE. (#11424)
- Add support for - COMMENT ON COLUMN. (#11457)
- Support storing a comment when adding new columns. (#11487) 
PostgreSQL connector#
- Improve performance of queries involving - ORwith simple comparisons and- LIKEpredicates by pushing predicate computation to the PostgreSQL database. (#11086)
- Improve performance of aggregation queries with certain complex predicates by computing predicates and aggregations within PostgreSQL. (#11083) 
- Fix possible connection leak when connecting to PostgreSQL failed. (#11449) 
SingleStore (MemSQL) connector#
- The connector now uses the official Single Store JDBC Driver. As a result, - connection-urlin catalog configuration files needs to be updated from- jdbc:mariadb:...to- jdbc:singlestore:.... (#10669)
- Deprecate - memsqlas the connector name. We recommend using- singlestorein the- connector.nameconfiguration property. (#11459)