Highlights of RisingWave v1.2: The Open-Source Streaming Database
Tags: database, opensource, news
Published: 2023-10-17 14:00:00

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](https://docs.risingwave.com/docs/current/emit-on-window-close/).


## 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](https://docs.risingwave.com/docs/current/sql-cancel-jobs/).


## 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](https://docs.risingwave.com/docs/current/query-syntax-from-clause/#lateral-subqueries).


## 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](https://docs.risingwave.com/docs/current/sink-to-clickhouse/).


## 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](https://docs.risingwave.com/docs/current/sink-to-iceberg/).


## 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](https://docs.risingwave.com/docs/current/transactions/#transactions-within-a-cdc-table).

## 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](https://docs.risingwave.com/docs/current/sql-function-string/#like-pattern-matching-expressions).

## 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](https://docs.risingwave.com/release-notes/).

Sign up for our [monthly newsletter](https://www.risingwave.com/cloud/) if you’d like to keep up to date on all the happenings with RisingWave. Follow us on [Twitter](https://twitter.com/RisingWaveLabs?__hstc=32235681.36a164153dae3eb37bccb8b7da6b4e36.1697020142650.1697182378608.1697531896272.8&__hssc=32235681.1.1697531896272&__hsfp=2918625018) and [Linkedin](https://www.linkedin.cn/incareer/company/risingwave-labs/?__hstc=32235681.36a164153dae3eb37bccb8b7da6b4e36.1697020142650.1697182378608.1697531896272.8&__hssc=32235681.1.1697531896272&__hsfp=2918625018), and join our [Slack](https://www.risingwave-labs.com/slack?__hstc=32235681.36a164153dae3eb37bccb8b7da6b4e36.1697020142650.1697182378608.1697531896272.8&__hssc=32235681.1.1697531896272&__hsfp=2918625018) community to talk to our engineers and hundreds of streaming enthusiasts worldwide.