[
https://issues.apache.org/jira/browse/SPARK-49768?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated SPARK-49768:
-----------------------------------
Labels: pull-request-available (was: )
> Provide error Conditions for make_date/make_timestamp errors
> _LEGACY_ERROR_TEMP_2000
> ------------------------------------------------------------------------------------
>
> Key: SPARK-49768
> URL: https://issues.apache.org/jira/browse/SPARK-49768
> Project: Spark
> Issue Type: Improvement
> Components: Spark Core
> Affects Versions: 4.0.0
> Reporter: Serge Rielau
> Priority: Major
> Labels: pull-request-available
>
> invoking make_date() or make_timestamp() with out of domain arguments result
> in error messages which have not been converted to the new error format.
> All of these errors are related to ANSI mode, so we should fix them to
> facilitate the move to ANSI mode
> Example:
> {noformat}
> SET spark.sql.ansi.enabled = true;
> SELECT make_date(2024, 13, 1);
> Invalid value for MonthOfYear (valid values 1 - 12): 13. If necessary set
> "spark.sql.ansi.enabled" to false to bypass this error.
> org.apache.spark.SparkDateTimeException: Invalid value for MonthOfYear (valid
> values 1 - 12): 13. If necessary set "spark.sql.ansi.enabled" to false to
> bypass this error.
> at
> org.apache.spark.sql.errors.QueryExecutionErrors$.ansiDateTimeError(QueryExecutionErrors.scala:287)
> at
> org.apache.spark.sql.catalyst.expressions.MakeDate.nullSafeEval(datetimeExpressions.scala:2483)
> {noformat}
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
