Ravi, I don’t see any other option other than doing a self join. If not create another table with exact same data, and join both the tables with the right join conditions to join the previous record.
Thanks, Karthik From: Ravi Prasad [mailto:[email protected]] Sent: Monday, November 17, 2014 12:41 AM To: [email protected] Subject: Re: Analytic functions in Lead & Lag in Hive Hi Karthik, Thanks. But we are using Hive 0.10 version of Hive. Is there any alternative way available to implement this Lead / Lag functionality in Hive 0.10 version Regards Raviprasad On Fri, Nov 14, 2014 at 7:51 PM, Dhandapani, Karthik <[email protected]<mailto:[email protected]>> wrote: Ravi, Lead and Lag functions are introduced only in hive 0.11 version. Please refer to the below link for more details. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics Thanks, Karthik From: Ravi Prasad [mailto:[email protected]<mailto:[email protected]>] Sent: Friday, November 14, 2014 3:08 AM To: [email protected]<mailto:[email protected]> Subject: Analytic functions in Lead & Lag in Hive Cany anyone suggest, how to use the Lead and lag function in Hive. I am using Hive 0.10 version. Is there any way to make it work in 0.10 version. I have used the below code in Oracle, But it is not working in Hive. I need to compare the difference between the previous record and currect record. Oracle code for LAG :- SELECT empno, ename, job, sal, LAG(sal, 1, 0) OVER (ORDER BY sal) AS sal_prev, sal - LAG(sal, 1, 0) OVER (ORDER BY sal) AS sal_diff FROM emp; Oracle code for LEAD :- SELECT empno, ename, job, sal, LEAD(sal, 1, 0) OVER (ORDER BY sal) AS sal_next, LEAD(sal, 1, 0) OVER (ORDER BY sal) - sal AS sal_diff FROM emp; -- ---------------------------------------------- Regards, Prasad -- ---------------------------------------------- Regards, RAVI PRASAD. T
