Return-Path: 
 <user-return-7435-apmail-hive-user-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-user-archive@www.apache.org
Delivered-To: apmail-hive-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id DF33D98EF
	for <apmail-hive-user-archive@www.apache.org>;
 Wed, 25 Jan 2012 18:47:41 +0000 (UTC)
Received: (qmail 46631 invoked by uid 500); 25 Jan 2012 18:47:40 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 46536 invoked by uid 500); 25 Jan 2012 18:47:40 -0000
Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hive.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hive.apache.org>
List-Post: <mailto:user@hive.apache.org>
List-Id: <user.hive.apache.org>
Reply-To: user@hive.apache.org
Delivered-To: mailing list user@hive.apache.org
Received: (qmail 46528 invoked by uid 99); 25 Jan 2012 18:47:40 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2012 18:47:40 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_FILL_THIS_FORM_SHORT
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of jingjungng@gmail.com
 designates 74.125.82.54 as permitted sender)
Received: from [74.125.82.54] (HELO mail-ww0-f54.google.com) (74.125.82.54)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Jan 2012 18:47:33 +0000
Received: by wgbds10 with SMTP id ds10so4330213wgb.23
        for <user@hive.apache.org>; Wed, 25 Jan 2012 10:47:12 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=vec5F6IWUZj4YcKIxLPKyf9I1bedq8op/jW+DYYv6Uc=;
        b=tislyw1euPH2ksLK7g45eacrKml7Tn7JAmmIZnWP74D273hZN8yclR9lWGQD/K6tsl
         Y8gaeYVbhsKlsj+O/GNHMLDUF4cja4/f44p7y7tFEg2R7VDQQ+/LM25fFSfSyFfPed6h
         QDjJJvsMrzl/iyyLXZbwrndXjyMfvwZUh7tJ4=
MIME-Version: 1.0
Received: by 10.180.93.193 with SMTP id cw1mr30407473wib.5.1327517232355; Wed,
 25 Jan 2012 10:47:12 -0800 (PST)
Received: by 10.216.185.204 with HTTP; Wed, 25 Jan 2012 10:47:12 -0800 (PST)
In-Reply-To: 
 <CAO0rWaZQaMC7LzLLGhe5H+MbNyzC6cfcTnEjU5pzf-66W5-FVg@mail.gmail.com>
References: 
 <CADxfZ77wC-xi7fYf3AjnaXiPjUPj20mHX5_oYESv97s0owtPLw@mail.gmail.com>
	<CAO0rWaZQaMC7LzLLGhe5H+MbNyzC6cfcTnEjU5pzf-66W5-FVg@mail.gmail.com>
Date: Wed, 25 Jan 2012 10:47:12 -0800
Message-ID: 
 <CADxfZ74iukyzJ_WupqKTvXv4PmV_KZyfsE=xQCofCxqTtKRXHw@mail.gmail.com>
Subject: Re: Hive query result in sequence file
From: jingjung Ng <jingjungng@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=f46d043bdede11590604b75eb12c

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

Thanks Aniket.

I am pretty new to hive, any java example (serde)  for archieving this ?

-Andrew

On Wed, Jan 25, 2012 at 12:12 AM, Aniket Mokashi <aniket486@gmail.com>wrote:

> You will have to do your own serde..
>
> Hive can write it sequencefile but it will be Text with NULL(bytewritable)
> key.
>
> Thanks,
> Aniket
>
>
> On Tue, Jan 24, 2012 at 11:41 PM, jingjung Ng <jingjungng@gmail.com>wrote:
>
>> Hi,
>>
>> I have following hive query (pseudo hive query code)
>>
>>  select name, address, phone from t1 join t2
>>
>> Executing above query will end up file stored in the format of name,
>> address, phone format on the fie system (hdfs or local).
>>
>> However  I'd like to write to either to a sequence file (key: name,
>> value: address and phone).
>>
>> Is this possible, if so how could I do this ?
>>
>>
>> Thank you.
>>
>> JingJung
>>
>
>
>
> --
> "...:::Aniket:::... Quetzalco@tl"
>

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

Thanks Aniket.<div><br></div><div>I am pretty new to hive, any java example=
 (serde) =A0for archieving this ?</div><div><br></div><div>-Andrew<br><div>=
<br><div class=3D"gmail_quote">On Wed, Jan 25, 2012 at 12:12 AM, Aniket Mok=
ashi <span dir=3D"ltr">&lt;<a href=3D"mailto:aniket486@gmail.com">aniket486=
@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">You will have to do your own serde..<div><br=
></div><div>Hive can write it sequencefile but it will be Text with NULL(by=
tewritable) key.</div>
<div><br></div><div>Thanks,</div><div>Aniket<div><div class=3D"h5"><br><br>=
<div class=3D"gmail_quote">On Tue, Jan 24, 2012 at 11:41 PM, jingjung Ng <s=
pan dir=3D"ltr">&lt;<a href=3D"mailto:jingjungng@gmail.com" target=3D"_blan=
k">jingjungng@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">Hi,<br><br>I have following hive query (pseu=
do hive query code)<br><br>=A0select name, address, phone from t1 join t2<b=
r>

<br>Executing above query will end up file stored in the format of name, ad=
dress, phone format on the fie system (hdfs or local). <br>
<br>However=A0 I&#39;d like to write to either to a sequence file (key: nam=
e, value: address and phone).<br><br>Is this possible, if so how could I do=
 this ?<br><br><br>Thank you.<span><font color=3D"#888888"><br>
<br>JingJung <br>
</font></span></blockquote></div><br><br clear=3D"all"><div><br></div></div=
></div><span class=3D"HOEnZb"><font color=3D"#888888">-- <br>&quot;...:::An=
iket:::... Quetzalco@tl&quot;<br>
</font></span></div>
</blockquote></div><br></div></div>

--f46d043bdede11590604b75eb12c--