[
https://issues.apache.org/jira/browse/PHOENIX-1170?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
rajeshbabu updated PHOENIX-1170:
--------------------------------
Attachment: PHOENIX-1170_v2.patch
> 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
> Fix For: 5.0.0, 4.2
>
> Attachments: PHOENIX-1170.patch, PHOENIX-1170_v2.patch
>
>
> 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.3.4#6332)
