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
Stephen Sprague 2014-01-17, 06:05
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