ksqlDB supports the following operators in value expressions.
The explanation for each operator includes a supporting example based on the following table:
1 2 3 4 5 6 7
The usual arithmetic operators (
+,-,/,*,%) may be
applied to numeric types, like INT, BIGINT, and DOUBLE:
The concatenation operator (
+,||) can be used to
concatenate STRING values.
You can use the
+ operator for multi-part concatenation, for
1 2 3 4 5 6 7 8 9 10
The source dereference operator (
.) can be used
to specify columns by dereferencing the source stream or table.
The subscript operator (
[subscript_expr]) is used to
reference the value at an array index or a map key.
Access nested data by declaring a STRUCT and using the
dereference operator (
->) to access its fields:
. when using aliases:
For more information on nested data, see STRUCT.