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

Switch to Plain View
Hive, mail # user - Problem in hbase integration


+
Mohammad Tariq 2011-11-30, 15:02
+
shashwat shriparv 2011-11-30, 19:20
Copy link to this message
-
Re: Problem in hbase integration
Mohammad Tariq 2011-11-30, 19:32
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>
>
>
>