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
