maropu commented on a change in pull request #27909: [SPARK-31151][SQL][DOC]
Reorganize the migration guide of SQL
URL: https://github.com/apache/spark/pull/27909#discussion_r392562097
##########
File path: docs/sql-migration-guide.md
##########
@@ -201,6 +222,58 @@ license: |
</tr>
</table>
+ - Since Spark 3.0, when casting interval values to string type, there is no
"interval" prefix, e.g. `1 days 2 hours`. In Spark version 2.4 and earlier, the
string contains the "interval" prefix like `interval 1 days 2 hours`.
+
+ - Since Spark 3.0, when casting string value to integral types(tinyint,
smallint, int and bigint), datetime types(date, timestamp and interval) and
boolean type, the leading and trailing whitespaces (<= ASCII 32) will be
trimmed before converted to these type values, e.g. `cast(' 1\t' as int)`
results `1`, `cast(' 1\t' as boolean)` results `true`, `cast('2019-10-10\t as
date)` results the date value `2019-10-10`. In Spark version 2.4 and earlier,
while casting string to integrals and booleans, it will not trim the
whitespaces from both ends, the foregoing results will be `null`, while to
datetimes, only the trailing spaces (= ASCII 32) will be removed.
+
+### SQL Query Statements
+
Review comment:
Since it seems this section describes parser behaviours, how about `SQL
Query Statements` -> `SQL Parsing`?
----------------------------------------------------------------
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]
