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

Switch to Plain View
Hive, mail # user - Finding maximum across a row


+
Sachin Sudarshana 2013-03-01, 16:46
+
John Morrison 2013-03-01, 17:50
Copy link to this message
-
Re: Finding maximum across a row
bejoy_ks@... 2013-03-01, 16:52
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 <[EMAIL PROTECTED]>
Date: Fri, 1 Mar 2013 22:16:37
To: <[EMAIL PROTECTED]>
Reply-To: [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

+
Sachin Sudarshana 2013-03-01, 17:07
+
bejoy_ks@... 2013-03-01, 17:13