ISNOTNULL

This page describes the ISNOTNULL function in Lenses SQL.

ISNOTNULL(expr)

Returns true if the input is not null; false otherwise.

Available in:

Processors	SQL Studio
✓	✓

Sample code:

USE `kafka`;
SELECT 
  ISNOTNULL(modified_at) AS modified_at, 
  modified_at AS current_field 
FROM users-events
LIMIT 5;

Output:

{
  "value": {
    "modified_at": false,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": false,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": true,
    "current_field": "2023-11-05T10:50:25.201315"
  }
}
{
  "value": {
    "modified_at": false,
    "current_field": null
  }
}
{
  "value": {
    "modified_at": false,
    "current_field": null
  }
}