[jira] [Created] (PHOENIX-1544) Support exploding ARRAY when indexing for immutable data

["James Taylor (JIRA)" <ji...@apache.org>]

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)