[SPARK-39492] Rework MISSING_COLUMN error class

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.1
• Fix Version/s: 3.4.0
• Component/s: Spark Core
• Assignee: Serge Rielau
• Reporter: Serge Rielau
• Shepherd: Wenchen Fan
• Created: 16/Jun/22 17:07
• Updated: 14/Jul/22 22:15
• Resolved: 18/Jun/22 05:39

Description

"MISSING_COLUMN" : {
"message" : [
"Column '<columnName>' does not exist. Did you mean one of the following? [<proposal>]"
],
"sqlState" : "42000"

Is unfortunately named. It is more accurate to talk about an UNRESOLVED_COLUMN or an UNRESOLVED_COLUMN_IDENTIFIER since we could refer to an alias, a SQL UDF parameter, a field, or, in the future, a variable. 

Issue Links

• is related to: SPARK-39783 Column backticks are misplaced in the AnalysisException [UNRESOLVED_COLUMN] error message when using field with "."
• links to: [Github] Pull Request #36891 (srielau)
• links to: [Github] Pull Request #36891 (srielau)