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