Reply
Highlighted
Explorer
Posts: 28
Registered: ‎08-29-2017

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

Announcements