Hive - convert Int to varchar and concatenate

Question

I have 2 columns I want to convert to varchars and concatenate to place them in one column:

How would I do this in Hive? I keep getting issues when I try the normal way in sql...

round(min(temp) over (partition by temp2, temp3) min,
round(max(temp)) over (partition by temp2, temp3) max

*original columns*
min    max
 0    100

=====================================

*new column*
min-max
$0-$100

Answer:

This worked for me.....

concat('$',cast(round(min(temp)) as string), ' - $', cast(round(max(temp)) as string)) over (partition by temp2, temp3) newColumn

Answer 1

Try this:

select ('$' || round(min(temp) over (partition by temp2, temp3) || '-' ||
        '$' || round(max(temp)) over (partition by temp2, temp3)
       ) as minmax