hadoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Barak Yaish <barak.ya...@gmail.com>
Subject Re: hbase hive integration - "FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory"
Date Mon, 26 Nov 2012 13:38:12 GMT
Yep, derby-10.4.2.0.jar is there. Should I need add it to HADOOP_CP as well?

Hadoop 1.0.4

Hive 0.9.0

On Mon, Nov 26, 2012 at 3:29 PM, Mohammad Tariq <dontariq@gmail.com> wrote:

> Do you have the derby-*jar in your $HIVE_HOME/lib directory?If not,
> download it put it there. BTW, which version are you using?
>
> Regards,
>     Mohammad Tariq
>
>
>
> On Mon, Nov 26, 2012 at 6:37 PM, Barak Yaish <barak.yaish@gmail.com>wrote:
>
>> Hi,
>>
>> I'm using the default metadata store, but indeed looks like my hive
>> doesn't feel that well:
>>
>> hive> CREATE TABLE pokes (foo INT, bar STRING);
>>  FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error
>> creating transactional connection factory
>> NestedThrowables:
>> java.lang.reflect.InvocationTargetException
>> FAILED: Execution Error, return code 1 from
>> org.apache.hadoop.hive.ql.exec.DDLTask
>> hive>
>>
>> Can you point me how to troubleshoot this issue, or its out of this list
>> scope?
>>
>> On Mon, Nov 26, 2012 at 2:53 PM, Mohammad Tariq <dontariq@gmail.com>wrote:
>>
>>> Hello Barak,
>>>
>>>      Are you using the default metadata store(derby) or tying to use
>>> something else like MySQL?If latter is the case, make sure you have the
>>> necessary connector in place. Also, is your Hive working fine independently?
>>>
>>> Regards,
>>>     Mohammad Tariq
>>>
>>>
>>>
>>> On Mon, Nov 26, 2012 at 6:13 PM, Barak Yaish <barak.yaish@gmail.com>wrote:
>>>
>>>> Hi,
>>>>
>>>>
>>>>
>>>> We would like to integrate hive with hbase, so we are following the
>>>> instructions listed here
>>>> https://cwiki.apache.org/Hive/hbaseintegration.html.
>>>>
>>>>
>>>>
>>>> Hadoop 1.0.4
>>>>
>>>> Hbase 0.94.2
>>>>
>>>> Hive 0.9.0
>>>>
>>>>
>>>>
>>>> I’ve updated hadoop-env.sh HADOOP_CLASSPATH with hive jars. When
>>>> running hive and trying to create the table as described in the above link,
>>>> the following error is thrown:
>>>>
>>>>
>>>>
>>>> hive> CREATE TABLE hbase_table_1(key int, value string)
>>>>
>>>>     > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
>>>>
>>>>     > WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
>>>>
>>>>     > TBLPROPERTIES ("hbase.table.name" = "xyz");
>>>>
>>>> FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error
>>>> creating transactional connection factory
>>>>
>>>> NestedThrowables:
>>>>
>>>> java.lang.reflect.InvocationTargetException
>>>>
>>>> FAILED: Execution Error, return code 1 from
>>>> org.apache.hadoop.hive.ql.exec.DDLTask
>>>>
>>>>
>>>>
>>>> Can anyone suggest what else need to be done in order to set up the
>>>> integration?
>>>>
>>>>
>>>>
>>>> Thanks.
>>>>
>>>
>>>
>>
>

Mime
View raw message