[ https://issues.apache.org/jira/browse/HIVE-22139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuming Wang updated HIVE-22139: ------------------------------- Description: How to reproduce: {code:sql} 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) {code} was: How to reproduce: {code:sql} // code placeholder {code} > Will not pad Decimal numbers with trailing zeros if select from value > --------------------------------------------------------------------- > > Key: HIVE-22139 > URL: https://issues.apache.org/jira/browse/HIVE-22139 > Project: Hive > Issue Type: Bug > Components: SQL > Affects Versions: 3.1.1 > Reporter: Yuming Wang > Priority: Major > > How to reproduce: > {code:sql} > 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) > {code} -- This message was sent by Atlassian Jira (v8.3.2#803003)