You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2020/08/25 06:48:32 UTC
[GitHub] [spark] maropu commented on a change in pull request #29538: [SPARK-32683][DOCS][SQL] Fix doc error and add migration guide for datetime pattern F
maropu commented on a change in pull request #29538:
URL: https://github.com/apache/spark/pull/29538#discussion_r476214844
##########
File path: docs/sql-migration-guide.md
##########
@@ -189,6 +189,69 @@ license: |
- Since Spark 3.0, when using `EXTRACT` expression to extract the second field from date/timestamp values, the result will be a `DecimalType(8, 6)` value with 2 digits for second part, and 6 digits for the fractional part with microsecond precision. e.g. `extract(second from to_timestamp('2019-09-20 10:10:10.1'))` results `10.100000`. In Spark version 2.4 and earlier, it returns an `IntegerType` value and the result for the former example is `10`.
+ - In Spark 3.0, datetime pattern letter `F` represents the concept of the count of days within the period of a week where the weeks are aligned to the start of the month, e.g.
+ ```sql
+ SELECT d, date_format(d, 'F') AS f
Review comment:
Could we move the example queries into the datetime doc, then add a link here to it? IMHO most users check the doc first, maybe...
----------------------------------------------------------------
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
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org