[HIVE-24741] get_partitions_ps_with_auth performance can be improved when requesting all the partitions

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available release-3.1.3
• Assignee: Vihang Karajgaonkar
• Reporter: Vihang Karajgaonkar
• Created: 04/Feb/21 18:37
• Updated: 17/Nov/22 08:48
• Resolved: 16/Feb/21 17:46

Description

get_partitions_ps_with_auth API does not support DirectSQL. I have seen some large production use-cases where this API (specifically from Spark applications) is used heavily to request for all the partitions of a table. This performance of this API when requesting all the partitions of the table can be signficantly improved (~4 times from a realworld large workload usecase) if we forward this API call to a directSQL enabled API.

Issue Links

• links to: GitHub Pull Request #1948