Skip to content

v1.4.0

Compare
Choose a tag to compare
@huangjw806 huangjw806 released this 10 Nov 03:23
· 2132 commits to main since this release
7025591

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_hiddenis_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