Re: Hive and Hbase integration issue

[ku...@gmail.com]

If you go to /tmp/<user>/hive.log you would get a detailed explanation on what might be wrong. Can you provide that?

From here atleast, it seems like a classpath issue of hive not being able to find the hbase handler jar which can be solved by 'add jar hive-hbase-handler-xxx.jar'.

On Jan 31, 2013, at 2:17 PM, Asher Devuyst <as...@gmail.com> wrote:

> I have Hbase running in distributed mode in a 4 node cluster working great.
> Installed Hive today on 5th box and pointed Hive to Mysql and Hbase.
> 
> I start up the hive shell and go to make a table, based on an existing hbase table I get the following exception:
> 
> adev@stg-hive-01:~$ hive
> WARNING: org.apache.hadoop.metrics.jvm.EventCounter is deprecated. Please use org.apache.hadoop.log.metrics.EventCounter in all the log4j.properties files.
> Logging initialized using configuration in jar:file:/usr/lib/hive/lib/hive-common-0.8.1-cdh4.0.1.jar!/hive-log4j.properties
> Hive history file=/tmp/adev/hive_job_log_adev_201301312014_839897667.txt
> SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
> SLF4J: Defaulting to no-operation (NOP) logger implementation
> SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
> hive> CREATE EXTERNAL TABLE hbase_raw_data(key string, value string) STORED BY 'org.apache..hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = "data:raw") TBLPROPERTIES("hbase.table.name" = "raw_data");
> Failed with exception org.apache.hadoop.hive.ql.metadata.HiveException: Error in loading storage handler.org/apache//hadoop/hive/hbase/HBaseStorageHandler
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
> hive> 
> 
> Please advise.
> 
> 
>