hive-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] (HIVE-8973) Add support for pulling HBase columns with regex matching
Date Wed, 26 Nov 2014 07:23:12 GMT
Sucaz Moshe created HIVE-8973:
---------------------------------

             Summary: 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
            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