Joins | RisingWave

[giscus[bot]]

Joins | RisingWave

A JOIN clause, also known as a join, combines the results of two or more table expressions based on certain conditions, such as whether the values of some columns are equal.

https://docs.risingwave.com/docs/current/sql-function-time-window/

[yingjunwu]

In

SELECT [ ALL | DISTINCT ] [ * | expression [ AS output_name ] [, expression [ AS output_name ]...] ]
FROM TUMBLE ( table_or_source, start_time, window_size [, offset ] );

I think we should change start_time to start_time_col_attr. The second paramater should be a column attribute, not a time value.

[hengm3467]

Good point. start_time_col might be better. Updating the topic now.

[chenzl25]

To better understand streaming joins in RisingWave, you can read this blog.
https://www.risingwave.com/blog/understanding-streaming-joins-in-risingwave/

For those who want to learn the details of temporal joins, you can refer to this RFC.
https://github.com/risingwavelabs/rfcs/blob/main/rfcs/0049-temporal-join.md