-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 (
> 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 <[EMAIL PROTECTED]> wrote:
>> I am newbie to Hive . While creating external tables, can we use
>> wildcard to specify file location.
>> STORED AS TEXTFILE LOCATION 's3://root/*/date*/'
>> Is the above specification valid in hive 0.7.1?