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
-
Re: Hive Create Table command throws datanucleus error
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}