You are viewing a plain text version of this content. The canonical link for it is here.
Posted to hdfs-user@hadoop.apache.org by Divya Gehlot <di...@gmail.com> on 2016/03/04 03:52:29 UTC
[Issue:]Getting null values for Numeric types while accessing hive
tables (Registered on Hbase,created through Phoenix)
Hi,
I am registering hive table on Hbase
CREATE EXTERNAL TABLE IF NOT EXISTS TEST(NAME STRING,AGE INT)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,0:AGE")
TBLPROPERTIES ("hbase.table.name" = "TEST",
"hbase.mapred.output.outputtable" = "TEST");
When I am trying to access data I am getting null for age as its a numeric
field.
test.name test.age
John null
Paul null
Peter null
Version I am using
Phoenix 4.4
Hbase 1.1.2
Hive 1.2 ?
Has any body face this issue ?
Would really appreciate the help.
Thanks,
Divya