[
https://issues.apache.org/jira/browse/PHOENIX-958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
alex kamil updated PHOENIX-958:
-------------------------------
Summary: check if an array contains a value or not (was: check if an array
contains an value or not)
> check if an array contains a value or not
> -----------------------------------------
>
> Key: PHOENIX-958
> URL: https://issues.apache.org/jira/browse/PHOENIX-958
> Project: Phoenix
> Issue Type: Improvement
> Reporter: alex kamil
>
> Support searching in an array through the ALL or ANY built-in functions.
> for now have to resort to listing all array elements which would require a
> huge query for big arrays:
> SELECT region_name FROM regions WHERE zip[1] = '94030' OR zip[2] = '94030' OR
> zip[3] = '94030' ,...., zip[10000]= '94030';
--
This message was sent by Atlassian JIRA
(v6.2#6252)
