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

Switch to Threaded View
Hive >> mail # user >> Hive and Hbase integration issue

Copy link to this message
Hive and Hbase integration issue
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
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 http://www.slf4j.org/codes.html#StaticLoggerBinder 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("hbase.table.name" "raw_data");
Failed with exception org.apache.hadoop.hive.ql.metadata.HiveException:
Error in loading storage
FAILED: Execution Error, return code 1 from

Please advise.