Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Error while table creation


Copy link to this message
-
Re: Error while table creation
Viral Bajaria 2013-03-09, 21:04
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 <[EMAIL PROTECTED]>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
>
>