release v2.5.3

release v2.6.1

release v2.5.2

release v2.6.0

SQL features

• SQL commands:
  • Supports using CREATE INDEX to create vector indexes, including flat and HNSW methods, and allows creating vector indexes on function expressions. #22432, #22022, #22808
  • CREATE SINK supports auto.schema.change option for Elasticsearch, Redshift, and Snowflake. #22611
  • DROP CONNECTION supports CASCADE option to automatically drop dependent objects, except for Iceberg connections. #22557
  • DROP FUNCTION supports CASCADE option to automatically remove dependent objects. #22991
  • Supports using multiple version columns to resolve upsert conflicts. #22931
• SQL functions & operators:
  • Supports new data type vector(n). #22019
  • Supports jsonb_to_array function to convert a JSONB array into a SQL array of JSONB elements. #22777
  • openai_embedding accepts a single constant JSONB config parameter instead of separate api_key and model arguments. #22960
  • Supports arg_min and arg_max aggregate functions. #22895
• System catalog:
  • Adds system function has_database_privilege. #22576

Connectors

• Public preview: Iceberg table engine supports copy-on-write write mode for enhanced compaction. #22713
• Supports Redshift and Snowflake v2 sink connectors. You can use intermediate table and leverage S3 to improve sink performance, and auto schema change is supported to automatically add new columns. #22984
• Iceberg table engine and Iceberg sink support VACUUM [FULL] schema_name.object_name syntax. #22942
• NATS connector no longer creates stream automatically unless new option allow_create_stream is explicitly set to true . #22315
• Kafka source supports altering group.id.prefix parameter at runtime. #22492
• For Kafka source, when querying with a timestamp beyond the latest message, it starts from the latest offset instead of resetting to the earliest. #22413
• MQTT source supports multiple comma-separated topics. #22074
• Postgres CDC supports parallelized CDC backfill. #22536
• For PostgreSQL CDC, if you’ve already created a publication, fewer permissions are required. #22807
• Supports TOASTed data from PostgreSQL when using the CDC connector. #22852

Installation and deployment

• Supports deploying lakekeeper as an Iceberg REST catalog via Docker compose or Kubernetes. #23045
• Supports using HashiCorp Vault as secret backend with Token or AppRole authentication methods. #22627

Cluster configuration changes

• Supports Memory-Only Mode for faster, low-latency queries by fully loading operator states into memory. You can configure it at the operator level to balance performance and memory usage. #22857
• Adds session variable streaming_separate_consecutive_join to separate consecutive stream joins to improve performance. #22259
• Adds session variable streaming_join_encoding to switch join encoding type. #22416
• Adds session variable streaming_separate_sink to separate sink. #22827
• Adds protect_drop_table_with_incoming_sink to block table drops if incoming sinks exist. #22347
• Adds streaming_now_progress_ratio to decouple now_timestamp from epoch_timestamp. #22487

Access control list (ACL)

• Adds a new superuser rwadmin for the Cloud control plane. #22327

Assets

• Run this version from Docker:
  docker run -it --pull=always -p 4566:4566 -p 5691:5691 risingwavelabs/risingwave:v2.6.0 standalone
• Prebuilt all-in-one library for Linux
• Source code (zip)
• Source code (tar.gz)
• risectl - a CLI tool for managing and accessing RisingWave clusters

release v2.6.0-rc.1

release v2.4.4

release v2.5.1

release v2.5.0

SQL features

• SQL commands:
  • Supports ALTER DEFAULT PRIVILEGES command to set privileges for objects created in the future. #22191
  • The public schema is now managed by GRANT / REVOKE command. New non-super users should first be granted privileges before creating objects. #20201
  • Technical Preview: Adds option backfill_order to define the ingestion order of streams during backfill in case of join amplification. #20967
  • Supports ALTER COLUMN TYPE syntax in ALTER TABLE to change the data type of struct columns. Changing between primitive types (e.g., int → bigint) is not supported. #20940
  • SHOW PROCESSLIST now displays queries from all serving nodes, making it easier to troubleshoot distributed queries. #21952
  • Supports CONNECTOR WITH clause for ALTER SINK command. #20691
  • Supports per-database configuration for barrier_interval_ms and checkpoint_frequency. #22178
• SQL functions & operators:
  • Technical preview: Supports approx_count_distinct to estimate the number of distinct values. #21516, #21545
  • Supports array_flatten to flatten an array of arrays. #21640
  • Supports openai_embedding function to generate embeddings. #22242
  • Supports WINDOW clause and window function over named window. #22024
  • Technical Preview: Supports map_filter function to filter map data. #22077
  • Supports the concatenation operator (||), position, and overlay functions for bytea data type. #22076
• System catalog:
  • Adds system catalog rw_fragment_backfill_progress to track the progress of each backfill partition. #22124

Connectors

• Supports Iceberg compaction for Iceberg table engine. #22043
• Supports hosted_catalog=true to enable RisingWave-managed SQL catalog in Iceberg table engine. #21351
• Supports enable_config_load for Iceberg sink, source, connection, and Iceberg table engine. #21938
• Supports partition_by for Iceberg table engine as the Iceberg sink. #21594
• Technical Preview: Webhook source supports receiving batches of updates at once. #22075
• Technical Preview: Supports sink_decouple for creating sink into table. #21784
• Supports using ALTER SINK ... CONNECTOR WITH to update connector-specific properties without recreating the sink. #20691
• Breaking change: Adds escape syntax and usage instructions for the TEMPLATE encoding format. #21431

Installation and deployment

Cluster configuration changes

• Adds session variable streaming_separate_consecutive_join to separate consecutive stream joins to improve performance. #22259
• Technical Preview: Adds session variable streaming_enable_unaligned_join to control whether the streaming joins should be unaligned. #20386

Assets

• Run this version from Docker:
  docker run -it --pull=always -p 4566:4566 -p 5691:5691 risingwavelabs/risingwave:v2.5.0 standalone
• Prebuilt all-in-one library for Linux
• Source code (zip)
• Source code (tar.gz)
• risectl - a CLI tool for managing and accessing RisingWave clusters

release v2.5.0-rc.1

release v2.4.3