org.apache.spark.sql.AnalysisException: **Cannot resolve column name "addrid" among (addrid, city, state, zip);**

  1. 0

    Simple join of two Spark DataFrame failing with "org.apache.spark.sql.AnalysisException: Cannot resolve column name"

    Stack Overflow | 1 year ago | S. Felsheim
    org.apache.spark.sql.AnalysisException: **Cannot resolve column name "addrid" among (addrid, city, state, zip);**
  2. 0

    UTF-8 BOM not properly handled

    GitHub | 1 year ago | sfelsheim
    org.apache.spark.sql.AnalysisException: Cannot resolve column name "addrId" among (´╗┐addrId, city, state, zip);
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Why does dropna() not work?

    Stack Overflow | 2 years ago | Jason
    org.apache.spark.sql.AnalysisException: Cannot resolve column name "dropna" among (Name, Age, Country, Score);
  5. 0

    SparkR: "Cannot resolve column name..." when adding a new column to Spark data frame

    Stack Overflow | 11 months ago | AltShift
    org.apache.spark.sql.AnalysisException: Cannot resolve column name "Ready.minus.In.mins" among (ASAP, AddressLine, BasketCount, CustomerEmail, CustomerID, CustomerName, CustomerPhone, DPOSCustomerID, DPOSOrderID, ImportedFromOldDb, InTime, IsOnlineOrder, LineItemTotal, NetTenderedAmount, OrderDate, OrderID, OutTime, Postcode, ReadyTime, SnapshotID, StoreID, Suburb, TakenBy, TenderType, TenderedAmount, TransactionStatus, TransactionType, hasLineItems, Ready.minus.In.mins);

  1. tyson925 2 times, last 4 months ago
2 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.apache.spark.sql.AnalysisException

    **Cannot resolve column name "addrid" among (addrid, city, state, zip);**

    at org.apache.spark.sql.DataFrame$$anonfun$resolve$1.apply()
  2. Spark Project SQL
    DataFrame$$anonfun$resolve$1.apply
    1. org.apache.spark.sql.DataFrame$$anonfun$resolve$1.apply(DataFrame.scala:159)
    2. org.apache.spark.sql.DataFrame$$anonfun$resolve$1.apply(DataFrame.scala:159)
    2 frames
  3. Scala
    Option.getOrElse
    1. scala.Option.getOrElse(Option.scala:121)
    1 frame
  4. Spark Project SQL
    DataFrame.col
    1. org.apache.spark.sql.DataFrame.resolve(DataFrame.scala:158)
    2. org.apache.spark.sql.DataFrame.col(DataFrame.scala:558)
    2 frames
  5. dw.dataflow
    DataflowParser.main
    1. dw.dataflow.DataflowParser.testStrangeness(DataflowParser.java:36)
    2. dw.dataflow.DataflowParser.main(DataflowParser.java:119)
    2 frames