spark-reviews mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
Subject [GitHub] [spark] maropu commented on a change in pull request #27909: [SPARK-31151][SQL][DOC] Reorganize the migration guide of SQL
Date Sat, 14 Mar 2020 06:33:36 GMT
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:
users@infra.apache.org


With regards,
Apache Git Services

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


Mime
View raw message