We are thrilled to announce the release of RisingWave v1.2. Here are the key highlights in this release.

Emit-on-window-close syntax change

The syntax for the emit-on-window-close policy has changed. If your application uses the old syntax, please see the updated documentation and update your code accordingly to avoid any issues.

For more details about Emit-on-window-close, see our documentation.

Streaming job management

With the introduction of the CANCEL JOBS and SHOW JOBS SQL queries, you can now cancel or see the progress of streaming jobs. In RisingWave, a streaming job creates a materialized view. This allows you to save time by canceling streaming jobs that are no longer necessary.

For more details about streaming job management, see our documentation.

Lateral subqueries

This release supports lateral subqueries, which provide you with more methods to perform complex calculations and efficient data transformations. The keyword LATERAL can be included before a subquery’s SELECT statement, enabling you to reference columns from preceding subqueries.

For more details about lateral subqueries, see our documentation.

Sink data to ClickHouse

We now support the integration of the popular database management system ClickHouse. With a straightforward CREATE SINK query, you can easily sink data from RisingWave to ClickHouse.

For more details about sink data to ClickHouse, see our documentation.

New version of Iceberg sink connector

BREAKING CHANGE: The Iceberg sink connector has been updated. If your application included sinking to Iceberg, please review the syntax and parameters on the Sink data to Iceberg guide to ensure everything continues to run smoothly.

For more details about new version of Iceberg sink connector, see our documentation.

Transactions within a CDC table

When you use a native RisingWave sink connector, such as MySQL, PostgreSQL, or Citus CDC, you can enable transactions within a CDC table.

For more details about how to enable this feature, see our documentation.

LIKE expressions

In this release, we support [NOT] LIKE and [NOT] ILIKE pattern-matching expressions, as well as the respective [!]~~ and [!]~~* operators. LIKE expressions can be used in SHOW SQL queries, giving you the option to filter the output for relevant results.

For more details about LIKE expressions, see our documentation.


These are just some of the new features included with the release of RisingWave v1.2. To get the entire list of updates, which includes new regular expression functions, please refer to the detailed release notes.

Sign up for our monthly newsletter if you’d like to keep up to date on all the happenings with RisingWave. Follow us on Twitter and Linkedin, and join our Slack community to talk to our engineers and hundreds of streaming enthusiasts worldwide.

Related Posts_
[ Blogs ]

Mastering Risingwave: A Comprehensive Tutorial for Stream Processing Enthusiasts

In the tutorials, we leave no stone unturned. We delve into the core concepts and gameplay of stream processing, introduce the what and the how of RisingWave, discuss its advantages and limitations, and explore how it differs from its competitors. Whether you're a beginner or an experienced player in this field, you'll find exactly what you're looking for.

[ Blogs ]

Highlights of RisingWave v1.4: The Open-Source Streaming Database

Join us in exploring some of the most highly anticipated and prominent features in this new release, which includes a new version of the S3 source connector, some new sink connectors, support for the COMMENT ON command, and more.

[ Blogs ]

RisingWave Roadmap Q4 2023

Since the release of the first official version in July 2023, RisingWave has successfully been deployed in dozens of renowned enterprises and fast-growing startups. As the development team behind RisingWave, we are eager to hear feedback and suggestions from our community members and make corresponding adjustments to the direction of RisingWave's development. Therefore, we plan to regularly update RisingWave's roadmap to make its development more transparent.

sign up successfully_

Welcome to RisingWave community

Get ready to embark on an exciting journey of growth and inspiration. Stay tuned for updates, exclusive content, and opportunities to connect with like-minded individuals.

message sent successfully_

Thank you for reaching out to us

We appreciate your interest in RisingWave and will respond to your inquiry as soon as possible. In the meantime, feel free to explore our website for more information about our services and offerings.

subscribe successfully_

Welcome to RisingWave community

Get ready to embark on an exciting journey of growth and inspiration. Stay tuned for updates, exclusive content, and opportunities to connect with like-minded individuals.