viirya commented on a change in pull request #25214: [SPARK-28461][SQL] Pad
Decimal numbers with trailing zeros to the scale of the column
URL: https://github.com/apache/spark/pull/25214#discussion_r349957892
##########
File path: docs/sql-migration-guide.md
##########
@@ -224,6 +224,32 @@ license: |
- Since Spark 3.0, when casting string value to integral types, including
tinyint, smallint, int and bigint type, the leading and trailing white
spaces(<= ACSII 32) will be trimmed before convert to integral values, e.g.
`cast(' 1 ' as int)` results `1`. In Spark version 2.4 and earlier, the result
will be `null`.
+ - Since Spark 3.0, we pad decimal numbers with trailing zeros to the scale
of the column for Hive result, for example:
+ <table class="table">
+ <tr>
+ <th>
+ <b>Query</b>
+ </th>
+ <th>
+ <b>Spark 2.4 or Prior or Hive</b>
Review comment:
why Hive here? isn't this default behavior of Hive? @wangyum
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]