hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prabhu Joseph (JIRA)" <>
Subject [jira] [Commented] (HIVE-8863) Cannot drop table with uppercase name after "compute statistics for columns"
Date Wed, 19 Nov 2014 09:15:34 GMT


Prabhu Joseph commented on HIVE-8863:

Hi Juan,

   The issue got reproduced in my machine with hive 0.12 version. I am using Derby for metastore
in server mode. Earlier when i drop the table i recieved different exception.
    drop table Test;

The error i got is 

Caused by: MetaException(message:java.lang.RuntimeException: commitTransaction was called
but openTransactionCalls = 0. This probably indicates that there are unbalanced calls to openTransaction/commitTransaction)

After applying HIVE-4996 patch, receiving same exception you have reported.

drop table Test;

java.sql.BatchUpdateException: DELETE on table 'TBLS' caused a violation of foreign key constraint
'TAB_COL_STATS_FK1' for key (19).  

But with or without applying patch, drop table test; [ small 't'] works.

There is some issue.


> Cannot drop table with uppercase name after "compute statistics for columns"
> ----------------------------------------------------------------------------
>                 Key: HIVE-8863
>                 URL:
>             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
"TBLS" ("TBL_ID")) 
> workaround is to use lowercase table name
> drop table test;

This message was sent by Atlassian JIRA

View raw message