Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of prvs=5743874461=venky@fb.com
 designates 67.231.153.30 as permitted sender)
From: Venky Iyer <venky@fb.com>
To: "dev@hive.apache.org" <dev@hive.apache.org>
Subject: Re: [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST
 analytical windowing functions to Hive.
Thread-Topic: [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST
 analytical windowing functions to Hive.
Thread-Index: AQHN/+VZnx/gBX1sC0q57GlB3lohCJhjzZAA
Date: Thu, 31 Jan 2013 19:10:44 +0000
Message-ID: 
 <BE042762D98B5B47A6D9DEF30BA48F4E8DA72E2A@PRN-MBX01-5.TheFacebook.com>
In-Reply-To: <JIRA.12438744.1256158487291.224221.1359658876194@arcas>
Accept-Language: en-US
Content-Language: en-US
user-agent: Microsoft-MacOutlook/14.12.0.110505
Content-Type: text/plain; charset="us-ascii"
Content-ID: <E82E45BDD94DB94EA4865FCBBDF5C19B@fb.com>
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

unsubscribe

On 1/31/13 11:01 AM, "Ashutosh Chauhan (JIRA)" <jira@apache.org> wrote:


    [=20
https://issues.apache.org/jira/browse/HIVE-896?page=3Dcom.atlassian.jira.pl=
ug
in.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D13567950#comme=
nt
-13567950 ]=20

Ashutosh Chauhan commented on HIVE-896:
---------------------------------------

Thanks Prajakta for explanation. Make sense, But to your last point which
Harish also noted in previous comment:
bq. So currently, we are filtering the VCs and setting up a new
RowResolver for ExtractOperator during translation so that the columns at
runtime match with those during translation.
I think we cannot always filter out VC's for RR of ExtractOp. That will
depend on whether user has selected VCs or not in the query. No?
               =20
> Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.
> ---------------------------------------------------------------
>
>                 Key: HIVE-896
>                 URL: https://issues.apache.org/jira/browse/HIVE-896
>             Project: Hive
>          Issue Type: New Feature
>          Components: OLAP, UDF
>            Reporter: Amr Awadallah
>            Priority: Minor
>         Attachments: DataStructs.pdf, HIVE-896.1.patch.txt,
>Hive-896.2.patch.txt
>
>
> Windowing functions are very useful for click stream processing and
>similar time-series/sliding-window analytics.
> More details at:
>=20
>http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analys
>is.htm#i1006709
>=20
>http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analys
>is.htm#i1007059
>=20
>http://download-west.oracle.com/docs/cd/B13789_01/server.101/b10736/analys
>is.htm#i1007032
> -- amr

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA
administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira