while trying to create external table in oozie hive action, I am
getting following error, hive version is 0.9.0
Caused by: javax.jdo.JDODataStoreException: Insert of object
"org.apache.hadoop.hive.metastore.model.MColumnDescriptor@46c1dc0b"
using statement "INSERT INTO `CDS` (`CD_ID`) VALUES (?)" failed :
Duplicate entry 'XXXXX' for key 'PRIMARY'
NestedThrowables:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'XXXXX' for key 'PRIMARY'
at
org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:313)
at
org.datanucleus.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:660)
at
org.datanucleus.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:680)
at
org.apache.hadoop.hive.metastore.ObjectStore.createTable(ObjectStore.java:617)
... 43 more
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Duplicate entry 'XXXXX' for key 'PRIMARY'
Thanks,
Abhishek
