[jira] [Created] (SPARK-27904) Improve parser error message for SHOW VIEW statement

["Yesheng Ma (JIRA)" <ji...@apache.org>]

Yesheng Ma created SPARK-27904:
----------------------------------

             Summary: Improve parser error message for SHOW VIEW statement
                 Key: SPARK-27904
                 URL: https://issues.apache.org/jira/browse/SPARK-27904
             Project: Spark
          Issue Type: Sub-task
          Components: SQL
    Affects Versions: 3.0.0
            Reporter: Yesheng Ma


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


{code:sql}
SHOW VIEWS IN my_database
{code}

is
{code:java}
missing 'FUNCTIONS' at 'IN'(line 1, pos 11)
{code}
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
{code:java}
SHOW VIEW statements are not supported.
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

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