[HIVE-22782] Consolidate metastore call to fetch constraints

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.0.0
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Query Planning, Standalone Metastore
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Ashish Sharma
• Reporter: Vineet Garg
• Created: 27/Jan/20 18:38
• Updated: 17/Nov/22 08:51
• Resolved: 26/Sep/20 10:14

Description

Currently separate calls are made to metastore to fetch constraints like Pk, fk, not null etc. Since planner always retrieve these constraints we should retrieve all of them in one call.

Issue Links

• duplicates: HIVE-24091 Replace multiple constraints call with getAllTableConstraints api call in query planner
• is a parent of: HIVE-24062 Combine all table constrains RDBMS calls in one SQL call
• links to: GitHub Pull Request #1419