[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-07-30 Thread Guilherme Braccialli (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13724575#comment-13724575 ] Guilherme Braccialli commented on HIVE-896: --- Harish, I noticed that NPath class

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-07-30 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13724866#comment-13724866 ] Harish Butani commented on HIVE-896: The syntax now is different from the original

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-04 Thread Hudson (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13622998#comment-13622998 ] Hudson commented on HIVE-896: - Integrated in Hive-trunk-hadoop2 #138 (See

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-02 Thread Brock Noland (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13619850#comment-13619850 ] Brock Noland commented on HIVE-896: --- +1 Nice work guys! Sorry I have been OOO so I

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-02 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13619930#comment-13619930 ] Ashutosh Chauhan commented on HIVE-896: --- I must acknowledge other folks have also

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-02 Thread Gunther Hagleitner (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13620104#comment-13620104 ] Gunther Hagleitner commented on HIVE-896: - Amazing! Thanks Harish!

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-02 Thread eric baldeschwieler (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13620226#comment-13620226 ] eric baldeschwieler commented on HIVE-896: -- very cool Add

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-02 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13620592#comment-13620592 ] Harish Butani commented on HIVE-896: I second Ashutosh's comment. Thanks Prajakta,

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-04-01 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13619526#comment-13619526 ] Ashutosh Chauhan commented on HIVE-896: --- Running tests. Will commit if tests pass.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-03-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13618537#comment-13618537 ] Ashutosh Chauhan commented on HIVE-896: --- I am +1 on this. I have overseen this entire

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-03-29 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13617954#comment-13617954 ] Harish Butani commented on HIVE-896: uploaded .5 Add

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-04 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13570306#comment-13570306 ] Harish Butani commented on HIVE-896: Attached patch to be used as starting point for

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569211#comment-13569211 ] Alan Gates commented on HIVE-896: - [~rhbutani] I've been looking at the syntax for invoking

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569257#comment-13569257 ] Harish Butani commented on HIVE-896: Yes you got most of it correct. So if there are no

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569324#comment-13569324 ] Alan Gates commented on HIVE-896: - I was wondering if there's a standard way to do

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-02-01 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13569345#comment-13569345 ] Harish Butani commented on HIVE-896: Yes Aster is the one I had looked at too. The other

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567779#comment-13567779 ] Ashutosh Chauhan commented on HIVE-896: --- That sounds like a bug in existing trunk. If

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Prajakta Kalmegh (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567856#comment-13567856 ] Prajakta Kalmegh commented on HIVE-896: --- This is not exactly a bug. In the existing

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567950#comment-13567950 ] Ashutosh Chauhan commented on HIVE-896: --- Thanks Prajakta for explanation. Make sense,

Re: [jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Venky Iyer
unsubscribe On 1/31/13 11:01 AM, Ashutosh Chauhan (JIRA) j...@apache.org wrote: [ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plug in.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567950#comment -13567950 ] Ashutosh Chauhan commented on HIVE-896:

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568018#comment-13568018 ] Ashutosh Chauhan commented on HIVE-896: --- Did some further testing on my 1-node pseudo

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568035#comment-13568035 ] Harish Butani commented on HIVE-896: can you try set

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568053#comment-13568053 ] Ashutosh Chauhan commented on HIVE-896: --- Yeah that worked fine. My 1-node pseudo

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568420#comment-13568420 ] Ashutosh Chauhan commented on HIVE-896: --- Created phabricator review entry to ease

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-31 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13568425#comment-13568425 ] Harish Butani commented on HIVE-896: Ashutosh, So the plan looks like this: ... -

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13566946#comment-13566946 ] Ashutosh Chauhan commented on HIVE-896: --- PTFDesc only contains a serialized string for

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-30 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13566952#comment-13566952 ] Ashutosh Chauhan commented on HIVE-896: --- Also need to make sure that ASTNode and other

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-30 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13567271#comment-13567271 ] Harish Butani commented on HIVE-896: Yes, exactly. Will start to introduce the new Spec

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13563594#comment-13563594 ] Harish Butani commented on HIVE-896: Hi, Just posted a second preliminary patch. This

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13563596#comment-13563596 ] Ashutosh Chauhan commented on HIVE-896: --- Hey Harish, Thanks for updating the patch.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-26 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13563617#comment-13563617 ] Harish Butani commented on HIVE-896: No this needs addressing. Currently the Definition

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13560860#comment-13560860 ] Harish Butani commented on HIVE-896: Alan, I have attached a document describing the

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Ashutosh Chauhan (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13561116#comment-13561116 ] Ashutosh Chauhan commented on HIVE-896: --- [~rhbutani] Image in your html doc didn't

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-23 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13561145#comment-13561145 ] Harish Butani commented on HIVE-896: Done. Sorry about that. Add

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559097#comment-13559097 ] Alan Gates commented on HIVE-896: - Harish, Thanks for you replies. I want to think on your

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559154#comment-13559154 ] Harish Butani commented on HIVE-896: Alan, Thanks for spending the time. Yes your e.g.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559257#comment-13559257 ] Alan Gates commented on HIVE-896: - I'd definitely like to get a new version of the patch.

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-21 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13559263#comment-13559263 ] Harish Butani commented on HIVE-896: Its https://github.com/hbutani/hive (ptf branch)

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-19 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13558058#comment-13558058 ] Harish Butani commented on HIVE-896: 1. This is only true as long as you have only one

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-18 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13557700#comment-13557700 ] Alan Gates commented on HIVE-896: - bq. If I read this right you are using CLUSTER BY and

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-08 Thread Alan Gates (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13547347#comment-13547347 ] Alan Gates commented on HIVE-896: - Harish, Could you point out the interfaces (in the API

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2013-01-08 Thread Harish Butani (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13547625#comment-13547625 ] Harish Butani commented on HIVE-896: Hi Alan, Thanks for taking the time. Here are my

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2012-04-16 Thread Harish Butani (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13255251#comment-13255251 ] Harish Butani commented on HIVE-896: Hi, Yes, I have been developing SQL Windowing on

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2012-01-17 Thread Jeff Hammerbacher (Commented) (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13187738#comment-13187738 ] Jeff Hammerbacher commented on HIVE-896: Guy who appears to be from SAP has posted

[jira] [Commented] (HIVE-896) Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.

2011-07-10 Thread Zhuoluo (Clark) Yang (JIRA)
[ https://issues.apache.org/jira/browse/HIVE-896?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13062727#comment-13062727 ] Zhuoluo (Clark) Yang commented on HIVE-896: --- I think it is necessary to have a