Just wondering if your create table syntax include "if not exists" such as
CREATE EXTERNAL TABLE IF NOT EXISTS my_table ( ... ... ... ) On Sun, Mar 10, 2013 at 2:34 AM, Viral Bajaria <viral.baja...@gmail.com>wrote: > Is this is a new installation of Hive or did you upgrade ? How many tables > do you already have ? > > > On Sat, Mar 9, 2013 at 12:00 PM, Abhishek Gayakwad > <a.gayak...@gmail.com>wrote: > >> 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 >> >> >
