Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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.
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB