[jira] [Created] (PHOENIX-1170) Change status of local index during splitting to prevent usage when slower than query through data table

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

James Taylor created PHOENIX-1170:
-------------------------------------

             Summary: Change status of local index during splitting to prevent usage when slower than query through data table
                 Key: PHOENIX-1170
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1170
             Project: Phoenix
          Issue Type: Sub-task
            Reporter: James Taylor
            Assignee: rajeshbabu


Without pre-split, queries to the table take 9x more time (i.e. 1 sec versus 9sec) for a count(*). If we can't bring the time down to be less than a full scan over the data table, we should update the local index status as INACTIVE while it's splitting, then it wouldn't be used for queries, but it would continue to be maintained. Then when the split is done, we could move it back to ACTIVE. Alternatively, we could invent a new status, like SPLITTING, and only use the local index for point lookups until the status is back to ACTIVE.



--
This message was sent by Atlassian JIRA
(v6.2#6252)