hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <>
Subject Re: Wildcard support in specifying file location
Date Sat, 10 Aug 2013 19:00:41 GMT
I don't know the answer but my guess is no, you can't use wildcards to
specify file locations when creating external tables.  Since nobody else
has answered I suggest you just try it and see what happens.

Or google "hive location wildcard" -- that led me to a related question on
stackoverflow (
which points to two JIRAs, neither of which is resolved:

- HIVE-1083  allow sub-directories for an external table/partition  (

- HIVE-951  Selectively include EXTERNAL TABLE source files via REGEX  (

If my guess is wrong and you're able to use wildcards, please let me know
so I can add that information to the Hive wiki.

-- Lefty Leverenz

On Mon, Jul 22, 2013 at 7:47 AM, pandees waran <> wrote:

> Hi,
> I am newbie  to Hive . While creating external tables, can we use wildcard
> to specify file location.
> i.e:
> STORED AS TEXTFILE LOCATION 's3://root/*/date*/'
> Is the above specification valid in hive 0.7.1?
> Thanks

View raw message