[HIVE-22015] [CachedStore] Add table constraints in CachedStore

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Standalone Metastore
• Labels: pull-request-available
• Assignee: Adesh Kumar Rao
• Reporter: Daniel Dai
• Created: 21/Jul/19 17:57
• Updated: 17/Nov/22 08:51
• Resolved: 13/Jul/20 10:36

Description

Currently table constraints are not cached. Hive will pull all constraints from tables involved in query, which results multiple db reads (including get_primary_keys, get_foreign_keys, get_unique_constraints, etc). The effort to cache this is small as it's just another table component.

Issue Links

• is duplicated by: HIVE-22878 Add caching of table constraints, foreignKeys in CachedStore
• links to: GitHub Pull Request #1109