v2.5.0

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