RisingWave Labs/risingwave: Release v1.9.1

Name: risingwave

Owner: RisingWave Labs

Release: v1.9.1

Released: 2024-06-05

License: Apache-2.0

Release Assets:

• risectl-v1.9.1-aarch64-unknown-linux.tar.gz

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

• risingwave-v1.9.1-aarch64-unknown-linux-all-in-one.tar.gz

• risingwave-v1.9.1-aarch64-unknown-linux.dwp.tar.gz

• risingwave-v1.9.1-aarch64-unknown-linux.tar.gz

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

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

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

For installation and running instructions, see Get started.

Main changes

SQL features

• Query syntax:
  • Supports non-append-only temporal joins, where the outer side is not required to be append-only. https://github.com/risingwavelabs/risingwave/pull/16286
• SQL commands:
  • Supports DISCARD ALL command for Npgsql compatibility. https://github.com/risingwavelabs/risingwave/pull/16432
  • Supports creating, dropping, altering, and showing subscriptions. https://github.com/risingwavelabs/risingwave/pull/14831
  • Supports cursors for subscription queues. https://github.com/risingwavelabs/risingwave/pull/15180
  • Supports altering stream rate limit for sources and tables with a source. https://github.com/risingwavelabs/risingwave/pull/16399
  • Supports RECOVER command to trigger an ad-hoc recovery. https://github.com/risingwavelabs/risingwave/pull/16259
• SQL functions & operators:
  • Supports using a single ASCII character as an escape character with the LIKE clause. https://github.com/risingwavelabs/risingwave/pull/16057
  • Supports jsonb_populate_record() and jsonb_populate_recordset(). https://github.com/risingwavelabs/risingwave/pull/13421
• System catalog:
  • Supports system table rw_iceberg_files for displaying the files of an Iceberg source or table. https://github.com/risingwavelabs/risingwave/pull/16180
  • Supports system table rw_iceberg_snapshot for listing all snapshots. https://github.com/risingwavelabs/risingwave/pull/16175

Connectors

• Provides stable support for SQLAlchemy 2.0. https://github.com/risingwavelabs/sqlalchemy-risingwave/pull/29
• Deprecates s3 connector. https://github.com/risingwavelabs/risingwave/pull/16337
• Supports generated columns for non-shared CDC tables. https://github.com/risingwavelabs/risingwave/pull/16522
• Supports time travel for Iceberg sources. https://github.com/risingwavelabs/risingwave/pull/15866
• Blocks sink creation until backfill is completed by default. https://github.com/risingwavelabs/risingwave/pull/16249
• Supports Kafka connector parameter properties.request.required.acks. https://github.com/risingwavelabs/risingwave/pull/16482
• Adds connector parameter ssl.mode for PostgreSQL and Neon source connector. https://github.com/risingwavelabs/risingwave/pull/15690
• Adds connector parameter ssl.mode for MySQL source connector. https://github.com/risingwavelabs/risingwave/pull/16579
• Supports parameters snapshot.interval and snapshot.batch_size under WITH options when creating a table from a CDC source. https://github.com/risingwavelabs/risingwave/pull/16426
• Supports implicitly converting numeric types from PostgreSQL sources into rw_int256 or varchar. https://github.com/risingwavelabs/risingwave/pull/16346
• Supports configuring the timeout of CDC sources. https://github.com/risingwavelabs/risingwave/pull/16598
• Supports timestamptz.handling.mode formatting option when creating a source with PLAIN, UPSERT, or DEBEZIUM JSON formats. https://github.com/risingwavelabs/risingwave/pull/16265
• Only uses fragment ID as group ID for Kafka sources. https://github.com/risingwavelabs/risingwave/pull/16111
• Supports cluster URLs for Redis sink connector. https://github.com/risingwavelabs/risingwave/pull/16034
• Supports creating Delta sinks with GCS. https://github.com/risingwavelabs/risingwave/pull/16182
• Supports Snowflake sink connector. https://github.com/risingwavelabs/risingwave/pull/15429
• Supports creating upsert type BigQuery sinks. https://github.com/risingwavelabs/risingwave/pull/15780

Installation and deployment

• Sets PostgreSQL as the default meta store when deploying with Docker Compose. https://github.com/risingwavelabs/risingwave/pull/16724

Cluster configuration changes

• Supports using ALTER SYSTEM to set a system-wide default value for a session parameter. https://github.com/risingwavelabs/risingwave/pull/16062
• Supports setting streaming_rate_limit to zero. https://github.com/risingwavelabs/risingwave/pull/16333
• Supports configuring the reserved memory bytes of the compute node by using RW_RESERVED_MEMORY_BYTES runtime parameter and reserved-memory-bytes startup option. https://github.com/risingwavelabs/risingwave/pull/16433
• Introduce new timeout and retry configurations for ObjectStore and deprecate ambiguous timeout configurations. https://github.com/risingwavelabs/risingwave/pull/16231

Fixes

• Properly convert -inf, +inf, and nan types to null for JDBC sinks. https://github.com/risingwavelabs/risingwave/pull/16230
• Handles sinking -inf, +inf, and nan types for ClickHouse, Doris, and StarRocks sink connectors. https://github.com/risingwavelabs/risingwave/pull/15664
• Fixes an issue where DELETE events could not be sinked if the primary key is uuid type for JDBC sinks.https://github.com/risingwavelabs/risingwave/pull/16447
• Fixes an issue where enum types from PostgreSQL could not be ingested as varchar types. https://github.com/risingwavelabs/risingwave/pull/16423
• Fixes sources with encode avro on decimal ingesting. https://github.com/risingwavelabs/risingwave/pull/16202
• Fixes sources with encode avro on bytes/fixed/decimal default value. https://github.com/risingwavelabs/risingwave/pull/16414

Full Changelog: https://github.com/risingwavelabs/risingwave/compare/v1.8.0...v1.9.1