Conditions

This page describes how to use Conditions in Lenses SQL Processors.

EXISTS

EXISTS (field)

Returns true if the given field is present false otherwise.

Available in:

Processors	SQL Studio
✓	✓

Returns true if the given field is present false otherwise.

Sample code:

USE `kafka`;
SELECT `EXISTS`(id) 
FROM users-events
LIMIT 1;

Output:

{
  "value": {
    "EXISTS": true
  }
}