Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
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;
Attachments
Attachments
Issue Links
- duplicates
-
HIVE-6335 Dropping table after column stats are collected fails
- Resolved