You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Swarnim Kulkarni (JIRA)" <ji...@apache.org> on 2015/08/13 07:59:46 UTC
[jira] [Updated] (HIVE-8973) Add support for pulling HBase columns
with regex matching
[ 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)