Join us in exploring some of the most prominent features highly anticipated in this new release, such as the emit-on-window-close syntax change, streaming job management, lateral subqueries, ink data to ClickHouse and more.
We are thrilled to announce the release of RisingWave v1.2. Here are the key highlights in this release.
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.
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.
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.
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.
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.
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.
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.
Conclusion
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.
Wondering how to build a real-time market analysis pipeline? In this tutorial, we'll combine Databento's market data streams with RisingWave's stream processing capabilities to create a live market analysis system.
Join us in exploring some of the most highly anticipated and prominent features of this new release！This is a major leap forward and we are excited to share these developments with you.
RisingWave has already demonstrated its ability to simplify and accelerate complex workflows in portfolio monitoring and risk management. For engineers in capital markets, adopting RisingWave isn’t just about keeping up—it’s about staying ahead.
