Return-Path: 
 <user-return-11365-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 CD658DC60
	for <apmail-hive-user-archive@www.apache.org>;
 Fri, 14 Dec 2012 16:26:42 +0000 (UTC)
Received: (qmail 16455 invoked by uid 500); 14 Dec 2012 16:26:41 -0000
Delivered-To: apmail-hive-user-archive@hive.apache.org
Received: (qmail 16343 invoked by uid 500); 14 Dec 2012 16:26:41 -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 16335 invoked by uid 99); 14 Dec 2012 16:26:41 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Dec 2012 16:26:41 +0000
X-ASF-Spam-Status: No, hits=1.7 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of maya.bhardwaj11@gmail.com
 designates 209.85.223.176 as permitted sender)
Received: from [209.85.223.176] (HELO mail-ie0-f176.google.com)
 (209.85.223.176)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 14 Dec 2012 16:26:37 +0000
Received: by mail-ie0-f176.google.com with SMTP id 13so6085069iea.35
        for <user@hive.apache.org>; Fri, 14 Dec 2012 08:26:16 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        bh=hVeIQc4v/ehjy9M2TFo+DXHY/6uxnkgmgj2kOmjc4/4=;
        b=SXwk+2nsxe8oR5Dc1Oeu5jm2/hZU9yJBTbpHc4mEjdnrHW2IWECNO3Bi4aLgSlGXYh
         fUolEgqyxsI2s0Z9xZIR7umww/YPDVYQIYAwNr5U8HsIYyjOI/n6fvFZfhZnYI6y0Q/N
         YgKKo7mR6WWYB7YUcLnAvq3AnO0Z8QfB2cRi35G5aG+/apx2qDv+veRD3A033xH+QZcM
         P/qB0FGJnX6TuoHe3lL4QdTf4oErMKR2Tm/5RTAgXbI0RB004NEAoy4O6IyR9CXcdKy2
         xVvq5tdSFVyxZSWSISydxOGH6X0i2KWH+bwzu8/CN8VP8r2M0Z4aSkKw/bOBBLNdPZfx
         GIkw==
MIME-Version: 1.0
Received: by 10.50.34.230 with SMTP id c6mr2144009igj.10.1355502376358; Fri,
 14 Dec 2012 08:26:16 -0800 (PST)
Received: by 10.64.37.163 with HTTP; Fri, 14 Dec 2012 08:26:15 -0800 (PST)
In-Reply-To: <303D8786-0A47-4E21-B3FE-3C33B916AF6D@qubole.com>
References: 
 <CAMh8c2Cf3j9zUrus1iJHmrwsXNhrwMO-TRCmmp3C5JBfXOFkXQ@mail.gmail.com>
	<303D8786-0A47-4E21-B3FE-3C33B916AF6D@qubole.com>
Date: Fri, 14 Dec 2012 11:26:15 -0500
Message-ID: 
 <CAMh8c2DNdH4i8rEBpesAxGpZymyscsgbFxZ5ymkb8BBGOb5jVQ@mail.gmail.com>
Subject: Re: Hive Row number
From: maya bhardwaj <maya.bhardwaj11@gmail.com>
To: user@hive.apache.org
Content-Type: multipart/alternative; boundary=14dae9340819a2940a04d0d27d5d
X-Virus-Checked: Checked by ClamAV on apache.org

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

Thanks ShriKanth.


On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar <sshankar@qubole.com>wrote:

> See
> http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/doing_rank_with_hive
>
> thanks,
> Shrikanth
>
> On Dec 14, 2012, at 8:18 AM, maya bhardwaj wrote:
>
> I am converting the Netezza query in hive.How can i achieve following
> query in hive --> row_number() over (partition by record_id, event_id order
> by e_timestamp desc) as rnum
>
>
>

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

Thanks ShriKanth.=A0<div class=3D"gmail_extra"><br><br><div class=3D"gmail_=
quote">On Fri, Dec 14, 2012 at 11:22 AM, shrikanth shankar <span dir=3D"ltr=
">&lt;<a href=3D"mailto:sshankar@qubole.com" target=3D"_blank">sshankar@qub=
ole.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 style=3D"word-wrap:break-word">See=A0<a=
 href=3D"http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/doing_ra=
nk_with_hive" target=3D"_blank">http://www.edwardcapriolo.com/roller/edward=
capriolo/entry/doing_rank_with_hive</a><div>
<br></div><div>thanks,</div><div>Shrikanth<div class=3D"im"><br><div><div>O=
n Dec 14, 2012, at 8:18 AM, maya bhardwaj wrote:</div><br><blockquote type=
=3D"cite"><span style=3D"line-height:17px;font-size:13px;font-family:Arial,=
FreeSans,Helvetica,sans-serif">I am converting the Netezza query in hive.Ho=
w can i achieve following query in hive --&gt; row_number() over (partition=
 by record_id, event_id order by e_timestamp desc) as rnum</span><br>

</blockquote></div><br></div></div></div></blockquote></div><br></div>

--14dae9340819a2940a04d0d27d5d--