Hi, I am using HDP 2.6. I am unable to create Hive External table for HBase. I always get an error saying FAILED: SemanticException Cannot find class 'org.apache.hadoop.hive.hbase.HbaseStorageHandler'

[#1]

FAILED: SemanticException Cannot find class 'org.apache.hadoop.hive.hbase.HbaseStorageHandl

[#2 · Accepted solution]

You need to use org.apache.hadoop.hive.hbase.HBaseStorageHandler.

Please see if that helps.

[#3]

I see there is a similar question and answer here:

https://community.hortonworks.com/questions/103167/hi-i-am-using-hdp-26-and-i-cant-seem-to-create-an...

[#4]

You should add hive-hbase-handler.jar in hive shell or hive-conf.

Connect Hive Shell

Execute these commands.

ADD JAR /usr/hdp/2.5.3.0-37/hive/lib/hive-hbase-handler.jar;

CREATE TABLE hbase_table_1(tags map<string,int>, row_key string)

STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'

WITH SERDEPROPERTIES ( "hbase.columns.mapping" = "cf:tag_.*,:key", "hbase.columns.mapping.prefix.hide" = "true" );

Then you'll find created table in hbase shell.