Jasper Knulst created HIVE-8871: ----------------------------------- Summary: Hive Hbase Integration : Support for NULL value columns Key: HIVE-8871 URL: https://issues.apache.org/jira/browse/HIVE-8871 Project: Hive Issue Type: Bug Components: HBase Handler Affects Versions: 0.10.0 Reporter: Jasper Knulst
If you map Hive to a Hbase table where one CF only has qualifiers but no values, Hive always outputs ' {} ' for that key. As soon as you put a single byte (like a space) as value you'll get a return like this ' {"20140911"," "}. Since it is a common data modelling technique in Hbase to not use the value (and essentially use the qualifier in a CF as value holder) I think it would be worthwhile to have some support for this in the Hbase handler. A solution could be to show a data structure like CF:qualifier:<NULL> like this: {"20140911",""} , where '20140911' is the qualifier and NULL value in Hbase are shown as empty json strings. CREATE EXTERNAL TABLE hb_test ( userhash string, count bigint, dates map<string,string>) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ( "hbase.columns.mapping" = ":key,SUM:COUNT,DATES:", "hbase.table.default.storage.type" = "binary" ) TBLPROPERTIES("hbase.table.name" = "test"); -- This message was sent by Atlassian JIRA (v6.3.4#6332)