[
https://issues.apache.org/jira/browse/PHOENIX-1544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor updated PHOENIX-1544:
----------------------------------
Summary: Support indexing of an ARRAY (was: Support exploding ARRAY when
indexing for immutable data)
> Support indexing of an ARRAY
> ----------------------------
>
> Key: PHOENIX-1544
> URL: https://issues.apache.org/jira/browse/PHOENIX-1544
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
>
> Needs to be fleshed out more, but when data is immutable, I think we have
> some interesting ways we could support indexing array data to improve query
> performance. We could generate an index row per array element, tacking on the
> position of the array element in the row key.
> For example, given the array: ARRAY['a','b','c','a'] you could generate the
> following row keys(where the space is a null byte) when an INDEX is created
> over it:
> {code}
> a 0
> b 1
> c 2
> a 3
> {code}
> Because the data is immutable, we don't need to worry about keeping it in
> sync with changes to the array (which would be difficult).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
