Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-30099

Improve Analyzed Logical Plan as duplicate AnalysisExceptions are coming

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • SQL
    • None

    Description

      Spark SQL
      explain extended select * from any non existing table shows duplicate AnalysisExceptions.

       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>
      

      Attachments

        Issue Links

          Activity

            People

              aman_omer Aman Omer
              jobitmathew jobit mathew
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: