hadoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohammad Tariq <donta...@gmail.com>
Subject Re: hbase hive integration - "FAILED: Error in metadata: javax.jdo.JDOFatalInternalException: Error creating transactional connection factory"
Date Mon, 26 Nov 2012 12:53:35 GMT
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