phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajeshbabu (JIRA)" <>
Subject [jira] [Updated] (PHOENIX-1249) Support local immutable index
Date Thu, 18 Sep 2014 12:56:33 GMT


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.
With local indexes it took 647 sec.
With global indexes it took 1267 sec.

[~jamestaylor] please review that patch.

> Support local immutable index 
> ------------------------------
>                 Key: PHOENIX-1249
>                 URL:
>             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

View raw message