[ https://issues.apache.org/jira/browse/HIVE-3312?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Swarnim Kulkarni updated HIVE-3312: ----------------------------------- Description: The documentation states the following way to use a map to access a whole column family: {code} 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" ); {code} 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. was: 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 be always be the case. This strategy should probably be improved to support different types of values stored in columns under the same column family. > Improve Hive Map to HBase column family > --------------------------------------- > > Key: HIVE-3312 > URL: https://issues.apache.org/jira/browse/HIVE-3312 > Project: Hive > Issue Type: Improvement > Components: HBase Handler > Affects Versions: 0.9.0 > Reporter: Swarnim Kulkarni > > The documentation states the following way to use a map to access a whole > column family: > {code} > 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" > ); > {code} > 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. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira