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

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). Tried but

RE: Hive help on the update

2013-06-28 Thread Christopher Wirt
/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 Fri, Jun 28