[
https://issues.apache.org/jira/browse/PHOENIX-1249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
rajeshbabu updated PHOENIX-1249:
--------------------------------
Attachment: PHOENIX-1249_v2.patch
Patch to support local indexes on tables with immutable rows. also preparing
local index mutations from data mutations at server side without any index
maintenance.
I have done some perf test against global indexes.
created a table with immutable rows and created 4 indexes. Inserted 3 lakh
records.
{code}
With local indexes it took 647 sec.
With global indexes it took 1267 sec.
{code}
[~jamestaylor] please review that patch.
> Support local immutable index
> ------------------------------
>
> Key: PHOENIX-1249
> URL: https://issues.apache.org/jira/browse/PHOENIX-1249
> Project: Phoenix
> Issue Type: Sub-task
> Affects Versions: 4.1
> Environment: Hbase 0.98.4-Hadoop2
> Phoenix 4.1
> Reporter: Sun Fulin
> Assignee: rajeshbabu
> Fix For: 5.0.0, 4.2
>
> Attachments: PHOENIX-1249.patch, PHOENIX-1249_v2.patch
>
>
> Currently local indexing are forced created as default mutable index which
> requires index maintenance and server side processing, while immutable
> indexes are appropriate for write-once/append-only use case that may fit for
> many use cases. Hope some work for capability to create local index as
> immutable index.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
