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

["Juan Yu (JIRA)" <ji...@apache.org>]

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)