hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Juan Yu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-8863) Cannot drop table with uppercase name after "compute statistics for columns"
Date Fri, 14 Nov 2014 00:14:36 GMT
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)

Mime
View raw message