[
https://issues.apache.org/jira/browse/PHOENIX-800?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-800.
----------------------------------
Resolution: Fixed
Fix Version/s: 5.0.0
4.0.0
3.0.0
> Push projection of a single ARRAY element to the server
> -------------------------------------------------------
>
> Key: PHOENIX-800
> URL: https://issues.apache.org/jira/browse/PHOENIX-800
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 3.0-Release
> Reporter: James Taylor
> Assignee: ramkrishna
> Fix For: 3.0.0, 4.0.0, 5.0.0
>
>
> If only a single array element is selected, we'll still return the entire
> array back to the client. Instead, we should push this to the server and only
> return the single array element. The same goes for the reference to an ARRAY
> in the WHERE clause. There's a general HBase fix for this (i.e. the ability
> to define a separate set of key values that will be returned versus key
> values available to filters) that has a patch
> [here](https://issues.apache.org/jira/browse/HBASE-4364), but is deemed not
> possible to pull into the 0.94 branch by @larsh.
> My thought is that we can add a Filter at the end our our filter chain that
> filters out any KeyValues that aren't in the SELECT expressions (i.e. filter
> out if a column is referenced in the WHERE clause, but not in the SELECT
> expressions). This same Filter could handle returning only the elements of
> the array that are referenced in the SELECT expression rather than the entire
> array.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
