James Taylor created PHOENIX-1544:
-------------------------------------
Summary: Support exploding ARRAY when indexing for immutable data
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)
