[PHOENIX-6207] Paged server side grouped aggregate operations

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 5.0.0, 4.14.3
• Fix Version/s: 5.1.0, 4.16.0
• Assignee: Kadir OZDEMIR
• Reporter: Kadir OZDEMIR
• Created: 26/Oct/20 07:27
• Updated: 15/Jan/21 12:34
• Resolved: 20/Nov/20 22:09

Description

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.

Issue Links

• links to: GitHub Pull Request #947