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 <[email protected]> wrote: > > On Thu, Jan 16, 2014 at 4:17 PM, Leena Gupta <[email protected]>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} > >
