Nulls

You can specify a null constant almost anywhere a constant string or number can appear in SAQL, with the following exceptions and clarifications.

Typing

null is not typed. It is inferred from context. For example, null + 4 is a number. A SAQL syntax error will be generated when a type cannot be infered.

Filters

When a filter expression evaluates to null, the row is filtered out.

• Lists

  foo in [null, "bar"] is handled like foo == null or foo == "bar".

• Ranges

  filter q by dim in [null.."myvalue"] is handled as (dim>=null and dim<=7)

Unsupported

null is not supported in the following contexts:

• Offset
• Limit
• dateRelative
• dateRange
• Windowing range
• Trim (second argument)