[jira] [Commented] (PHOENIX-6207) Paged server side grouped aggregate operations

["Kadir OZDEMIR (Jira)" <ji...@apache.org>]

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

Kadir OZDEMIR commented on PHOENIX-6207:
----------------------------------------

[~comnetwork], I have posted the design doc for server paging at PHOENIX-6211. You can also review the PR there. I would like to acknowledge that I have followed your suggestion and set the default the page time to 90% of the HBase RPC timeout. I look forward to your feedback. Thanks!

> Paged server side grouped aggregate operations
> ----------------------------------------------
>
>                 Key: PHOENIX-6207
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6207
>             Project: Phoenix
>          Issue Type: Improvement
>    Affects Versions: 5.0.0, 4.14.3
>            Reporter: Kadir OZDEMIR
>            Assignee: Kadir OZDEMIR
>            Priority: Major
>             Fix For: 4.16.0
>
>         Attachments: PHOENIX-6207.4.x.001.patch, PHOENIX-6207.4.x.002.patch, PHOENIX-6207.4.x.003.patch, PHOENIX-6207.4.x.004.patch, PHOENIX-6207.4.x.005.patch, PHOENIX-6207.4.x.006.patch, PHOENIX-6207.master.001.patch, PHOENIX-6207.master.002.patch
>
>
> Phoenix provides the option of performing query operations on the client or server side. This is decided by the Phoenix optimizer based on configuration parameters. For the server side option, the table operation is parallelized such that multiple table regions are scanned. However, currently there is no paging capability and the server side operation can take long enough lead to HBase client timeouts. Putting a limit on the processing time within a single RPC call (i.e., the next operation time on the aggregate scanner) on the server side using a Phoenix level paging is highly desirable. A similar paging mechanism has been already implemented for index rebuild and verification operations and proven to be effective to prevent timeouts. This Jira is for implementing this paging for the server side grouped aggregate operations. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)