[HIVE-8863] Cannot drop table with uppercase name after "compute statistics for columns"

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Metastore, Statistics
• Assignee: Chaoyu Tang
• Reporter: Juan Yu
• Created: 14/Nov/14 00:14
• Updated: 23/Oct/19 16:14
• Resolved: 21/Nov/14 15:43

Description

Create a table with uppercase name Test,
run "analyze table Test compute statistics for columns col1"
After this, you cannot drop the table by
drop table Test;

Got error:
NestedThrowablesStackTrace:
java.sql.BatchUpdateException: Cannot delete or update a parent row: a foreign key constraint fails ("hive2"."TAB_COL_STATS", CONSTRAINT "TAB_COL_STATS_FK" FOREIGN KEY ("TBL_ID") REFERENCES "TBLS" ("TBL_ID"))

workaround is to use lowercase table name
drop table test;

Issue Links

• duplicates: HIVE-6335 Dropping table after column stats are collected fails