What Lefty said is correct as per my understanding. By default, hive maps a table with a directory with location parameter But then you can alter it to point to a single file. (thats the hack to use a file as storage location for hive table).
But it does not support regex based files as storage files for tables yet. May be someone from hive (dev + designers + architects) will be able to tell this if its doable in anyway. I just tried it. it fails miserably On Sun, Aug 11, 2013 at 12:30 AM, Lefty Leverenz <[email protected]>wrote: > 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 <[email protected]> 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 >> > > > > -- Nitin Pawar
