[SPARK-36943] Improve error message for missing column

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: Spark Core, SQL
• Assignee: Karen Feng
• Reporter: Karen Feng
• Created: 07/Oct/21 00:17
• Updated: 11/Oct/21 04:48
• Resolved: 11/Oct/21 04:48

Description

Improve the error message for the case that a user asks for a column that does not exist.
Today, the message is "cannot resolve 'foo' given input columns [bar, baz, froo]".
We should sort the suggestion list by similarity and improve the grammar to remove lingo like "resolve."

Issue Links

• links to: [Github] Pull Request #34202 (karenfeng)
• links to: [Github] Pull Request #34202 (karenfeng)