Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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

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

NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB