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

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
>

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
>

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, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> 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