Juan Yu created HIVE-8863:
-----------------------------
Summary: Cannot drop table with uppercase name after "compute
statistics for columns"
Key: HIVE-8863
URL: https://issues.apache.org/jira/browse/HIVE-8863
Project: Hive
Issue Type: Bug
Components: Metastore
Reporter: Juan Yu
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;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
