Hi Rajesh 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> 'https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Writingdataintofilesystemfromqueries If a directory is not specified then the results of the query is just printed on the CLI. Regards, Bejoy KS ________________________________ 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]> 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 >
