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)
