[SPARK-39374] Improve error message for user specified column list

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.4.0
• Fix Version/s: 3.4.0
• Component/s: SQL
• Assignee: Yuming Wang
• Reporter: Yuming Wang
• Created: 03/Jun/22 11:31
• Updated: 05/Jun/22 08:27
• Resolved: 05/Jun/22 08:27

Description

scala> spark.sql("create table t1(id int, name string) using parquet")
res0: org.apache.spark.sql.DataFrame = []

scala> spark.sql("insert into t1(id, nn) values(1, 'name')")
org.apache.spark.sql.AnalysisException: Cannot resolve column name nn; line 1 pos 0
  at org.apache.spark.sql.errors.QueryCompilationErrors$.cannotResolveUserSpecifiedColumnsError(QueryCompilationErrors.scala:406)
  at org.apache.spark.sql.catalyst.analysis.Analyzer$ResolveUserSpecifiedColumns$.$anonfun$resolveUserSpecifiedColumns$2(Analyzer.scala:3406)
  at scala.Option.getOrElse(Option.scala:189)

Issue Links

• links to: [Github] Pull Request #36760 (wangyum)