RisingWave Labs/risingwave: Release v1.6.0

Name: risingwave

Owner: RisingWave Labs

Release: v1.6.0

Released: 2024-01-11

License: Apache-2.0

Release Assets:

• risectl-v1.6.0-x86_64-unknown-linux.tar.gz

• risingwave-v1.6.0-x86_64-unknown-linux-all-in-one.tar.gz

• risingwave-v1.6.0-x86_64-unknown-linux.dwp.tar.gz

• risingwave-v1.6.0-x86_64-unknown-linux.tar.gz

For installation and running instructions, see Get started.

Main changes

SQL features

• Query syntax:
  • Allows NOW in upper bound condition for temporal filters. https://github.com/risingwavelabs/risingwave/pull/13985
  • Supports temporal filters with multiple OR expressions. https://github.com/risingwavelabs/risingwave/pull/14382
  • Supports <expr> [ NOT ] SIMILAR TO <pat> [ ESCAPE <esc_text> ] clause. https://github.com/risingwavelabs/risingwave/pull/14000
  • Breaking change: Fixes the correctness of SOME, ALL, and ANY expressions. Drop and recreate any materialized views that use these expressions. https://github.com/risingwavelabs/risingwave/pull/14221
  • Supports array subquery and \du command. https://github.com/risingwavelabs/risingwave/pull/14044
  • Supports SET PARALLELISM clause for ALTER commands. https://github.com/risingwavelabs/risingwave/pull/14240
• SQL commands:
  • Technical preview feature: Supports CREATE SINK INTO TABLE. Multiple sinks can use the same table as the target. https://github.com/risingwavelabs/risingwave/pull/13185, https://github.com/risingwavelabs/risingwave/pull/13659
• SQL functions & operators:
  • Breaking change: 0b10 is now interpreted as binary 10 instead of 0 as b10. Integer literals can be given in hex 0x, oct 0o and bin 0b. https://github.com/risingwavelabs/risingwave/pull/14262
  • Supports interval type as input for to_char(). https://github.com/risingwavelabs/risingwave/pull/14071
• System catalog:
  • Add system view rw_streaming_parallelism. https://github.com/risingwavelabs/risingwave/pull/14261

Connectors

• Adds CDC backfill support for Postgres so users can ingest multiple PostgreSQL tables with a single replication slot. https://github.com/risingwavelabs/risingwave/pull/13958
• Support multi-table transaction from upstream MySQL & Postgres CDC. Specify transactional = true in the WITH options to enabled it. https://github.com/risingwavelabs/risingwave/pull/14375
• Renames scan.startup.timestamp_millis to scan.startup.timestamp.millis for Kafka, Pulsar and NATS source. https://github.com/risingwavelabs/risingwave/pull/13656
• Adds properties.ssl.endpoint.identification.algorithm parameter for Kafka source and sink.https://github.com/risingwavelabs/risingwave/pull/13990
• Supports FORMAT PLAIN ENCODE PROTOBUF syntax for Kafka sink. https://github.com/risingwavelabs/risingwave/pull/12858
• Supports GCS file source. https://github.com/risingwavelabs/risingwave/pull/13414
• Breaking change: For ClickHouse sinks, timestamptz can be sinked to DateTime64. timestamp cannot be sinked and has to be converted to timestamptz first before being sinked. https://github.com/risingwavelabs/risingwave/pull/13672
• For Elasticsearch sinks, the default es.type is set as _doc for Elasticsearch 6.x and 7.x. https://github.com/risingwavelabs/risingwave/pull/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. https://github.com/risingwavelabs/risingwave/pull/14277
• Supports StarRocks sink. https://github.com/risingwavelabs/risingwave/pull/12681

Installation and deployment

• Allows for storage.prefetch_buffer_capacity_mb to be configured in the TOML file to prevent out of memory issues. https://github.com/risingwavelabs/risingwave/pull/13558
• Supports Huawei Cloud OBS as the storage backend. https://github.com/risingwavelabs/risingwave/pull/13844

Cluster configuration changes

• Supports setting statement_timeout value for queries. https://github.com/risingwavelabs/risingwave/pull/13933
• Exposes SSL functionality through RW_SSL_CERT and RW_SSL_KEY environment variables to configure SSL certificates and key file location. https://github.com/risingwavelabs/risingwave/pull/14062

Full Changelog: https://github.com/risingwavelabs/risingwave/compare/v1.5.0...v1.6.0