Created 05-16-2017 02:37 PM
FAILED: SemanticException Cannot find class 'org.apache.hadoop.hive.hbase.HbaseStorageHandl
Created 05-17-2017 08:14 PM
You need to use org.apache.hadoop.hive.hbase.HBaseStorageHandler.
Please see if that helps.
Created 05-17-2017 08:14 PM
You need to use org.apache.hadoop.hive.hbase.HBaseStorageHandler.
Please see if that helps.
Created 05-18-2017 03:25 AM
I see there is a similar question and answer here:
Created 05-18-2017 01:04 AM
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.