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}
