[ 
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

        

Reply via email to