[ 
https://issues.apache.org/jira/browse/PHOENIX-934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13971966#comment-13971966
 ] 

James Taylor commented on PHOENIX-934:
--------------------------------------

Global indexes are what we have today for secondary indexes: the secondary 
index table is a separate, completely independent HBase table as described 
here: http://phoenix.incubator.apache.org/secondary_indexing.html
Local indexes are where the index data and table data are co-resident for the 
same region's worth of data as described here: 
https://github.com/Huawei-Hadoop/hindex

They both have their pluses and minus. Local indexes are less expensive to 
maintain because you don't have to make a cross region server call when you the 
data changes. On the flip side, querying them may be more expensive as you have 
to look in every region for the index data.

This JIRA is part of a larger issue to support these new kinds of indexes.

> Make changes to specify index is local
> --------------------------------------
>
>                 Key: PHOENIX-934
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-934
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: rajeshbabu
>            Assignee: James Taylor
>
> While creating an index user can have an option to choose whether index is 
> local or global. We can have special attribute in create index DDL statement.



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

Reply via email to