[SPARK-27901] Improve the error messages of SQL parser

• Type: Umbrella
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Xiao Li
• Created: 31/May/19 17:02
• Updated: 31/May/19 17:03

Description

SQL is one the most popular APIs for Apache Spark. Our SQL parser is built on ANTLR4. The error messages generated by ANTLR4 is not always helpful. This umbrella Jira is to track all the improvements in our parser error handling. 

Sub-Tasks

• Improve SQL parser error message when missing backquotes for identifiers with hyphens: Resolved
• Make optional clauses order insensitive for CREATE DATABASE/VIEW SQL statement: Resolved
• Misleading error message for typo in SQL: Resolved
• Issue a better error message for `CREATE TEMPORARY FUNCTION IF NOT EXISTS`: Resolved
• Improve error message for DESCRIBE statement: Open
• Improve parser error message for mismatched parentheses in expressions: Open
• Improve the error message for unsupported Uniontype: Reopened
• Improve parser error message for SHOW VIEW statement: Open
• Improve parser error message for CREATE LOCAL TEMPORARY TABLE statement: Open
• Improve parser error message for SELECT TOP statement: Open
• Query with colon in the table name fails to parse in 2.0: Closed
• Improve parser error message for misused numeric identifiers: Open
• Improve parser error message for CASE clause: Open