You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Swarnim Kulkarni (JIRA)" <ji...@apache.org> on 2012/07/28 00:32:33 UTC
[jira] [Updated] (HIVE-3312) Improve Hive Map to HBase column
family
[ 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