[SPARK-28461] Pad Decimal numbers with trailing zeros to the scale of the column - ASF JIRA

XML

Word

Printable

JSON

PostgreSQL:

postgres=# select cast(1 as decimal(38, 18));
       numeric
----------------------
 1.000000000000000000
(1 row)

Spark SQL:

spark-sql> select cast(1 as decimal(38, 18));
1
spark-sql>

Hive fix this issue by ~~HIVE-12063~~.

is related to

HIVE-12063 Pad Decimal numbers with trailing zeros to the scale of the column

links to

GitHub Pull Request #25214