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
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.