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

Hive returns Null Values from Hbase for decimal data type

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")