hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Swarnim Kulkarni (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-8973) Add support for pulling HBase columns with regex matching
Date Thu, 13 Aug 2015 05:59:46 GMT

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

Swarnim Kulkarni updated HIVE-8973:
-----------------------------------
    Component/s: HBase Handler

> Add support for pulling HBase columns with regex matching
> ---------------------------------------------------------
>
>                 Key: HIVE-8973
>                 URL: https://issues.apache.org/jira/browse/HIVE-8973
>             Project: Hive
>          Issue Type: Improvement
>          Components: Clients, HBase Handler
>            Reporter: Sucaz Moshe
>            Priority: Trivial
>
> Hi, 
> we would like to create table that pulling HBase columns with regex matching. for example:

> CREATE EXTERNAL TABLE XXX( 
> key string 
> , DATES MAP<STRING, BIGINT> 
> , FLOATS MAP<STRING, DOUBLE> 
> , STRINGS MAP<STRING, STRING> 
> ) 
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ( 
> "hbase.columns.mapping" = ":key, FECF:D_[0-9]*, FECF:F_[0-9]*, FECF:C[0-9]*_[0-9]*")

> TBLPROPERTIES ("hbase.table.name" = "XXX", "hbase.table.default.storage.type" = "binary");

> currently only prefix work (with hive 0.12.0): 
> CREATE EXTERNAL TABLE XXX( 
> key string 
> , DATES MAP<STRING, BIGINT> 
> , FLOATS MAP<STRING, DOUBLE> 
> , STRINGS MAP<STRING, STRING> 
> ) 
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ( 
> "hbase.columns.mapping" = ":key, FECF:D_.*, FECF:F_.*, FECF:C.*", 
> "hbase.table.default.storage.type" = "binary") 
> TBLPROPERTIES ("hbase.table.name" = "XXX");



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message