[jira] [Created] (HIVE-8973) Add support for pulling HBase columns with regex matching

[Sucaz Moshe (JIRA)]

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)