Re: Where does hive store join query results

2012-09-10 Thread Edward Capriolo
Hive does not store the results anywhere unless you insert the results into another table, local or hdfs file. See the syntax for INSERT. On Mon, Sep 10, 2012 at 12:23 AM, rajesh.ba...@orkash.com wrote: > Hi Everyone, > I am running a join query on two tables in hive. When I run the join query, >

Re: Where does hive store join query results

2012-09-09 Thread Bejoy KS
f a directory is not specified then the results of the query is just printed on the CLI.   Regards, Bejoy KS From: Hongjie Guo To: user@hive.apache.org Sent: Monday, September 10, 2012 10:10 AM Subject: Re: Where does hive store join query results maybe there i

Re: Where does hive store join query results

2012-09-09 Thread Hongjie Guo
maybe there is empty ouput.if you can see "ok" in your consol,hive has already output the result. 2012/9/10 rajesh.ba...@orkash.com > Hi Everyone, > 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 >

Where does hive store join query results

2012-09-09 Thread rajesh.ba...@orkash.com
Hi Everyone, 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. Thanks Rajesh Kumar