Please use "if not exists" clause and let us know if it works. I am wondering if a table exists already in your database with the same name.
-Ramki. On Sat, Mar 9, 2013 at 11:23 PM, Abhishek Gayakwad <a.gayak...@gmail.com>wrote: > it is an old installation, we recently upgraded hive 0.7.0 to 0.9.0 > > and we are not using "if not exists" clause > > > On Sun, Mar 10, 2013 at 4:37 AM, Ramki Palle <ramki.pa...@gmail.com>wrote: > >> 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 >>>> >>>> >>> >> >
