v1.6.0
For installation and running instructions, see Get started.
Main changes
SQL features
- Query syntax:
- Allows
NOW
in upper bound condition for temporal filters. #13985 - Supports temporal filters with multiple
OR
expressions. #14382 - Supports
<expr> [ NOT ] SIMILAR TO <pat> [ ESCAPE <esc_text> ]
clause. #14000 - Breaking change: Fixes the correctness of
SOME
,ALL
, andANY
expressions. Drop and recreate any materialized views that use these expressions. #14221 - Supports array subquery and \du command. #14044
- Supports
SET PARALLELISM
clause forALTER
commands. #14240
- Allows
- SQL commands:
- SQL functions & operators:
- System catalog:
- Add system view
rw_streaming_parallelism
. #14261
- Add system view
Connectors
- Adds CDC backfill support for Postgres so users can ingest multiple PostgreSQL tables with a single replication slot. #13958
- Support multi-table transaction from upstream MySQL & Postgres CDC. Specify
transactional = true
in theWITH
options to enabled it. #14375 - Renames
scan.startup.timestamp_millis
toscan.startup.timestamp.millis
for Kafka, Pulsar and NATS source. #13656 - Adds
properties.ssl.endpoint.identification.algorithm
parameter for Kafka source and sink.#13990 - Supports
FORMAT PLAIN ENCODE PROTOBUF
syntax for Kafka sink. #12858 - Supports GCS file source. #13414
- Breaking change: For ClickHouse sinks,
timestamptz
can be sinked toDateTime64
.timestamp
cannot be sinked and has to be converted totimestamptz
first before being sinked. #13672 - For Elasticsearch sinks, the default es.type is set as
_doc
for Elasticsearch 6.x and 7.x. #14273 connector = 'iceberg_java'
is deprecated, and users can only Iceberg sinks with the Rust version of Iceberg. Similarly, the DeltaLake sink will also use the Rust version implementation. #14277- Supports StarRocks sink. #12681
Installation and deployment
- Allows for
storage.prefetch_buffer_capacity_mb
to be configured in the TOML file to prevent out of memory issues. #13558 - Supports Huawei Cloud OBS as the storage backend. #13844
Cluster configuration changes
- Supports setting
statement_timeout
value for queries. #13933 - Exposes SSL functionality through
RW_SSL_CERT
andRW_SSL_KEY
environment variables to configure SSL certificates and key file location. #14062
Full Changelog: v1.5.0...v1.6.0