Re: [HQL] How to compare same column between rows?

2014-11-17 Thread Suhas Gogate
I think custom UDAF is the only way to achieve what you need. See existing UDAFs available in Hive @ https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Built-inAggregateFunctions(UDAF) --Suhas On Mon, Nov 17, 2014 at 4:14 PM, Mungeol Heo wrote: > Hi, > > My qu

[HQL] How to compare same column between rows?

2014-11-17 Thread Mungeol Heo
Hi, My question is that does Hive able to compare same column between rows. For instance, I have a table which contains data like below. name, value a, 1 a, 2 b, 1 c, 1 a, 13 b, 11 What I need is to compare 'value' columns between rows which have same 'name'. For the name 'a' first 'a' comes, t

Re: [ANNOUNCE] Apache Hive 0.14.0 Released

2014-11-17 Thread Suhas Gogate
Congrats! This is a big step for Hive! --Suhas On Mon, Nov 17, 2014 at 3:05 PM, Thejas Nair wrote: > The link to the download page is now - > https://hive.apache.org/downloads.html > (I have also corrected the email template in how-to-release wiki with new > url). > > > On Mon, Nov 17, 2014 at

Re: [ANNOUNCE] Apache Hive 0.14.0 Released

2014-11-17 Thread Thejas Nair
The link to the download page is now - https://hive.apache.org/downloads.html (I have also corrected the email template in how-to-release wiki with new url). On Mon, Nov 17, 2014 at 1:59 PM, Roshan Naik wrote: > 1) fyi.. this link is broken: > > http://hive.apache.org/releases.html > > 2) Jav

Re: [ANNOUNCE] Apache Hive 0.14.0 Released

2014-11-17 Thread Roshan Naik
1) fyi.. this link is broken: http://hive.apache.org/releases.html 2) Java docs were not published for 0.14.0 https://hive.apache.org/javadoc.html On Sun, Nov 16, 2014 at 7:04 PM, Clark Yang (杨卓荦) wrote: > Great job! Congrats! > > Thanks, > Zhuoluo (Clark) Yang > > 2014-11-13 8:55 GMT+08:0

RE: Analytic functions in Lead & Lag in Hive

2014-11-17 Thread Dhandapani, Karthik
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:raviprasa...@gmail.com] Sent: Monday, November 17, 20

Show current roles failing on Apache hive 0.13.1

2014-11-17 Thread Ravi Kumar
Hi All I am trying to run 'Show current roles' on Apache hive 0.13.1 but getting following error, hive> SHOW CURRENT ROLES; Error in role operation show_current_role on role name null, error message Unkown role operation show_current_role FAILED: Execution Error, return code 1 from org.apache.h