Support Questions
Find answers, ask questions, and share your expertise

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...?