Return-Path: 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 333251011A for ; Wed, 24 Jul 2013 19:00:18 +0000 (UTC) Received: (qmail 31905 invoked by uid 500); 24 Jul 2013 19:00:16 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 31696 invoked by uid 500); 24 Jul 2013 19:00:15 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 31688 invoked by uid 99); 24 Jul 2013 19:00:15 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Jul 2013 19:00:15 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of j.barrett.strausser@gmail.com designates 209.85.212.169 as permitted sender) Received: from [209.85.212.169] (HELO mail-wi0-f169.google.com) (209.85.212.169) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Jul 2013 19:00:11 +0000 Received: by mail-wi0-f169.google.com with SMTP id c10so5520180wiw.0 for ; Wed, 24 Jul 2013 11:59:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=iNmdJGYd3Gz2JLq+9JXqLSzyxhfT0lwTz1HOriF+RSA=; b=dQbM1PvfAoZItQpKK9WClCqMcSZm0QtjDaSJxJHOWkEjVUk/uwBi7FnnudU+PxheE6 LDwwvoA2hyVzvALiJnScYRqiEKQZLqVpJmH5h9j2uj55l9Ulyt9XqVotkwqrsfTQcdR6 azMffCc3KtMBt+E4+EbnC2k2rpeUV/iXf4P+7Vp93zX2WQtwGvTMjGDt5vFiLHK1HFfP FO0aUxt16hwRlYyjcEckwt87RODkByoYtIAQdseacxEAYFzmf41Qdn7ciWY2yPXcyqF6 EeFGHTIa/q1c964HCIhvOXcwN1945JjqUAA0txmS5B4kHO0Kc6sqIfa10e6BJFLYkb1X MSwA== MIME-Version: 1.0 X-Received: by 10.180.38.102 with SMTP id f6mr3731091wik.12.1374692390070; Wed, 24 Jul 2013 11:59:50 -0700 (PDT) Received: by 10.194.5.227 with HTTP; Wed, 24 Jul 2013 11:59:50 -0700 (PDT) Date: Wed, 24 Jul 2013 14:59:50 -0400 Message-ID: Subject: Semantics of Rank. From: "j.barrett Strausser" To: user@hive.apache.org Content-Type: multipart/alternative; boundary=e89a8f64335895f0c804e24683f5 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8f64335895f0c804e24683f5 Content-Type: text/plain; charset=ISO-8859-1 It seems as though I am required to pass in an argument to RANK(). What is the effect of passing this argument in ? In a RANK function the output for RANK should be the number of rows preceding a row in a given window. As windows are specified by the partition and order by fields I don't understand the effect of passing in an arg to RANK Are the other non-aggregate function similar? Meaning : Cume_dist, Ntile -- https://github.com/bearrito @deepbearrito --e89a8f64335895f0c804e24683f5 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
It seems as though I am required to pass in= an argument to RANK().

What is the effect of passing this arg= ument in ?

In a RANK function the output for RANK should be t= he number of rows preceding
a row in a given window. As=A0 windows are specified by the partition and order by fields I don't understand the effect of passing= =20 in an arg to RANK

Are the other non-aggregate function similar= ? Meaning : Cume_dist, Ntile
--


<= a href=3D"https://github.com/bearrito" target=3D"_blank">https://github.com= /bearrito
@deepbearrito
--e89a8f64335895f0c804e24683f5--