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

Switch to Threaded View
Hive, mail # user - Output from HiveQL query


Copy link to this message
-
Re: Output from HiveQL query
kulkarni.swarnim@...) 2012-07-12, 19:07
Yes.

INSERT OVERWRITE DIRECTORY '<PATH>'
would mean path on HDFS

INSERT OVERWRITE LOCAL DIRECTORY '<PATH>'
would mean path on the local FS.

On Thu, Jul 12, 2012 at 2:01 PM, Raihan Jamal <[EMAIL PROTECTED]> wrote:

> Basically, I was assuming that whenever you do any HiveQL query, all the
> outputs gets stored somewhere in HDFS, in some path. But from this thread
> discussion, it means they are not getting stored anywhere in HDFS, but you
> can specify the path where do you want to store them. Is that right?
>
>
>
> *Raihan Jamal*
>
>
>
> On Thu, Jul 12, 2012 at 11:56 AM, Roberto Sanabria <
> [EMAIL PROTECTED]> wrote:
>
>> Or you can output to a table and store it there.
>>
>>
>> On Thu, Jul 12, 2012 at 2:53 PM, VanHuy Pham <[EMAIL PROTECTED]>wrote:
>>
>>> The output can be printed out on terminal when you run it, or can be
>>> stored if you specify a location for it through the operator >.
>>> For example:
>>>
>>> /home/smith/bin/hive -f "file containing hive sql" >
>>> /home/smith/documents/output.txt
>>>
>>> On Thu, Jul 12, 2012 at 11:31 AM, Raihan Jamal <[EMAIL PROTECTED]>wrote:
>>>
>>>> I have one question related to the output from the HiveQL query.
>>>> Suppose I did some HiveQL query and I will be getting some output back, so
>>>> those result set are getting stored somewhere in HDFS? If yes?
>>>>
>>>> 1)      Then where they are getting stored and how can I access it?**
>>>>
>>>> 2)      And is there any time limit on that meaning after this much
>>>> particular time it will be deleted?**
>>>>
>>>>
>>>> *Raihan Jamal*
>>>>
>>>>
>>>
>>
>
--
Swarnim