Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-27901 Improve the error messages of SQL parser
  3. SPARK-27904

Improve parser error message for SHOW VIEW statement

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.1.0
    • None
    • SQL
    • None

    Description

      SHOW VIEW statement is actually not supported in Spark SQL. However, when a user quries such a statement, the error message is confusing. For example, the error message for

      SHOW VIEWS IN my_database
      

      is

      missing 'FUNCTIONS' at 'IN'(line 1, pos 11)
      

      which is misleading.
       

      One possible way to fix is to explicitly capture these statements in a grammar rule and print user-friendly error message such as

      SHOW VIEW statements are not supported.
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            manifoldQAQ Yesheng Ma
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: