phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajeshbabu (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1015) Support joining back to data table row from local index when query condition involves leading columns in local index
Date Thu, 19 Jun 2014 20:12:25 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-1015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

rajeshbabu updated PHOENIX-1015:
--------------------------------

    Attachment: PHOENIX-1015_v6.patch

Hi [~jesse_yates], here is the patch addressing James comments above. Added join back code
in all the observers where ever needed. Corrected some bugs and done test case changes to
make use of local indexes as well(tomorrow will add some more). Join back from data table
is not yet done in join queries but can use local indexes(Will do it in another JIRA). Can
you please review the patch?  

Thanks.

> Support joining back to data table row from local index when query condition involves
leading columns in local index
> --------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-1015
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1015
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: rajeshbabu
>            Assignee: rajeshbabu
>         Attachments: PHOENIX-1015.patch, PHOENIX-1015_v6.patch
>
>
> When a query involves more columns to project than columns in index and query condition
involves leading columns in local index then first we can get matching rowkeys from local
index table and then get the required columns from data table. In local index both data region
and index region co-reside in the same RS, we can call get on data region to get the missing
columns in the index, without any n/w overhead. So it's efficient. 



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

Mime
View raw message