[HIVE-24062] Combine all table constrains RDBMS calls in one SQL call

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Ashish Sharma
• Reporter: Ashish Sharma
• Created: 24/Aug/20 08:48
• Updated: 24/Aug/20 08:49

Description

Table consist of 6 different type of constrains namely PrimaryKey,ForeignKey,UniqueConstraint,NotNullConstraint,DefaultConstraint,CheckConstraint. All constrains has different SQL query to fetch the infromation from RDBMS. Which lead to 6 different RDBS call.

Idea here is to have one complex query which fetch all the constrains information at once then filter the result set on the basis of constrains type.

Issue Links

• is a child of: HIVE-22782 Consolidate metastore call to fetch constraints