[HIVE-3312] Improve Hive Map to HBase column family

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 0.9.0
• Component/s: HBase Handler
• Assignee: Unassigned
• Reporter: Swarnim Kulkarni
• Created: 27/Jul/12 22:29
• Updated: 27/Jul/12 22:30

Description

The documentation states the following way to use a map to access a whole column family:

CREATE TABLE hbase_table_1(value map<string,int>, row_key int)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = "cf:,:key"
);

Now since we are mapping map<string,int> to the hbase column family cf, it makes a very crude assumption that all columns in the column family cf are expected to hold a int value which may not be the case always. This strategy should probably be improved to support different types of values stored in columns under the same column family.