RisingWave Files

release v2.5.0

SQL features

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

Connectors

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

Installation and deployment

Cluster configuration changes

• Adds session variable streaming_separate_consecutive_join to separate consecutive stream joins to improve performance. https://github.com/risingwavelabs/risingwave/pull/22259
• Technical Preview: Adds session variable streaming_enable_unaligned_join to control whether the streaming joins should be unaligned. https://github.com/risingwavelabs/risingwave/pull/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