[HIVE-21554] Dropping skewed table does not drop some metastore data

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Peter Vary
• Created: 31/Mar/19 17:58
• Updated: 14/May/20 13:57
• Resolved: 14/May/20 13:57

Description

When dropping a skewed table the skewed column data is not dropped.

To reproduce:

• In the metastore RDBMS:
  • select count from skewed_string_list;
• In BeeLine:
  • create table src_skew (key int) skewed by (key) on (1,2,3);
  • drop table src_skew;
• In the metastore RDMBS:
  • select count from skewed_string_list;

Notice that the count in the RDBMS is increased by 3;

 

 

Issue Links

• duplicates: HIVE-23289 Rows are not removed from the skewed_string_list_values table