risingwavelabs/risingwave v1.9.1-rc.1

on GitHub

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. #16286
• SQL commands:
  • Supports DISCARD ALL command for Npgsql compatibility. #16432
  • Supports creating, dropping, altering, and showing subscriptions. #14831
  • Supports cursors for subscription queues. #15180
  • Supports altering stream rate limit for sources and tables with a source. #16399
  • Supports RECOVER command to trigger an ad-hoc recovery. #16259
• SQL functions & operators:
  • Supports using a single ASCII character as an escape character with the LIKE clause. #16057
  • Supports jsonb_populate_record() and jsonb_populate_recordset(). #13421
• System catalog:
  • Supports system table rw_iceberg_files for displaying the files of an Iceberg source or table. #16180
  • Supports system table rw_iceberg_snapshot for listing all snapshots. #16175

Connectors

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

Installation and deployment

• Sets PostgreSQL as the default meta store when deploying with Docker Compose. #16724

Cluster configuration changes

• Supports using ALTER SYSTEM to set a system-wide default value for a session parameter. #16062
• Supports setting streaming_rate_limit to zero. #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. #16433
• Introduce new timeout and retry configurations for ObjectStore and deprecate ambiguous timeout configurations. #16231

Fixes

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