forrest-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sucaz Moshe (JIRA)" <j...@apache.org>
Subject [jira] [Created] (FOR-1250) HIVE - Add support for pulling HBase columns with regex matching
Date Wed, 05 Nov 2014 11:45:33 GMT
Sucaz Moshe created FOR-1250:
--------------------------------

             Summary: HIVE - Add support for pulling HBase columns with regex matching
                 Key: FOR-1250
                 URL: https://issues.apache.org/jira/browse/FOR-1250
             Project: Forrest
          Issue Type: Bug
          Components: Other
            Reporter: Sucaz Moshe


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]*",
"hbase.table.default.storage.type" = "binary")
TBLPROPERTIES ("hbase.table.name" = "XXX");

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