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 ( http://stackoverflow.com/questions/14864540/can-i-have-a-hive-external-table-partition-search-recursively) which points to two JIRAs, neither of which is resolved: - HIVE-1083 allow sub-directories for an external table/partition ( https://issues.apache.org/jira/browse/HIVE-1083) - HIVE-951 Selectively include EXTERNAL TABLE source files via REGEX ( https://issues.apache.org/jira/browse/HIVE-951) 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 <pande...@gmail.com> 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 >
