How to Use Operators in ksqlDB

In ksqlDB, operators are functions built into the language — they provide many common operations you will need:

• AND, OR and NOT
• =, !=, <, <=, >, >=
• string LIKE pattern
• string NOT LIKE pattern
• value IS NULL
• value IS NOT NULL

• +, -, *, /, %

• +, ||: to concatenate two strings together

• timestamp AT timezone
• BETWEEN time_field AND time_field
• NOT BETWEEN time_field AND time_field

• []: get the element at the index as of [1]

• ->: get the field from struct as of struct->field.

Below are some common use cases on when you will need them:

• How to concatenate two strings together
• How to query nested JSON