v1.7.0-single-node-2

release v1.7.0-single-node-2

v1.7.0-single-node

release v1.7.0-single-node

v1.6.1

release v1.6.1

v1.6.0

For installation and running instructions, see Get started.

Main changes

SQL features

• Query syntax:
  • Allows NOW in upper bound condition for temporal filters. #13985
  • Supports temporal filters with multiple OR expressions. #14382
  • Supports <expr> [ NOT ] SIMILAR TO <pat> [ ESCAPE <esc_text> ] clause. #14000
  • Breaking change: Fixes the correctness of SOME, ALL, and ANY expressions. Drop and recreate any materialized views that use these expressions. #14221
  • Supports array subquery and \du command. #14044
  • Supports SET PARALLELISM clause for ALTER commands. #14240
• SQL commands:
  • Technical preview feature: Supports CREATE SINK INTO TABLE. Multiple sinks can use the same table as the target. #13185, #13659
• SQL functions & operators:
  • Breaking change: 0b10 is now interpreted as binary 10 instead of 0 as b10. Integer literals can be given in hex 0x, oct 0o and bin 0b. #14262
  • Supports interval type as input for to_char(). #14071
• System catalog:
  • Add system view rw_streaming_parallelism. #14261

Connectors

• Adds CDC backfill support for Postgres so users can ingest multiple PostgreSQL tables with a single replication slot. #13958
• Support multi-table transaction from upstream MySQL & Postgres CDC. Specify transactional = true in the WITH options to enabled it. #14375
• Renames scan.startup.timestamp_millis to scan.startup.timestamp.millis for Kafka, Pulsar and NATS source. #13656
• Adds properties.ssl.endpoint.identification.algorithm parameter for Kafka source and sink.#13990
• Supports FORMAT PLAIN ENCODE PROTOBUF syntax for Kafka sink. #12858
• Supports GCS file source. #13414
• Breaking change: For ClickHouse sinks, timestamptz can be sinked to DateTime64. timestamp cannot be sinked and has to be converted to timestamptz first before being sinked. #13672
• For Elasticsearch sinks, the default es.type is set as _doc for Elasticsearch 6.x and 7.x. #14273
• connector = 'iceberg_java' is deprecated, and users can only Iceberg sinks with the Rust version of Iceberg. Similarly, the DeltaLake sink will also use the Rust version implementation. #14277
• Supports StarRocks sink. #12681

Installation and deployment

• Allows for storage.prefetch_buffer_capacity_mb to be configured in the TOML file to prevent out of memory issues. #13558
• Supports Huawei Cloud OBS as the storage backend. #13844

Cluster configuration changes

• Supports setting statement_timeout value for queries. #13933
• Exposes SSL functionality through RW_SSL_CERT and RW_SSL_KEY environment variables to configure SSL certificates and key file location. #14062

Full Changelog: v1.5.0...v1.6.0

v1.5.4

release v1.5.4

v1.5.3

release v1.5.3

v1.5.2

release v1.5.2

v1.5.1

release v1.5.1

v1.5.0

For installation and running instructions, see Get started.

Main changes

SQL features

• SQL Commands:
  • Supports SET SCHEMA syntax for ALTER {TABLE t | [MATERIALIZED] VIEW (m)v | SOURCE src | SINK sink | CONNECTION c | FUNCTION f( argument_type [, ...] )}. #13341
  • Supports OWNER TO syntax for ALTER {DATABASE | SCHEMA | TABLE | [MATERIALIZED] VIEW | SOURCE | SINK}. #13216
  • Supports RENAME TO syntax for ALTER { DATABASE db | SCHEMA s}. #13713
  • Supports KILL command. #13434
  • Supports SHOW PROCESSLIST command. #13287
  • Supports SET TO DEFAULT command. #13693
  • Supports SHOW COLUMNS and DESCRIBE from sinks and views. #13626
• SQL functions & operators
  • Supports list and struct types for jsonb_agg and jsonb_object_agg. #13299
  • Supports jsonb_build_array and jsonb_build_object. #13198
  • Supports to_jsonb. #13161
  • Supports json path operators and functions. #13568
  • Supports array operators @> and <@. #13253
• System catalog
  • Adds columns rw_version, total_memory_bytes, total_cpu_cores and started_at, and all nodes in system table rw_worker_nodes. #13487
  • Adds system table rw_internal_tables. #13272

Sources & sink

• The load generator can generate timestamptz columns. #13451
• Adds option [properties.fetch.queue.backoff.ms](http://properties.fetch.queue.backoff.ms) for Kafka source. #13321
• Supports creating multiple CDC tables that share the same source, which allows for incremental and lock-free snapshot loading. #12535
• CREATE SINK statements no longer need to wait for backfill to complete. #13665

Deployment

• Adds a docker-compose file for standalone mode. #13233

Cluster configuration changes

• Adds support for system parameter pause_on_next_bootstrap. #11936

Full Changelog: v1.4.0...v1.5.0

v1.4.0

For installation and running instructions, see Get started.

Main changes

SQL features

• Query syntax:
  • Supports using subqueries in UPDATE and DELETE statements. (#12995)
• SQL commands
  • Supports COMMENT ON clause for tables and columns. (#12849)
  • Supports persistent background materialized views. (#12167)
  • Exposes hidden columns and distribution keys when using SHOW COLUMNS FROM command. (#12839)
  • Exposes hidden columns when using DESCRIBE command. (#12839)
• SQL functions & operators
  • Supports substring and substr functions for bytea data type. (#13088)
  • Supports functions jsonb_pretty,  jsonb_object, jsonb_strip_nulls, and jsonb_extract_path. (#13050), (#13036), (#13169), (#13143)
  • Supports jsonb @>, <@, ?, ?|, ?&, #>,  #>>, - and #- operators. (#13056), (#13110), (#13118)
  • Supports greatest and least functions. (#12838)
  • Supports regexp_split_to_array function. (#12844)
  • Supports bit_and and bit_or aggregate functions in materialized views. (#12758)
  • Supports jsonb_agg and jsonb_object_agg in streaming mode. (#12836)
  • Supports general rank and dense_rank window functions. (#13183)
• System catalog
  • Adds column parallelism in system table rw_fragments. (#12901)
  • Adds columns is_hidden, is_primary_key and is_distribution_key in rw_columns system table. (#12839)

Sources & sinks

• Adds google.protobuf.Any support for Protobuf sources. (#12291)
• Adds schemas.enable support for Kafka sinks with upsert json. (#12113)
• Adds support for Kafka sinks with Upsert Avro using schema registry. (#13007)
• server.id option is now optional for MySQL CDC source. (#13031)
• Enables timestamptz.handling.mode option to control the timestamptz output format for certain sinks. (#13109)
• Adds the stream field and support for multiple inputs for the subject field for NATS source connector. (#12799)
• Adds new option properties.allow.auto.create.topics for Kafka sink. (#12766)
• Adds support for s3_v2 source connector, a more efficient version of the S3 source. (#12595)
• Adds support for Google BigQuery sink. (#12873)
• Adds support for Redis sink. (#11999)

Deployment

• Release RisingWave all-in-one binary with connector libraries. (#13133)

Full Changelog: v1.3.0...v1.4.0