phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-1170) Change status of local index during splitting to prevent usage when slower than query through data table
Date Thu, 14 Aug 2014 17:26:12 GMT
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)

Mime
View raw message