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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
