Data Engineering Integration
- Data Engineering Integration 10.2.1
- All Products
The precision and scale of the result is calculated according to the following expression:dec(38,2) * dec(2,2)
Since the precision of the result is greater than 38, the Hive engine adjusts the scale to return the precision at a maximum value of 38. The following expression shows how the Hive engine adjusts the precision and scale:dec(38+2,2+2) = dec(40,4)
dec(40-2,4-2) = dec(38,2)