# How to extract a column that has the highest value within row in Hive?

I have a table, more or less in the following format

col1 col2 col3 ... col100
val1 val2 val3 ... val100


Where val* are doubles. Is there a way to extract for each row in which column is the highest value within row in Hive?

For example, for table like

col1 col2 col3
2     4   5
8     1   2


I would get

col3
col1


select