hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramki Palle <ramki.pa...@gmail.com>
Subject Re: Error while table creation
Date Sun, 10 Mar 2013 11:03:42 GMT
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.gayakwad@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.palle@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.bajaria@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.gayakwad@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
>>>>
>>>>
>>>
>>
>

Mime
View raw message