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
-
Re: Hive and Hbase integration issue

Hi,

> org.apache..hadoop.hive.hbase.HBaseStorageHandler

Typo?

Have to be:
org.apache.hadoop.hive.hbase.HBaseStorageHandler

- Alex

On Jan 31, 2013, at 9:17 PM, Asher Devuyst <[EMAIL PROTECTED]> 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.

--
Alexander Alten-Lorenz
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF
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