You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "Kadir OZDEMIR (Jira)" <ji...@apache.org> on 2022/03/15 23:11:00 UTC

[jira] [Assigned] (PHOENIX-6663) Use batching when joining data table rows with uncovered local index rows

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

Kadir OZDEMIR reassigned PHOENIX-6663:
--------------------------------------

    Assignee: Kadir OZDEMIR

> Use batching when joining data table rows with uncovered local index rows
> -------------------------------------------------------------------------
>
>                 Key: PHOENIX-6663
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6663
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 4.16.1, 5.1.2
>            Reporter: Kadir OZDEMIR
>            Assignee: Kadir OZDEMIR
>            Priority: Major
>
> The current solution uses HBase get operations to join data table rows with uncovered local index rows on the server side. Issuing a separate get operation for every data table row can be expensive. Instead, we can buffer lots of data row keys in memory and use a scan with skip scan filter. This will reduce the cost of join and also improve the performance.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)