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)