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