Example: for a table having partition keys country
and state
, one could construct the following filter:
country = "USA" AND (state = "CA" OR state = "AZ")
In particular notice that it is possible to nest sub-expressions within parentheses.
The following operators are supported when constructing filters for partition columns (derived from HIVE-1862):
=
<
<=
>
>=
<>
AND
OR
LIKE
(on keys of typestring
only, supports literal string template with '.*
wildcard only)AND
'
wildcard)OR