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