org.apache.spark.sql.AnalysisException: resolved attribute(s) OIL_PRODUCTION_AVG#827,CUT_OFF#822 missing from TIME#63,OIL_PRODUCTION#43 in operator !Project [TIME#63, OIL_PRODUCTION#43, CASE WHEN (abs((OIL_PRODUCTION#43 - OIL_PRODUCTION_AVG#827)) < CUT_OFF#822) THEN 1 ELSE 0 END AS Label#833];; !Project [TIME#63, OIL_PRODUCTION#43, CASE WHEN (abs((OIL_PRODUCTION#43 - OIL_PRODUCTION_AVG#827)) < CUT_OFF#822) THEN 1 ELSE 0 END AS Label#833] +- Project [TIME#63, OIL_PRODUCTION#43]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Darshita
, 9 months ago
resolved attribute(s) OIL_PRODUCTION_AVG#827,CUT_OFF#822 missing from TIME#63,OIL_PRODUCTION#43 in operator !Project [TIME#63, OIL_PRODUCTION#43, CASE WHEN (abs((OIL_PRODUCTION#43 - OIL_PRODUCTION_AVG#827)) < CUT_OFF#822) THEN 1 ELSE 0 END AS Label
via Stack Overflow by simtim
, 3 months ago
resolved attribute(s) t-values#119 missing from coefficients#113 in operator !Project [coefficients#113, t-values#119 AS t-values#130];; !Project [coefficients#113, t-values#119 AS t-values#130] +- Project [value#111 AS coefficients#113] +- LocalRelation [value#111]
via Stack Overflow by kentt
, 2 years ago
resolved attribute(s) SOG#3 missing from time#1 in operator !Project [time#1,SOG#3 AS SOG#34];
via Stack Overflow by nikz
, 9 months ago
resolved attribute(s) month#2 missing from c1#0,c2#1 in operator !Project [c1#0,c2#1,month#2 AS month#7];
via Stack Overflow by Hussain Pirosha
, 1 year ago
unresolved operator 'InsertIntoTable LogicalRDD [MAIL_FROM#0L,MAIL_TO#1L], MapPartitionsRDD[3] at createDataFrame at PhoenixRDD.scala:117, Map(), false, false;
org.apache.spark.sql.AnalysisException: resolved attribute(s) OIL_PRODUCTION_AVG#827,CUT_OFF#822 missing from TIME#63,OIL_PRODUCTION#43 in operator !Project [TIME#63, OIL_PRODUCTION#43, CASE WHEN (abs((OIL_PRODUCTION#43 - OIL_PRODUCTION_AVG#827)) < CUT_OFF#822) THEN 1 ELSE 0 END AS Label#833];; !Project [TIME#63, OIL_PRODUCTION#43, CASE WHEN (abs((OIL_PRODUCTION#43 - OIL_PRODUCTION_AVG#827)) < CUT_OFF#822) THEN 1 ELSE 0 END AS Label#833] +- Project [TIME#63, OIL_PRODUCTION#43]
at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$class.failAnalysis(CheckAnalysis.scala:40)
at org.apache.spark.sql.catalyst.analysis.Analyzer.failAnalysis(Analyzer.scala:57)
at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1.apply(CheckAnalysis.scala:337)
at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$$anonfun$checkAnalysis$1.apply(CheckAnalysis.scala:67)
at org.apache.spark.sql.catalyst.trees.TreeNode.foreachUp(TreeNode.scala:128)
at org.apache.spark.sql.catalyst.analysis.CheckAnalysis$class.checkAnalysis(CheckAnalysis.scala:67)
at org.apache.spark.sql.execution.QueryExecution.assertAnalyzed(QueryExecution.scala:48)
at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:63)
at org.apache.spark.sql.Dataset.org$apache$spark$sql$Dataset$$withPlan(Dataset.scala:2822)
at org.apache.spark.sql.Dataset.select(Dataset.scala:1121)

Users with the same issue

2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 6 months ago
Samebug visitor profile picture
Unknown user
Once, 5 months ago
3 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.