Precision and Scale on the Hive Engine
Effective in version 10.2.1, the output of user-defined functions that perform multiplication on the Hive engine can have a maximum scale of 6 if the following conditions are true:
- The difference between the precision and scale is greater than or equal to 32.
- The resultant precision is greater than 38.
Previously, the scale could be as low as 0.
For more information, see the "Mappings in the Hadoop Environment" chapter in the
Informatica Big Data Management 10.2.1 User Guide.