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