hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Asher Devuyst <>
Subject Hive and Hbase integration issue
Date Thu, 31 Jan 2013 20:17:30 GMT
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
Logging initialized using configuration in
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 for further
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("" =
Failed with exception org.apache.hadoop.hive.ql.metadata.HiveException:
Error in loading storage
FAILED: Execution Error, return code 1 from

Please advise.

View raw message