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

Stack Overflow | S. Felsheim | 1 year ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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

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

    Stack Overflow | 1 year 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);
  5. 0

    Adding StringType column to existing Spark DataFrame and then applying default values

    Stack Overflow | 5 months ago | smeeb
    org.apache.spark.sql.AnalysisException: Cannot resolve column name "col" among (x, y);

  1. tyson925 2 times, last 7 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