Comment on page
Check Keys and NULL values
Feature available on Fluent Bit >= 1.2
When working with structured messages (records), there are certain cases where we want to know if a key exists, if it value is null or have a value different than null.
Fluent Bit internal records are a binary serialization of maps with keys and values. A value can be null which is a valid data type. In our SQL language we provide the following statements that can be applied to the conditionals statements:
The following SQL statement can be used to retrieve all records from stream test where the key called phone has a null value:
SELECT * FROM STREAM:test WHERE phone IS NULL;
Similar to the example above, there are cases where we want to retrieve all records that certain key value have something different than null:
SELECT * FROM STREAM:test WHERE phone IS NOT NULL;
Another common use-case is to check if certain key exists in the record. We provide specific record functions that can be used in the conditional part of the SQL statement. The prototype of the function to check if a key exists in the record is the following:
@record.contains(key)
The following example query all records that contains a key called phone:
SELECT * FROM STREAM:test WHERE @record.contains(phone);
Last modified 2mo ago