Harish Butani created HIVE-6335:
-----------------------------------
Summary: Dropping table after column stats are collected fails
Key: HIVE-6335
URL: https://issues.apache.org/jira/browse/HIVE-6335
Project: Hive
Issue Type: Bug
Components: Statistics
Reporter: Harish Butani
This is my test:
{noformat}
set hive.stats.dbclass=jdbc:derby;
create table A(
x INT,
y INT
)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ',';
load data local inpath
'/Users/hbutani/Dropbox/Hive-Dev/CBO/testData/test1/A.csv'
overwrite into table A;
analyze table A compute statistics;
analyze table A compute statistics for columns x,y;
drop table A;
{noformat}
The final drop gives:
{noformat}
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:javax.jdo.JDODataStoreException: Exception thrown
flushing changes to datastore
at
org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:451)
.......
NestedThrowablesStackTrace:
java.sql.BatchUpdateException: DELETE on table 'TBLS' caused a violation of
foreign key constraint 'TAB_COL_STATS_FK1' for key (2). The statement has been
rolled back.
.....
{noformat}
Running in local mode with 'set hive.stats.dbclass=jdbc:derby'. If this happens
only in this mode, then it is a minor inconvenience.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
