Maxim Gekk created SPARK-29090:
----------------------------------
Summary: Invalid patterns of seconds fractions in functions
comments
Key: SPARK-29090
URL: https://issues.apache.org/jira/browse/SPARK-29090
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.0.0
Reporter: Maxim Gekk
The comment for the date_sub() functions points out the `yyyy-MM-dd
HH:mm:ss.SSSS` pattern as valid one:
[https://github.com/apache/spark/blob/aafce7ebffe1acd8f6022f208beaa9ec6c9f7592/sql/core/src/main/scala/org/apache/spark/sql/functions.scala#L2678]
but the function does not accept 4 digits in the second fraction:
{code}
scala> spark.sql("""select date_sub("2019-09-15 14:35.00.1234")""").show
org.apache.spark.sql.AnalysisException: Invalid number of arguments for
function date_sub. Expected: 2; Found: 1; line 1 pos 7
{code}
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
