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]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web146

  • 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
  • resolved attribute(s) SOG#3 missing from time#1 in operator !Project [time#1,SOG#3 AS SOG#34];
  • resolved attribute(s) month#2 missing from c1#0,c2#1 in operator !Project [c1#0,c2#1,month#2 AS month#7];
  • Stack trace

    • 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.catalyst.analysis.Analyzer.checkAnalysis(Analyzer.scala:57) 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) at org.apache.spark.sql.Dataset.withColumn(Dataset.scala:1866)

    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

    Unknown user
    Once, 1 month ago
    4 times, 1 month ago
    Once, 8 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    3 more bugmates