[ https://issues.apache.org/jira/browse/FOR-1250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Crossley closed FOR-1250. ------------------------------- Resolution: Invalid Closed. This is not a Forrest issue. Please see the Apache Hive project at https://hive.apache.org/ > 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)