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

Switch to Plain View
Hive, mail # user - Hive and Hbase integration issue


+
Asher Devuyst 2013-01-31, 20:17
+
kulkarni.swarnim@... 2013-02-01, 00:54
Copy link to this message
-
Re: Hive and Hbase integration issue
Alexander Alten-Lorenz 2013-02-01, 09:38

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