Analytics SAQL Reference

SAQL Overview
SAQL Examples
SAQL Basic Elements
SAQL Operators
Arithmetic Operators
Comparison Operators
String Operators
Logical Operators
case
Null Operators
SAQL Statements
SAQL Functions
Query Performance
PDF

Newer Version Available

This content describes an older version of this product. View Latest

Null Operators

Use null operators to test whether a value is null.

Null operators can return true or false.

Operator Name Description
is null is null True when the value is null.
is not null is not null True when the value is not null.

is null and is not null can be used in projections, and in post-projection filters.

Note

These are valid examples:

1a = load "dataset";
2b = foreach a generate Name as Name, Year as Year;
3c = filter b by Year is not null;
1q = load "dataset";
2q = foreach q generate (case when Name is null then "john doe" else Name end) as Name;

This is not a valid example:

1a = load "dataset";
2a = filter a by Year is not null;
3a = foreach a generate Name as Name, Year as Year;