[ 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