Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Identifiers/ where_condition
Updated on 2023-11-30 GMT+08:00
View PDF
Share

where_condition

Syntax

Description

Syntax

Description

where_condition

Judgment condition of where.

and

Logical operator: AND

or

Logical operator: OR

not

Logical operator: NOT

(

Start of the subjudgment condition.

)

End of the subjudgment condition.

condition

Judgment condition.

exists

Keyword used to determine whether a non-empty collection exists. If exists is followed by a subquery, then the subquery must contain a judgment condition.

in

Keyword used to determine whether attributes are in the same collection.

attrs_value_set_expr

Collection of attribute values.

attr_expr

Attribute expression.
Parent topic: Identifiers