[ 
https://issues.apache.org/jira/browse/HIVE-3211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Brock Noland updated HIVE-3211:
-------------------------------

    Description: 
With the current Hive-HBase integration, we need to specify the 
"hbase.columns.mapping" property that maps the hbase columns to the columns in 
hive. So for example,

{noformat}
hive> CREATE EXTERNAL TABLE complex(
key string, 
s struct<col1 : int, col2 : int>)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = ":key,cf:a"
)TBLPROPERTIES ("hbase.table.name" = "TEST_TABLE");;
{noformat}

The struct definition in the above query can quickly get very ugly if we are 
dealing with a very complicated structures stored in hbase columns. We should 
probably enhance the current columns mapping strategy to be able to provide a 
custom serializer and let it detect the structure by itself.

  was:
With the current Hive-HBase integration, we need to specify the 
"hbase.columns.mapping" property that maps the hbase columns to the columns in 
hive. So for example,

hive> CREATE EXTERNAL TABLE complex(
key string, 
s struct<col1 : int, col2 : int>)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (
"hbase.columns.mapping" = ":key,cf:a"
)TBLPROPERTIES ("hbase.table.name" = "TEST_TABLE");;

The struct definition in the above query can quickly get very ugly if we are 
dealing with a very complicated structures stored in hbase columns. We should 
probably enhance the current columns mapping strategy to be able to provide a 
custom serializer and let it detect the structure by itself.


> Enhance hbase column mapping strategy to support complicated structures
> -----------------------------------------------------------------------
>
>                 Key: HIVE-3211
>                 URL: https://issues.apache.org/jira/browse/HIVE-3211
>             Project: Hive
>          Issue Type: Improvement
>          Components: HBase Handler
>    Affects Versions: 0.9.0
>            Reporter: Swarnim Kulkarni
>            Assignee: Swarnim Kulkarni
>
> With the current Hive-HBase integration, we need to specify the 
> "hbase.columns.mapping" property that maps the hbase columns to the columns 
> in hive. So for example,
> {noformat}
> hive> CREATE EXTERNAL TABLE complex(
> key string, 
> s struct<col1 : int, col2 : int>)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES (
> "hbase.columns.mapping" = ":key,cf:a"
> )TBLPROPERTIES ("hbase.table.name" = "TEST_TABLE");;
> {noformat}
> The struct definition in the above query can quickly get very ugly if we are 
> dealing with a very complicated structures stored in hbase columns. We should 
> probably enhance the current columns mapping strategy to be able to provide a 
> custom serializer and let it detect the structure by itself.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to