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 possible to install hive v0.12? I can at least vouch for that version. (i'm using postgres v9.1 however.) Otherwise, we'll have to wait for someone else to chase this bugger down - which may not be a bad thing. :) On Thu, Jan 16, 2014 at 7:54 PM, Leena Gupta <gupta.le...@gmail.com> wrote: > 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 > > > Thanks, > > Leena > > > On Thu, Jan 16, 2014 at 4:42 PM, Stephen Sprague <sprag...@gmail.com>wrote: > >> >> On Thu, Jan 16, 2014 at 4:17 PM, Leena Gupta <gupta.le...@gmail.com>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-create-database-with-hive >> and crickets for responses. the twist is is that its for mysql! which >> leads us to the fact that its a middleware (datanucleus?) problem - not a >> metastore vendor problem. >> >> for starters first thing i'd do (regardless of the autocreate flags in >> hive-site.xml) is to confirm that table (SEQUENCE_TABLE) exists in your >> postgres metastore database. "\dt" would list the tables. Is it present? >> >> Cheers, >> Stephen. >> >> >> PS this is what have for hive v0.12 on postgres if its any help. >> >> {noformat} >> dwr_prod=> \dt >> List of relations >> Schema | Name | Type | Owner >> --------+---------------------------+-------+---------- >> public | BUCKETING_COLS | table | postgres >> public | CDS | table | postgres >> public | COLUMNS_OLD | table | postgres >> public | COLUMNS_V2 | table | postgres >> public | DATABASE_PARAMS | table | postgres >> public | DBS | table | postgres >> public | DB_PRIVS | table | postgres >> public | DELEGATION_TOKENS | table | postgres >> public | GLOBAL_PRIVS | table | postgres >> public | IDXS | table | postgres >> public | INDEX_PARAMS | table | postgres >> public | MASTER_KEYS | table | postgres >> public | NUCLEUS_TABLES | table | postgres >> public | PARTITIONS | table | postgres >> public | PARTITION_EVENTS | table | postgres >> public | PARTITION_KEYS | table | postgres >> public | PARTITION_KEY_VALS | table | postgres >> public | PARTITION_PARAMS | table | postgres >> public | PART_COL_PRIVS | table | postgres >> public | PART_COL_STATS | table | postgres >> public | PART_PRIVS | table | postgres >> public | ROLES | table | postgres >> public | ROLE_MAP | table | postgres >> public | SDS | table | postgres >> public | SD_PARAMS | table | postgres >> public | SEQUENCE_TABLE | table | postgres >> public | SERDES | table | postgres >> public | SERDE_PARAMS | table | postgres >> public | SKEWED_COL_NAMES | table | postgres >> public | SKEWED_COL_VALUE_LOC_MAP | table | postgres >> public | SKEWED_STRING_LIST | table | postgres >> public | SKEWED_STRING_LIST_VALUES | table | postgres >> public | SKEWED_VALUES | table | postgres >> public | SORT_COLS | table | postgres >> public | TABLE_PARAMS | table | postgres >> public | TAB_COL_STATS | table | postgres >> public | TBLS | table | postgres >> public | TBL_COL_PRIVS | table | postgres >> public | TBL_PRIVS | table | postgres >> public | TYPES | table | postgres >> public | TYPE_FIELDS | table | postgres >> public | VERSION | table | postgres >> (42 rows) >> {noformat} >> >> >
