org.apache.spark.sql.AnalysisException

cannot resolve 'd' given input columns _c0; line 1 pos 7


Solutions on the web165

Solution icon of web
cannot resolve 'd' given input columns _c0; line 1 pos 7

Solution icon of stackoverflow
cannot resolve '`date`' given input columns: []; line 1 pos 0

Solution icon of web
cannot resolve '_aggOrdering' given input columns _c0, _aggOrdering, _aggOrdering;

Solution icon of apache
via Apache's JIRA Issue Tracker by Zhichao Zhang, 1 year ago
cannot resolve 'testData2.b' given input columns key, value; line 1 pos 108

Solution icon of apache
via Apache's JIRA Issue Tracker by Zhichao Zhang, 1 year ago
cannot resolve 'testData2.b' given input columns key, value; line 1 pos 108

Solution icon of github
via GitHub by samurainate
, 7 months ago
cannot resolve '\`rectype.x\`' given input columns: [..., rectype.x, ..., rectype.y, ...]; line 1 pos 0

Solution icon of github
via GitHub by bhlx3lyx7
, 1 month ago
cannot resolve 'start' given input columns: [first_name, phone, email, post_code, user_id, last_name, address]; line 1 pos 46

Solution icon of stackoverflow
cannot resolve '`sepalWidth`' given input columns: [_c1, _c3, _c0, _c4, _c2];

Solution icon of github
cannot resolve 'start' given input columns: [first_name, phone, email, post_code, user_id, last_name, address]; line 1 pos 46

Solution icon of github
cannot resolve '`Sepal_Width.x`' given input columns: [Petal_Length.y, Species.y, Sepal_Length, Petal_Width.x, Petal_Length.x, Sepal_Width.x, Sepal_Width.y, Petal_Width.y, Species.x]; line 1 pos 0

Stack trace

  • org.apache.spark.sql.AnalysisException: cannot resolve 'd' given input columns _c0; line 1 pos 7 at org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42) at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$apply$3$$anonfun$apply$1.applyOrElse(CheckAnalysis.scala:48) at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$apply$3$$anonfun$apply$1.applyOrElse(CheckAnalysis.scala:45) at org.apache.spark.sql.catalyst.trees.TreeNode$$anonfun$transformUp$1.apply(TreeNode.scala:250) at org.apache.spark.sql.catalyst.trees.TreeNode$$anonfun$transformUp$1.apply(TreeNode.scala:250) at org.apache.spark.sql.catalyst.trees.CurrentOrigin$.withOrigin(TreeNode.scala:50) at org.apache.spark.sql.catalyst.trees.TreeNode.transformUp(TreeNode.scala:249) at org.apache.spark.sql.catalyst.plans.QueryPlan.org$apache$spark$sql$catalyst$plans$QueryPlan$$transformExpressionUp$1(QueryPlan.scala:103) at org.apache.spark.sql.catalyst.plans.QueryPlan$$anonfun$2$$anonfun$apply$2.apply(QueryPlan.scala:117) at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) at scala.collection.TraversableLike$$anonfun$map$1.apply(TraversableLike.scala:244) at scala.collection.mutable.ResizableArray$class.foreach(ResizableArray.scala:59) at scala.collection.mutable.ArrayBuffer.foreach(ArrayBuffer.scala:47) at scala.collection.TraversableLike$class.map(TraversableLike.scala:244) at scala.collection.AbstractTraversable.map(Traversable.scala:105) at org.apache.spark.sql.catalyst.plans.QueryPlan$$anonfun$2.apply(QueryPlan.scala:116) at scala.collection.Iterator$$anon$11.next(Iterator.scala:328)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 1 month ago
4 times, 2 months ago
Once, 4 months ago
Samebug visitor profile picture
Unknown user
Once, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 11 months ago
7 more bugmates