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

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

ASF GitHub Bot commented on PHOENIX-6663:
-----------------------------------------

kadirozde opened a new pull request #1403:
URL: https://github.com/apache/phoenix/pull/1403


   … local index rows


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: issues-unsubscribe@phoenix.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> 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)