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

Switch to Threaded View
Hive >> mail # user >> Hive Create Table command throws datanucleus error


Copy link to this message
-
Hive Create Table command throws datanucleus error
All,

I have installed Hive 0.10 in my system and am using postgres 9.3 installed
locally as the metastore. When i try to create a table in Hive I get the
following error. How can I get rid of this, please advise:

FAILED: Error in metadata:
MetaException(message:javax.jdo.JDOUserException: Could not create
"increment"/"table" value-generation container "SEQUENCE_TABLE" since
autoCreate flags do not allow it.
NestedThrowables:
org.datanucleus.exceptions.NucleusUserException: Could not create
"increment"/"table" value-generation container "SEQUENCE_TABLE" since
autoCreate flags do not allow it. )
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

P.S. I tried setting the two datanucleus properties in hive-site.xml to
true, but it did not help:

<property> <name>datanucleus.autoCreateSchema</name>
  <value>true</value>
</property>

<property> <name>datanucleus.autoCreateTables</name>
  <value>true</value>
</property>

Thanks,
Leena