Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Wildcard support in specifying file location

Copy link to this message
Re: Wildcard support in specifying file location
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