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