cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.

Apache Hive How to round off to 2 decimal places? Ask

priyankamakke
2-Guest

Apache Hive How to round off to 2 decimal places? Ask

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 the 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 Hadoop Hive Training or rounded? What have I missed?

0 REPLIES 0
Announcements

Top Tags