Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Finding maximum across a row


Copy link to this message
-
Re: Finding maximum across a row
Hi Sachin

You could get the detailed ateps from hive wiki itself

https://cwiki.apache.org/Hive/hiveplugins.html

Regards
Bejoy KS

Sent from remote device, Please excuse typos

-----Original Message-----
From: Sachin Sudarshana <[EMAIL PROTECTED]>
Date: Fri, 1 Mar 2013 22:37:54
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
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, <[EMAIL PROTECTED]> wrote:

> **
> 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
> ------------------------------
> *From: * Sachin Sudarshana <[EMAIL PROTECTED]>
> *Date: *Fri, 1 Mar 2013 22:16:37 +0530
> *To: *<[EMAIL PROTECTED]>
> *ReplyTo: * [EMAIL PROTECTED]
> *Subject: *Finding maximum across a row
>
> Hi,
>
> Is there any function/method to find the maximum across a row in hive?
>
> Suppose i have a table like this:
>
> ColA   ColB   ColC
> 2          5          7
> 3          2          1
>
> I want the function to return
>
> 7
> 1
>
>
> Its urgently required. Any help would be greatly appreciated!
>
>
>
> --
> Thanks and Regards,
>                 Sachin Sudarshana
>

--
Thanks and Regards,
                Sachin Sudarshana