Logical Operators

This page contains logical operators supported by e6data.

<expr1> AND <expr2>

Returns true if both the values evaluate to true.

> select colA from table1 where colB > x AND colB <> y;

<expr1> OR <expr2>

Returns true if any of the values evaluate to true.

> select colA from table1 where colB > x OR colB = null;

NOT <expr>

Returns true if the value is false.

> select colA from table1 where colB NOT y;

The following truth table demonstrates the boolean output of AND and OR:

aba AND ba OR b

true

true

true

true

true

false

false

true

false

true

false

true

false

false

false

false

Last updated

#930: Cross account hive GCP

Change request updated