RE: Analytic functions in Lead & Lag in Hive

2014-11-17 Thread Dhandapani, Karthik
, 2014 12:41 AM To: user@hive.apache.org 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, No

Re: Analytic functions in Lead & Lag in Hive

2014-11-16 Thread Ravi Prasad
gt; Karthik > > > > *From:* Ravi Prasad [mailto:raviprasa...@gmail.com] > *Sent:* Friday, November 14, 2014 3:08 AM > *To:* user@hive.apache.org > *Subject:* Analytic functions in Lead & Lag in Hive > > > > Cany anyone suggest, how to use the Lead and lag function i

RE: Analytic functions in Lead & Lag in Hive

2014-11-14 Thread Dhandapani, Karthik
, November 14, 2014 3:08 AM To: user@hive.apache.org 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

Analytic functions in Lead & Lag in Hive

2014-11-14 Thread Ravi Prasad
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