RisingWave Labs/risingwave: Release v1.10.0

Name: risingwave

Owner: RisingWave Labs

Release: v1.10.0

Released: 2024-07-30

License: Apache-2.0

Release Assets:

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

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

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

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

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

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

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

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

For installation and running instructions, see Get started.

Main changes

SQL features

• SQL commands:
  • Supports specifying the authorization and omitting the schema name when creating a schema. https://github.com/risingwavelabs/risingwave/pull/16806
  • Supports session window in batch and emit-on-window-close mode. https://github.com/risingwavelabs/risingwave/pull/17098
  • Supports fetching multiple rows from subscription cursor. https://github.com/risingwavelabs/risingwave/pull/16764
• SQL functions & operators:
  • Supports has_table_privilege(), has_schema_privilege(), and has_any_column_privilege(). https://github.com/risingwavelabs/risingwave/pull/16674
  • Supports quote_literal() and quote_nullable(). https://github.com/risingwavelabs/risingwave/pull/16807
  • Supports pg_get_keywords(). https://github.com/risingwavelabs/risingwave/pull/17033
  • Supports jsonb_set(). https://github.com/risingwavelabs/risingwave/pull/17124
  • Supports user-defined aggregate functions for embedded Python and JavaScript UDFs. https://github.com/risingwavelabs/risingwave/pull/16874
  • Allows the specified time zone of AT TIME ZONE to be non-literal. https://github.com/risingwavelabs/risingwave/pull/17395
• System catalog:
  • Supports rw_catalog.actor_id_to_ddl and rw_catalog.fragment_id_to_ddl. https://github.com/risingwavelabs/risingwave/pull/17229

Connectors

• Avro schemas with "default": "NaN" and positive and negative infinities, are supported as float and double types. https://github.com/risingwavelabs/risingwave/pull/17309
• Supports ingesting simple AVRO MAP types as JSONB. https://github.com/risingwavelabs/risingwave/pull/16948
• Supports ingesting avro uuid types as varchar. https://github.com/risingwavelabs/risingwave/pull/17069
• Supports ingesting avro with internal Ref types. https://github.com/risingwavelabs/risingwave/pull/17052
• Adds aws prefix to AWS related parameters when creating a source or sink. https://github.com/risingwavelabs/risingwave/pull/16671
• Supports using AWS IAM to connect to Amazon MSK. https://github.com/risingwavelabs/risingwave/pull/16625
• Adds pubsub.parallelism under the WITH option for Google PubSub source. https://github.com/risingwavelabs/risingwave/pull/16733
• Supports INCLUDE TIMESTAMP [AS] clause for MySQL, PostgreSQL, and MongoDB CDC tables.https://github.com/risingwavelabs/risingwave/pull/16833
• Supports additional metadata columns for CDC tables. https://github.com/risingwavelabs/risingwave/pull/17051
• Automatically maps upstream table schema when creating MySQL and PostgreSQL tables. https://github.com/risingwavelabs/risingwave/pull/16986
• Sets a network timeout for JDBC sink connections. https://github.com/risingwavelabs/risingwave/pull/17244
• Enables sink decouple by default for Kafka, Kinesis, Pulsar, Google Pub/Sub, NATS, MQTT, ClickHouse sinks. https://github.com/risingwavelabs/risingwave/pull/17221
• Supports the KEY ENCODE clause when creating a sink. https://github.com/risingwavelabs/risingwave/pull/16377
• Supports FORMAT PLAIN ENCODE AVRO for Kafka sinks. https://github.com/risingwavelabs/risingwave/pull/17216
• Supports DynamoDB sink. https://github.com/risingwavelabs/risingwave/pull/16670
• Supports Microsoft SQL Server sinks for self-hosted SQL Server and Azure SQL. https://github.com/risingwavelabs/risingwave/pull/17154
• Supports OpenSearch sink. https://github.com/risingwavelabs/risingwave/pull/16330
• Supports checkpoint decouple for StarRocks sinks. https://github.com/risingwavelabs/risingwave/pull/16816
• Supports checkpoint decouple for Delta Lake sinks. https://github.com/risingwavelabs/risingwave/pull/16777
• Supports sinking serial types. https://github.com/risingwavelabs/risingwave/pull/16969

Cluster configuration changes

• Sets arrangement backfill as the default. https://github.com/risingwavelabs/risingwave/pull/14846
• Supports spill hash join to avoid OOM issue. https://github.com/risingwavelabs/risingwave/pull/17122
• Supports spill hash aggregation for batch queries. https://github.com/risingwavelabs/risingwave/pull/16771
• Changes the algorithm that calculates the reserve memory size. https://github.com/risingwavelabs/risingwave/pull/16992

Fixes

• Improves error message and location of cursor. https://github.com/risingwavelabs/risingwave/pull/16959
• Improves error message when trying to create CDC source with columns. https://github.com/risingwavelabs/risingwave/pull/16636
• Allows GRANT and REVOKE privileges on views. https://github.com/risingwavelabs/risingwave/pull/16699

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