[SPARK-37802] composite field name like `field name` doesn't work with Aggregate push down

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.2.0, 3.3.0
• Fix Version/s: 3.2.1, 3.3.0
• Component/s: SQL
• Assignee: Huaxin Gao
• Reporter: Huaxin Gao
• Created: 03/Jan/22 06:00
• Updated: 10/Jan/22 08:02
• Resolved: 07/Jan/22 03:37

Description

sql("SELECT SUM(`field name`) FROM h2.test.table")

org.apache.spark.sql.catalyst.parser.ParseException: 
extraneous input 'name' expecting <EOF>(line 1, pos 9)

	at org.apache.spark.sql.catalyst.parser.ParseErrorListener$.syntaxError(ParseDriver.scala:212)
	at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:41)
	at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:544)
	at org.antlr.v4.runtime.DefaultErrorStrategy.reportUnwantedToken(DefaultErrorStrategy.java:377)
	at org.antlr.v4.runtime.DefaultErrorStrategy.singleTokenDeletion(DefaultErrorStrategy.java:548)
	at org.antlr.v4.runtime.DefaultErrorStrategy.recoverInline(DefaultErrorStrategy.java:467)
	at org.antlr.v4.runtime.Parser.match(Parser.java:206)
	at org.apache.spark.sql.catalyst.parser.SqlBaseParser.singleMultipartIdentifier(SqlBaseParser.java:519)

Issue Links

• links to: [Github] Pull Request #35108 (huaxingao)
• links to: [Github] Pull Request #35108 (huaxingao)
• links to: [Github] Pull Request #35125 (huaxingao)