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 Plain View
Hive >> mail # user >> Hive Create Table command throws datanucleus error


+
Leena Gupta 2014-01-17, 00:17
+
Stephen Sprague 2014-01-17, 00:42
+
Leena Gupta 2014-01-17, 03:54
Copy link to this message
-
Re: Hive Create Table command throws datanucleus error
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 <[EMAIL PROTECTED]> 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 <[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
+
Leena Gupta 2014-01-18, 02:05
+
Mohammad Islam 2014-01-18, 02:26
+
Stephen Sprague 2014-01-18, 04:05
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