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