[ 
https://issues.apache.org/jira/browse/SPARK-30099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

jobit mathew updated SPARK-30099:
---------------------------------
    Description: 
Spark SQL 
 explain extended select * from any non existing table shows duplicate 
AnalysisExceptions.
{code:java}
 spark-sql>explain extended select * from wrong

== Parsed Logical Plan ==
 'Project [*]
 +- 'UnresolvedRelation `wrong`

== Analyzed Logical Plan ==
 org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 
p
 os 31
 org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 
p
 os 31
 == Optimized Logical Plan ==
 org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 
p
 os 31
 == Physical Plan ==
 org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 
p
 os 31
 Time taken: 6.0 seconds, Fetched 1 row(s)
 19/12/02 14:33:32 INFO SparkSQLCLIDriver: Time taken: 6.0 seconds, Fetched 1 
row
 (s)
 spark-sql>
{code}

  was:
Spark SQL 
explain extended select * from  any non existing table  shows 
explain extended select * from wrong

== Parsed Logical Plan ==
'Project [*]
+- 'UnresolvedRelation `wrong`

== Analyzed Logical Plan ==
org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 p
os 31
org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 p
os 31
== Optimized Logical Plan ==
org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 p
os 31
== Physical Plan ==
org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 1 p
os 31
Time taken: 6.0 seconds, Fetched 1 row(s)
19/12/02 14:33:32 INFO SparkSQLCLIDriver: Time taken: 6.0 seconds, Fetched 1 row
(s)
spark-sql>



> Improve Analyzed Logical Plan as duplicate AnalysisExceptions are coming
> ------------------------------------------------------------------------
>
>                 Key: SPARK-30099
>                 URL: https://issues.apache.org/jira/browse/SPARK-30099
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 3.0.0
>            Reporter: jobit mathew
>            Priority: Minor
>
> Spark SQL 
>  explain extended select * from any non existing table shows duplicate 
> AnalysisExceptions.
> {code:java}
>  spark-sql>explain extended select * from wrong
> == Parsed Logical Plan ==
>  'Project [*]
>  +- 'UnresolvedRelation `wrong`
> == Analyzed Logical Plan ==
>  org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 
> 1 p
>  os 31
>  org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 
> 1 p
>  os 31
>  == Optimized Logical Plan ==
>  org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 
> 1 p
>  os 31
>  == Physical Plan ==
>  org.apache.spark.sql.AnalysisException: Table or view not found: wrong; line 
> 1 p
>  os 31
>  Time taken: 6.0 seconds, Fetched 1 row(s)
>  19/12/02 14:33:32 INFO SparkSQLCLIDriver: Time taken: 6.0 seconds, Fetched 1 
> row
>  (s)
>  spark-sql>
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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

Reply via email to