Q:

Apache Hive How to round off to 2 decimal places?

Actually I'm looking for more details about the sum function in Apache Hive.
Until now, I understood that I can specify the number of digits after the dot:
val DECIMAL(18, 3)

But what I can not find is the precision scale in case of sum.
If I add 2 decimals with a precision scale of 3 for example, what will be the return of the sum function? My precision scale will be preserved?
The result will be truncated or rounded?
What have I missed?
Thanks a lot.

A:

Just round it to as many decimal places as you want.
select round(SUM(150.100 + 127.0090), 2);

Output of above will be:-
277.11

