[HIVE-23289] Rows are not removed from the skewed_string_list_values table

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Zoltan Haindrich
• Created: 23/Apr/20 16:23
• Updated: 14/May/20 13:57

Description

initialize sysdb as well

select * from sys.skewed_string_list_values;
-- empty (no skewed stuff)
create external table smt_sysdb_src_skew (key int) skewed by (key) on (1,2,3);
select * from sys.skewed_string_list_values;
-- 3 rows
drop table smt_sysdb_src_skew;
select * from sys.skewed_string_list_values;
-- still..3 rows
create external table smt_sysdb_src_skew (key int) skewed by (key) on (1,2,3);
-- now we have 6 rows; the biggest issue is that the list_id is the same

Issue Links

• is duplicated by: HIVE-21554 Dropping skewed table does not drop some metastore data