[HIVE-22139] Will not pad Decimal numbers with trailing zeros if select from value

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.1
• Component/s: SQL
• Assignee: Naresh P R
• Reporter: Yuming Wang
• Created: 23/Aug/19 05:31
• Updated: 23/Aug/19 15:12

Description

How to reproduce:

hive> SELECT CAST(1 AS decimal(38, 18));
OK
1
Time taken: 0.226 seconds, Fetched: 1 row(s)
hive> CREATE TABLE HIVE_22139 AS SELECT CAST(1 AS decimal(38, 18)) as c;
OK
Time taken: 2.278 seconds
hive> SELECT * FROM HIVE_22139;
OK
1.000000000000000000
Time taken: 0.07 seconds, Fetched: 1 row(s)

Issue Links

• is related to: HIVE-12063 Pad Decimal numbers with trailing zeros to the scale of the column