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


Copy link to this message
-
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
+
John Morrison 2013-03-01, 17:50
+
bejoy_ks@... 2013-03-01, 16:52
+
Sachin Sudarshana 2013-03-01, 17:07
+
bejoy_ks@... 2013-03-01, 17:13