[jira] [Created] (SPARK-39233) Remove the check for TimestampNTZ output in Analyzer

["Gengliang Wang (Jira)" <ji...@apache.org>]

Gengliang Wang created SPARK-39233:
--------------------------------------

             Summary: 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


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
 
{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

 

  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)



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org