ISNULL
This page describes the ISNULL function in Lenses SQL.
Returns true if the input is null; false otherwise.
Available in:
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
}
}