By default, no. They will be displayed onto the console. Try this to store them in HDFS:
INSERT OVERWRITE DIRECTORY '/tmp/hdfs_out' SELECT * FROM invites a WHERE a.ds='2008-08-15'; The results of the query will be stored in '/tmp/hdfs_out' directory on HDFS. I am not sure I understood your question about time limit. Once in HDFS, it should be upto you to decide till when you want them to be there right? On Thu, Jul 12, 2012 at 1:31 PM, 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
