Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

from hbase to hive external table qualifier problem

from hbase to hive external table qualifier problem

New Contributor

 

CREATE EXTERNAL TABLE batmana (key string, value string) 
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,personalDetails:cdr.servinggNodePLMNIdentifier")
TBLPROPERTIES("hbase.table.name" = "user");

i want to map my HBase table into hive external one but the problem is that my column qualifier has too many characters (more than 20) main cause that i don't get data into hive

is there any one hwo faced such problem or hwo can help please...?

Don't have an account?
Coming from Hortonworks? Activate your account here