Error Preventing DROP EXTERNAL TABLE In Hive on Oracle Big Data Appliance

(Doc ID 1917450.1)

Last updated on AUGUST 14, 2014

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Linux x86-64

Symptoms

Error preventing dropping external table in Hive.

Error similar to this may be seen:

hive> DROP TABLE IF EXISTS TEST1;
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)
  at org.datanucleus.api.jdo.JDOTransaction.commit(JDOTransaction.java:165)
  at org.apache.hadoop.hive.metastore.ObjectStore.commitTransaction(ObjectStore.java:401)
  at sun.reflect.GeneratedMethodAccessor39.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja

Error:
foreign key constraint fails (`hive`.`TAB_COL_STATS`, CONSTRAINT `TAB_COL_STATS_FK` FOREIGN KEY (`TBL_ID`) REFERENCES `TBLS` (`TBL_ID`))

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms