RE: Hive help on the update

2013-06-28 Thread Christopher Wirt
e.org/Hive/languagemanual-windowingandanalytics.html From: Stephen Sprague [mailto:sprag...@gmail.com] Sent: 28 June 2013 17:30 To: user@hive.apache.org Subject: Re: Hive help on the update what version of hive are you running? and show us your attempts - don't be shy! On F

Re: Hive help on the update

2013-06-28 Thread Stephen Sprague
what version of hive are you running? and show us your attempts - don't be shy! On Fri, Jun 28, 2013 at 5:52 AM, Kumar Chinnakali < kumar_chinnak...@infosys.com> wrote: > Hi Hive Team, > > ** ** > > I have Teradata Query as below and my intention is to convert in to Hive > Query(HQL). Tri

Hive help on the update

2013-06-28 Thread Kumar Chinnakali
Hi Hive Team, I have Teradata Query as below and my intention is to convert in to Hive Query(HQL). Tried but it's vain. SELECT Col_1, Col_2, Col_3, MIN(Col_3) OVER(Partition by Col_1 ORDER BY Col_3, Col_2 rows between 1 preceding and 1 preceding) prev_Col_3 FROM work_table ; Example: Actual