[
https://issues.apache.org/jira/browse/HIVE-17236?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
nirav patel updated HIVE-17236:
-------------------------------
Description:
Hive currently doesn't support wild card in path for external table. I think it
should considering mapreduce framework supports it and it's a common
requirement.
Following should work
CREATE EXTERNAL TABLE testTable (val map<string, string>)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LOCATION '/user/mycomp/customers/*/departments/partition/*/sales.tsv';
was:
Hive currently doesn't support wild car in path for external table. I think it
should considering mapreduce framework supports it and it's a common
requirement.
Following should work
CREATE EXTERNAL TABLE testTable (val map<string, string>)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LOCATION '/user/mycomp/customers/*/departments/partition/*/sales.tsv';
> Add support for wild card LOCATION for external table
> -----------------------------------------------------
>
> Key: HIVE-17236
> URL: https://issues.apache.org/jira/browse/HIVE-17236
> Project: Hive
> Issue Type: Improvement
> Components: Hive
> Affects Versions: 1.2.2
> Reporter: nirav patel
>
> Hive currently doesn't support wild card in path for external table. I think
> it should considering mapreduce framework supports it and it's a common
> requirement.
> Following should work
> CREATE EXTERNAL TABLE testTable (val map<string, string>)
> ROW FORMAT DELIMITED
> FIELDS TERMINATED BY '\t'
> LOCATION '/user/mycomp/customers/*/departments/partition/*/sales.tsv';
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
