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

Posted to dev@phoenix.apache.org by "alex kamil (JIRA)" <ji...@apache.org> on 2014/04/29 21:39:22 UTC

[jira] [Updated] (PHOENIX-958) check if an array contains a value or not

     [ 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)