[HIVE-8973] Add support for pulling HBase columns with regex matching

• Type: Improvement
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Component/s: Clients, HBase Handler
• Assignee: Unassigned
• Reporter: Sucaz Moshe
• Created: 26/Nov/14 07:22
• Updated: 13/Aug/15 05:59

Description

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