RE: Finding maximum across a row

2013-03-01 Thread John Morrison
Seems like you would want the results as: 7 3 Here is one way to get the maximum value for a collection of columns with a case statement. (this not done in Hive but hive case statements should work same way) ## data in table xyz select * from xyz ; c1 | c2 | c3 ++ 2 | 1 | 3 3

Re: Finding maximum across a row

2013-03-01 Thread bejoy_ks
@hive.apache.org Subject: Re: Finding maximum across a row Hi Bejoy, I am new to UDF in Hive. Could you send me any link/tutorials on where i can be able to learn about writing the UDF? Thanks! On Fri, Mar 1, 2013 at 10:22 PM, wrote: > ** > Hi Sachin > > AFAIK There isn't one at the mo

Re: Finding maximum across a row

2013-03-01 Thread Sachin Sudarshana
Hi Bejoy, I am new to UDF in Hive. Could you send me any link/tutorials on where i can be able to learn about writing the UDF? Thanks! On Fri, Mar 1, 2013 at 10:22 PM, wrote: > ** > Hi Sachin > > AFAIK There isn't one at the moment. But you can easily achieve this using > a custom UDF. > Regar

Re: Finding maximum across a row

2013-03-01 Thread bejoy_ks
Hi Sachin AFAIK There isn't one at the moment. But you can easily achieve this using a custom UDF. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Sachin Sudarshana Date: Fri, 1 Mar 2013 22:16:37 To: Reply-To: user@hive.apache.org Subject: Fin