-
Re: hbase hive integration - "FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory"Mohammad Tariq 2012-11-26, 13:29
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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.
>>>
>>
>>
>
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>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.
>>>
>>
>>
>
