Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Where does hive store join query results


+
rajesh.bawal@...) 2012-09-10, 04:23
+
Hongjie Guo 2012-09-10, 04:40
Copy link to this message
-
Re: Where does hive store join query results
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
>
+
Edward Capriolo 2012-09-10, 14:14
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB