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
Nitin Pawar 2013-08-10, 20:10
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