risingwavelabs/risingwave v1.4.0

on GitHub

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