alex kamil created PHOENIX-958:
----------------------------------

             Summary: check if an array contains an 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)

Reply via email to