ISNULL

This page describes the ISNULL function in Lenses SQL.

ISNULL(expr)

Returns true if the input is null; false otherwise.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

// Some code
USE `kafka`;
SELECT 
  ISNULL(modified_at) AS modified_at,
   modified_at AS current_field 
FROM users-events
LIMIT 5;

Output:

{
  "value": {
    "modified_at": true,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": true,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": false,
    "current_field": "2023-11-02T02:46:12.882863"
  }
}
{
  "value": {
    "modified_at": true,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": true,
    "current_field": null
  }
}