If you like to store the results of some hive query in a directory you need to use query like
INSERT OVERWRITE [LOCAL] DIRECTORY 'fs location' '<your query>
If a directory is not specified then the results of the query is just printed on the CLI.
From: Hongjie Guo <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: Monday, September 10, 2012 10:10 AM
Subject: Re: Where does hive store join query results
maybe there is empty ouput.if you can see "ok" in your consol,hive has already output the result.
2012/9/10 [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>I am running a join query on two tables in hive. When I run the join query, hive runs a map-reduce job.I can't seem to find the results of the join query.
>Can someone tell me where hive stores the results of the join query.