Good 'ole permissions, eh? A shame the error thrown by the datanuculeus
code didn't expose this important piece of information.
Instead we get a red herring about "autocreate flag" nonsense and waste
hours of time. Egads.
+1 for sharing back!
On Fri, Jan 17, 2014 at 6:26 PM, Mohammad Islam wro
I never used postgres with Hive.
These links might be helpful:
1.
http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.3.0/bk_dataintegration/content/ch_using-hive.html
Look for Using Postgres for the Hive Metastore
2.
http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/C
After several tries, I finally figured it out. Thought I'll post what I had
to do in case others hit this problem.
>From what I observed, it looks like the Datanucleus error is related to the
absence of proper access permissions to hiveuser in postgres. I uninstalled
both hive and postgres, install
okay. so SEQUENCE_TABLE does indeed exist. that's the first thing to get
out of the way then. hmm.
I suspect these other tables are just artifacts from the differences in the
hive versions.
yeah, i'm not sure where to go from here and I couldn't find much via
googling either.
would it be possib
Thanks for responding Stephen.
I checked the tables in Postgres and the SEQUENCE_TABLE exists. However in
comparison to the list you gave for Hive 0.12, the following tables are
missing, not sure if these could be the cause of the datanucleus error :
DELEGATION_TOKENS
MASTER_KEYS
VERSION
Thank
On Thu, Jan 16, 2014 at 4:17 PM, Leena Gupta wrote:
> Could not create "increment"/"table" value-generation container
> "SEQUENCE_TABLE" since autoCreate flags do not allow it.
Interestingly enough this exact same question is posted here:
http://stackoverflow.com/questions/19205318/cannot-cre
