You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "ramkrishna.s.vasudevan (JIRA)" <ji...@apache.org> on 2014/05/12 14:41:20 UTC

[jira] [Resolved] (PHOENIX-958) check if an array contains a value

     [ https://issues.apache.org/jira/browse/PHOENIX-958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

ramkrishna.s.vasudevan resolved PHOENIX-958.
--------------------------------------------

    Resolution: Duplicate

> check if an array contains a value
> ----------------------------------
>
>                 Key: PHOENIX-958
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-958
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: alex kamil
>            Assignee: ramkrishna.s.vasudevan
>
> 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)