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.

Hive returns Null Values from Hbase for decimal data type

Highlighted

Hive returns Null Values from Hbase for decimal data type

I have  a column of data type , decimal (32,1) in mysql . i sqooped entire table to hbase. all values are available in hbase.

 

While creating external table in hive the decimal values are not fetched its showing null values.

 

create external table a(c1 string,c2 double,c3 string) stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":row,cf:l,cf:x,cf:y")TBLPROPERTIES("hbase.table.name" = "vv");

 

tried with including #b for decimal data type but still null values.

("hbase.columns.mapping" = ":row,cf:l,cf:x#b,cf:y")

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