Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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}
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB