hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "nirav patel (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-17236) Add support for wild card LOCATION for external table
Date Thu, 03 Aug 2017 00:26:00 GMT

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

Mime
View raw message