[HIVE-23321] Tolerate in tests that metastore is not removing rows from the skewed_string_list_values table

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Zoltan Haindrich
• Reporter: Zoltan Haindrich
• Created: 29/Apr/20 10:24
• Updated: 17/Nov/22 08:50
• Resolved: 03/May/20 17:16

Description

I've found this issue; and filed: HIVE-23289 - however fixing it is not easy at all..

• foreign keys were not used
• there were 0 effort to remove these rows before...I don't think when the feature was added the removal was considered...
• unfortunately designed table hierarchy makes it hard to work with it...
• unclear contracts (at least to me) between skewed_values and sd stuff