Learn about the change in certain functionality of Hive that has resulted in a change in
behavior from the previously released version to this version of Cloudera Runtime.
- Summary:
- Change in behavior of precision and scale in arithmetic
operations.
- Previous behavior:
- In CDP Private Cloud Base 7.1.6 and lower versions, the default
maximum precision and scale for arithmetic operations was calculated differently.
- For example, the following expression returns a result of
15237461344547437170.339101086652 with decimal(34,
12):select cast( '12346789101112123.12345678' as decimal(25,8)) * cast('1234.1234' as decimal(25,8))
- New behavior:
- In CDP Private Cloud Base 7.1.7 and higher versions, the default
maximum precision and scale for arithmetic operations follow the specifications defined in
Microsoft SQL Server documentation.
- As a result, the above expression returns a result of
15237461344547437170.339101 with decimal(38, 6).
