[ 
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 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';



> 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)

Reply via email to