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
-
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