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 > >
