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
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