[HIVE-24258] [CachedStore] Data mismatch between CachedStore and ObjectStore for constraints

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Labels: pull-request-available
• Target Version/s: 4.0.0
• Assignee: Ashish Sharma
• Reporter: Ashish Sharma
• Created: 12/Oct/20 07:28
• Updated: 17/Nov/22 08:48
• Resolved: 25/Oct/20 09:03

Description

Description

Objects like table name, db name, column name etc are case insensitive as per HIVE contract but standalone metastore cachedstore is case sensitive. As result of which there is mismatch in rawstore output and cachedstore output.

Example -

expected:<[SQLPrimaryKey(table_db:test_table_ops, table_name:tbl, column_name:col1, key_seq:1, pk_name:pk1, enable_cstr:false, validate_cstr:false, rely_cstr:false, catName:hive)]>

but was:<[SQLPrimaryKey(table_db:test_table_ops, table_name:tbl, column_name:col1, key_seq:1, pk_name:Pk1, enable_cstr:false, validate_cstr:false, rely_cstr:false, catName:hive)]>

Issue Links

• Blocked: HIVE-23695 [CachedStore] Add check/default constraints in CachedStore
• links to: GitHub Pull Request #1587
• links to: GitHub Pull Request #1587