[SPARK-27906] Improve parser error message for CREATE LOCAL TEMPORARY TABLE statement

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yesheng Ma
• Created: 31/May/19 18:03
• Updated: 29/Mar/20 02:32

Description

The CREATE LOCAL TEMPORARY TABLE statement is actually not supported in Spark SQL. However, when a user queries such a statement, the error message is confusing. For example, the error message for

CREATE LOCAL TEMPORARY TABLE my_table (x INT);

is

no viable alternative at input 'CREATE LOCAL'(line 1, pos 7)

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

CREATE LOCAL TEMPORARY TABLE statements are not supported.