risingwavelabs/risingwave v1.3.0

on GitHub

For installation and running instructions, see Get started.

Main changes

SQL features

• SQL commands
  • Experimental: Variable BACKGROUND_DDL can be set to true when creating a materialized view. #12355
  • ALTER COLUMN command can be used for tables with non-schema-registry source. #12164
• SQL functions & operators
  • Supports array_min. #12071
  • Supports array_max. #12100
  • Supports array_sort. #12189
  • Supports array_sum. #12162
  • format function supports variable inputs. #12178
  • Regular expression functions support back reference, positive, negative lookahead, and positive, negative lookbehind. #12329
  • Supports || operator for concatenating JSONB data. #12502
  • Supports bool_and and bool_or in materialized views. #11956
• Query syntax:
  • Supports WITH ORDINALITY clause. #12273
• System catalog
  • Adds new system function pg_sleep. #12294
  • Adds new system function _pg_expandarray. #12448
  • Adds new storage related system tables:
    • rw_hummock_sstables #12532
    • rw_hommock_pinned_versions, rw_hommock_pinned_snapshots #12285
    • rw_hummock_branched_objects , rw_hummock_current_version , rw_hummock_checkpoint_version , rw_hummock_version_deltas #12309
    • rw_hummock_meta_configs, rw_hummock_compaction_group_configs #12337

Sources & sinks

• Generated columns defined with non-deterministic functions cannot be part of the primary key. #12181
• Adds new properties.enable.auto.commit parameter for the Kafka consumer, which sets the enable.auto.commit parameter for the Kafka client. #12223
• Adds privatelink.endpoint parameter to the WITH clause, to support private link for Kafka connector on GCP and AWS. #12266
• Adds parameters [message.timeout.ms](http://message.timeout.ms) and max.in.flight.requests.per.connection for Kafka sources. #12574
• Allows Kinesis source to start ingesting data from a specific timestamp. sequence_number is no longer supported as a startup mode option. #12241
• Allow optional FORMAT DEBEZIUM ENCODE JSON after the connector definition of CDC tables. Allow optional FORMAT NATIVE ENCODE NATIVE after the connector definition of Nexmark sources or tables. #12306
• Allows multiple URLs when defining schema registries. #11982
• Adds support for sinking data to versions 7 and 8 of Elasticsearch. #10357, risingwavelabs/risingwave-docs#1303
• Adds support for sinking append-only data to the NATS messaging system. #11924
• Adds support for sinking data to Doris. #12336
• Adds support for sinking data to Apache Pulsar. #12286
• Adds support for sinking data to Cassandra and ScyllaDB. #11878
• Adds support for creating upsert Iceberg sinks. #12576
• Supports specifying the sink_decouple session variable as default, true and enable, or false and disable. #12544
• A varchar column in RisingWave can sink into a uuid column in Postgres. #12704
• New syntaxes for specifying data format and data encode when creating a Kafka, Kinesis, and Pulsar sink. #12556

Administration & observability

Adds information_schema.views, which contains information about views defined in the database.

Full Changelog: v1.2.0...v1.3.0