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
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
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*