This topic describes how to use the logical function IS NULL in Realtime Compute.

Syntax

value IS NULL

Input parameters

Parameter Data type
value Any data type

Description

If the value is null, true is returned. Otherwise, false is returned.

Example

  • Test data
    int1 (INT) int2 (VARCHAR)
    97 null
    9 www
  • Test statements 
    SELECT int1 as aa
FROM T1
WHERE int2 IS NULL;
  • Test results
    aa (INT)
    97