RisingWave Labs/risingwave: Release v1.3.0

Name: risingwave

Owner: RisingWave Labs

Release: v1.3.0

Released: 2023-10-18

License: Apache-2.0

Release Assets:

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

• risingwave-connector-v1.3.0.tar.gz

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

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

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

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. https://github.com/risingwavelabs/risingwave/pull/12355
  • ALTER COLUMN command can be used for tables with non-schema-registry source. https://github.com/risingwavelabs/risingwave/pull/12164
• SQL functions & operators
  • Supports array_min. https://github.com/risingwavelabs/risingwave/pull/12071
  • Supports array_max. https://github.com/risingwavelabs/risingwave/pull/12100
  • Supports array_sort. https://github.com/risingwavelabs/risingwave/pull/12189
  • Supports array_sum. https://github.com/risingwavelabs/risingwave/pull/12162
  • format function supports variable inputs. https://github.com/risingwavelabs/risingwave/pull/12178
  • Regular expression functions support back reference, positive, negative lookahead, and positive, negative lookbehind. https://github.com/risingwavelabs/risingwave/pull/12329
  • Supports || operator for concatenating JSONB data. https://github.com/risingwavelabs/risingwave/pull/12502
  • Supports bool_and and bool_or in materialized views. https://github.com/risingwavelabs/risingwave/pull/11956
• Query syntax:
  • Supports WITH ORDINALITY clause. https://github.com/risingwavelabs/risingwave/pull/12273
• System catalog
  • Adds new system function pg_sleep. https://github.com/risingwavelabs/risingwave/pull/12294
  • Adds new system function _pg_expandarray. https://github.com/risingwavelabs/risingwave/pull/12448
  • Adds new storage related system tables:
    • rw_hummock_sstables https://github.com/risingwavelabs/risingwave/pull/12532
    • rw_hommock_pinned_versions, rw_hommock_pinned_snapshots https://github.com/risingwavelabs/risingwave/pull/12285
    • rw_hummock_branched_objects , rw_hummock_current_version , rw_hummock_checkpoint_version , rw_hummock_version_deltas https://github.com/risingwavelabs/risingwave/pull/12309
    • rw_hummock_meta_configs, rw_hummock_compaction_group_configs https://github.com/risingwavelabs/risingwave/pull/12337

Sources & sinks

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

Administration & observability

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

Full Changelog: https://github.com/risingwavelabs/risingwave/compare/v1.2.0...v1.3.0