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