[jira] [Commented] (SPARK-28461) Pad Decimal numbers with trailing zeros to the scale of the column

["Dongjoon Hyun (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-28461?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16889627#comment-16889627 ] 

Dongjoon Hyun commented on SPARK-28461:
---------------------------------------

Hi, [~yumwang]. Please link the issue to `Issue Links` instead of embedding in the JIRA description.

> Pad Decimal numbers with trailing zeros to the scale of the column
> ------------------------------------------------------------------
>
>                 Key: SPARK-28461
>                 URL: https://issues.apache.org/jira/browse/SPARK-28461
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: Yuming Wang
>            Priority: Major
>
> PostgreSQL:
> {code:sql}
> postgres=# select cast(1 as decimal(38, 18));
>        numeric
> ----------------------
>  1.000000000000000000
> (1 row)
> {code}
> Spark SQL:
> {code:sql}
> spark-sql> select cast(1 as decimal(38, 18));
> 1
> spark-sql>
> {code}
> Hive fix this issue by HIVE-12063.



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org