[SPARK-12772] Better error message for syntax error in the SQL parser

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0
• Fix Version/s: 2.0.0
• Component/s: SQL
• Assignee: Herman van Hövell
• Reporter: Reynold Xin
• Created: 12/Jan/16 08:42
• Updated: 02/Apr/16 15:37
• Resolved: 31/Mar/16 16:48

Description

scala> sql("select case if(true, 'one', 'two')").explain(true)
org.apache.spark.sql.AnalysisException: org.antlr.runtime.EarlyExitException
line 1:34 required (...)+ loop did not match anything at input '<EOF>' in case expression
; line 1 pos 34

	at org.apache.spark.sql.catalyst.parser.ParseErrorReporter.throwError(ParseDriver.scala:140)
	at org.apache.spark.sql.catalyst.parser.ParseErrorReporter.throwError(ParseDriver.scala:129)
	at org.apache.spark.sql.catalyst.parser.ParseDriver$.parse(ParseDriver.scala:77)
	at org.apache.spark.sql.catalyst.CatalystQl.createPlan(CatalystQl.scala:53)
	at org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:41)
	at org.apache.spark.sql.hive.ExtendedHiveQlParser$$anonfun$hiveQl$1.apply(ExtendedHiveQlParser.scala:40)

Is there a way to say something better other than "required (...)+ loop did not match anything at input"?