jonvex commented on issue #5687: URL: https://github.com/apache/hudi/issues/5687#issuecomment-1370096424
I was not able to reproduce the error by running ``` select CAST(-123456789 AS TIMESTAMP) as de; ``` In spark-sql with or without hudi. I was able to confirm that I did have `spark.sql.ansi.enabled = true` set because running ``` SELECT CAST('a' AS INT) as DE; ``` produced an exception that was not produced when `spark.sql.ansi.enabled = false`. Additionally, the exception produced from Hudi started with ``` org.apache.spark.SparkNumberFormatException: The value 'a' of the type "STRING" cannot be cast to "INT" because it is malformed. Correct the value as per the syntax, or change its target type. Use `try_cast` to tolerate malformed input and return NULL instead. If necessary set "spark.sql.ansi.enabled" to "false" to bypass this error. == SQL(line 1, position 8) == SELECT CAST('a' AS INT) as DE ^^^^^^^^^^^^^^^^ ``` which seems to be the spark exception information. -- 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. To unsubscribe, e-mail: commits-unsubscr...@hudi.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org