[jira] [Updated] (PHOENIX-952) Support ANY and ALL built-ins for ARRAYs

["ramkrishna.s.vasudevan (JIRA)" <ji...@apache.org>]

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

ramkrishna.s.vasudevan updated PHOENIX-952:
-------------------------------------------

    Attachment: Phoenix-932_1.patch

Attaching a patch that works with 'ANY' syntax.  If the approach is fine could create a similar one for 'ALL'. Infact only few changes would be needed in the  code.  But need to see. 
Creates an ArrayAnyExpression as function  node.  On seeing this node on the compilation stage creates a modified form of ComparisonExpression and the evaluate method evaluates considering ANY as a combination of 'OR' clause.  Also considers the OP that is specified with the ANY.

> Support ANY and ALL built-ins for ARRAYs
> ----------------------------------------
>
>                 Key: PHOENIX-952
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-952
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 3.0.0, 4.0.0
>            Reporter: James Taylor
>             Fix For: 3.1, 4.1
>
>         Attachments: Phoenix-932_1.patch
>
>
> There's currently no good way to search array elements. We should support the ANY and ALL built-ins for our ARRAY type like Postgres does: http://www.postgresql.org/docs/9.1/static/arrays.html#ARRAYS-SEARCHING



--
This message was sent by Atlassian JIRA
(v6.2#6252)