[
https://issues.apache.org/jira/browse/SPARK-39233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17539452#comment-17539452
]
Apache Spark commented on SPARK-39233:
--------------------------------------
User 'gengliangwang' has created a pull request for this issue:
https://github.com/apache/spark/pull/36609
> Remove the check for TimestampNTZ output in Analyzer
> ----------------------------------------------------
>
> Key: SPARK-39233
> URL: https://issues.apache.org/jira/browse/SPARK-39233
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.3.0
> Reporter: Gengliang Wang
> Assignee: Gengliang Wang
> Priority: Major
>
> In [#36094|https://github.com/apache/spark/pull/36094], a check for failing
> TimestampNTZ output is added.
> However, the check can cause misleading error message.
> In 3.3:
>
> {code:java}
> > sql( "select date '2018-11-17' > 1").show()
> org.apache.spark.sql.AnalysisException: Invalid call to toAttribute on
> unresolved object;
> 'Project [unresolvedalias((2018-11-17 > 1), None)]
> +- OneRowRelation
>
> at
> org.apache.spark.sql.catalyst.analysis.UnresolvedAlias.toAttribute(unresolved.scala:510)
> at
> org.apache.spark.sql.catalyst.plans.logical.Project.$anonfun$output$1(basicLogicalOperators.scala:70)
> {code}
> In master or 3.2
> {code:java}
> > sql( "select date '2018-11-17' > 1").show()
> org.apache.spark.sql.AnalysisException: cannot resolve '(DATE '2018-11-17' >
> 1)' due to data type mismatch: differing types in '(DATE '2018-11-17' > 1)'
> (date and int).; line 1 pos 7;
> 'Project [unresolvedalias((2018-11-17 > 1), None)]
> +- OneRowRelation
> at
> org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42)
> {code}
> We should just remove the check
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
