Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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.

Regards
Shashwat

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
09900059620
09663531241

<iframe src="
http://rcm.amazon.com/e/cm?t=shriparv-20&o=1&p=48&l=ur1&category=kindlerotating&f=ifr"
width="728" height="90" scrolling="no" border="0" marginwidth="0"
style="border:none;" frameborder="0"></iframe>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB