If you upgrade Hive, you have to do a upgrade/migration on the metastore database. There are scripts that come with hive distributions for this. If you're starting from scratch, you could just drop the old database.
On Sun, Mar 10, 2013 at 1:23 AM, 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 >>>> >>>> >>> >> > -- *Dean Wampler, Ph.D.* thinkbiganalytics.com +1-312-339-1330
