Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Problem in hbase integration

Copy link to this message
Re: Problem in hbase integration
One thing i know that that hive-hbase-handler jar file and hbase jar file
should be compatible. we need to compile it to make it to support latest
version of hbase, which we can do by ant clean tar putting the current
version of hbase into lib folder of hive hbase handler. same thing i am
trying too.. but not a sucess yet.


On Wed, Nov 30, 2011 at 8:32 PM, Mohammad Tariq <[EMAIL PROTECTED]> wrote:

> Hello list,
>   I am totally new to hive and I am trying to integrate Hive and
> Hbase. I was able to create table in HDFS properly, but when I tried
> it for Hbase I ran into the following error -
> solr@ubuntu:~/hive-0.7.0$ bin/hive --auxpath
> /home/solr/hive-0.7.0/lib/hive-hbase-handler-0.7.0.jar,/home/solr/hive-0.7.0/lib/hbase-0.89.0-SNAPSHOT.jar,/home/solr/hive-0.7.0/lib/zookeeper-3.3.1.jar
> -hiveconf hbase.master=hbase.localhost:60000
> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated.
> Please use org.apache.hadoop.log.metrics.EventCounter in all the
> log4j.properties files.
> Hive history file=/tmp/solr/hive_job_log_solr_201111302010_128355450.txt
> 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.JDOFatalDataStoreException:
> Failed to start database 'metastore_db', see the next exception for
> details.
> NestedThrowables:
> java.sql.SQLException: Failed to start database 'metastore_db', see
> the next exception for details.
> FAILED: Execution Error, return code 1 from
> org.apache.hadoop.hive.ql.exec.DDLTask
> Need some help.Many thanks in advance.
> Regards,
>     Mohammad Tariq

Shashwat Shriparv

<iframe src="
width="728" height="90" scrolling="no" border="0" marginwidth="0"
style="border:none;" frameborder="0"></iframe>