Decimal to string change
Hive decimal to string conversion yields results having incorrect padding. LPAD on a decimal(7,1) value of 0 returns "0" (plus padding) but it should be "0.0" (plus padding).
Before Upgrade to CDP
Decimal to string conversion incorrectly formats the padding of the result.
select cast(cast('3404045.5044003' as decimal(18,9)) as string);
Output is: 3404045.5044003
After Upgrade to CDP
HIVE-20082 corrected the problem. Output of the query above correctly pads the result to 9 digits after the decimal point: 3404045.504400300