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 BY
clauses. (#11392)Improve performance of
GROUP BY
with a large number of groups. (#11011)Improve handling of queries where individual tasks require lots of memory when
retry-policy
is set toTASK
. (#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
varchar
orvarbinary
. (#11315)Fix performance regression for
GROUP BY
queries. (#11234)Fix
trim
,ltrim
andrtim
function results when the argument ischar
type. Previously, it returned padded results aschar
type. It returnsvarchar
type without padding now. (#11440)
JDBC driver#
CLI#
Add support for selecting Vim or Emacs editing modes with the
--editing-mode
command 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
,uint32
anduint64
types. (#11490)
Delta Lake connector#
Hive connector#
Iceberg connector#
MongoDB connector#
Add support for
CREATE SCHEMA
andDROP 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
OR
with simple comparisons andLIKE
predicates 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-url
in catalog configuration files needs to be updated fromjdbc:mariadb:...
tojdbc:singlestore:...
. (#10669)Deprecate
memsql
as the connector name. We recommend usingsinglestore
in theconnector.name
configuration property. (#11459)