Logical
| Operator | Expression & Description |
Comparison
Comparison operators
Aggregate
Aggregate functions compute a single result from a set of input values.
Time window
In stream processing, time windows are time intervals based on which we can divide events and perform data computations.
Cast
Use the cast function and operator to convert a value to a specific type.
Mathematical
Mathematical operators
Binary string
bit_length
String
String operators
Date/time
Timespan operators
Conditional
CASE
System administration
current_setting()
System information
RisingWave provides functions to help you get system information, including database, schema, user, role, session, and more.
Array
array_dims
Set operators
UNION and UNION ALL
Set functions
generate_series()
JSON
jsonbarrayelements