Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of edlinuxguru@gmail.com
 designates 209.85.212.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAORpBsj8rhmGYzFZ8ak_K8SCjn7JAB=nYL14K-VMadOsXa4RpQ@mail.gmail.com>
References: 
 <CA+pqXLZcQJzNDAzJNCPyNA9Pwmfos=KnUJPwR+2qrY_4Mq5nKQ@mail.gmail.com>
	<CAORpBsj8rhmGYzFZ8ak_K8SCjn7JAB=nYL14K-VMadOsXa4RpQ@mail.gmail.com>
Date: Thu, 4 Jul 2013 12:10:09 -0400
Message-ID: 
 <CAENxBwzarKfqoGncMJVTCQSeaD_df3j-3b6OH0YLeGqA4dTZug@mail.gmail.com>
Subject: Re: How Can I store the Hive query result in one file ?
From: Edward Capriolo <edlinuxguru@gmail.com>
To: "user@hive.apache.org" <user@hive.apache.org>
Content-Type: multipart/alternative; boundary=e89a8f3ba255f94cbb04e0b1cf07

--e89a8f3ba255f94cbb04e0b1cf07
Content-Type: text/plain; charset=ISO-8859-1

Normally if use set mapred.reduce.tasks=1 you get one output file. You can
also look at
*hive*.*merge*.*mapfiles*, mapred.reduce.tasks, hive.merge.reducefiles also
you can use a separate tool https://github.com/edwardcapriolo/filecrush


On Thu, Jul 4, 2013 at 6:38 AM, Nitin Pawar <nitinpawar432@gmail.com> wrote:

> will hive -e "query" > filename  or hive -f query.q > filename will do ?
>
> you specially want it to write into a named file on hdfs only?
>
>
> On Thu, Jul 4, 2013 at 3:12 PM, Matouk IFTISSEN <
> matouk.iftissen@ysance.com> wrote:
>
>> Hello Hive users,
>> Is there a manner to store the Hive  query result (SELECT *.....) in a
>> specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL
>> DIRECTORY '/directory_path_name/')?
>> Thanks for your answers
>>
>>
>
>
> --
> Nitin Pawar
>

--e89a8f3ba255f94cbb04e0b1cf07
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Normally if use set mapred.reduce.tasks=3D1 you get o=
ne output file. You can also look at<br><span class=3D""><em>hive</em>.<em>=
merge</em>.<em>mapfiles</em></span>, mapred.reduce.tasks, hive.merge.reduce=
files also you can use a separate tool <a href=3D"https://github.com/edward=
capriolo/filecrush">https://github.com/edwardcapriolo/filecrush</a><br>
</div></div><div class=3D"gmail_extra"><br><br><div class=3D"gmail_quote">O=
n Thu, Jul 4, 2013 at 6:38 AM, Nitin Pawar <span dir=3D"ltr">&lt;<a href=3D=
"mailto:nitinpawar432@gmail.com" target=3D"_blank">nitinpawar432@gmail.com<=
/a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex"><div dir=3D"ltr">will hive -e &quot;query&qu=
ot; &gt; filename =A0or hive -f query.q &gt; filename will do ?=A0<div><br>=
</div>
<div>you specially want it to write into a named file on hdfs only?=A0</div=
></div><div class=3D"gmail_extra">
<br><br><div class=3D"gmail_quote">On Thu, Jul 4, 2013 at 3:12 PM, Matouk I=
FTISSEN <span dir=3D"ltr">&lt;<a href=3D"mailto:matouk.iftissen@ysance.com"=
 target=3D"_blank">matouk.iftissen@ysance.com</a>&gt;</span> wrote:<br><blo=
ckquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #c=
cc solid;padding-left:1ex">

<div dir=3D"ltr"><div><div>Hello Hive users,<br></div>Is there a manner to =
store the Hive=A0 query result (SELECT *.....) in a specfique  and alone fi=
le (given the file name) like (INSERT OVERWRITE LOCAL DIRECTORY &#39;/direc=
tory_path_name/&#39;)?<br>


</div>Thanks for your answers<br><div><br></div></div><span class=3D"HOEnZb=
"><font color=3D"#888888">
</font></span></blockquote></div><span class=3D"HOEnZb"><font color=3D"#888=
888"><br><br clear=3D"all"><div><br></div>-- <br>Nitin Pawar<br>
</font></span></div>
</blockquote></div><br></div>

--e89a8f3ba255f94cbb04e0b1cf07--