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
Thanks for the valuable info.

Regards,
    Mohammad Tariq

On Thu, Dec 1, 2011 at 12:50 AM, shashwat shriparv
<[EMAIL PROTECTED]> wrote:
> 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