Apache Hive How to round off to 2 decimal places?
<p>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:</p>

<pre><code>val DECIMAL(18, 3)
</code></pre>

<p>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?</p>

<p>Thanks a lot.</p>