Comparison Operators & Functions

This page contains the Comparison operators supported by e6data.

OperatorDescription

<

less than

>

greater than

=

equals

<>

not equals

<=

less than equal to

>=

greater than equal to

IS NULL

Returns boolean when the value equates to null.

> select * from table where col1 IS NULL; -- true/false

IS NOT NULL

Returns boolean when the value does not equate to null.

> select * from table where col1 IS NOT NULL; -- true/false

IN( value1, value2, value3...)

WHERE element IN (expr1, expr2, expr3...)

Returns a boolean value true if the element value is present in the given set of expressions. Else false is returned.

> select colA from Table1 where colB in (val1, val2, val3);

Last updated

#930: Cross account hive GCP

Change request updated