spark-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sean Owen (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SPARK-21853) Getting an exception while calling the except method on the dataframe
Date Tue, 29 Aug 2017 10:06:00 GMT

     [ https://issues.apache.org/jira/browse/SPARK-21853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sean Owen resolved SPARK-21853.
-------------------------------
    Resolution: Invalid

Questions about help with your code belong on SO or the mailing list. This doesn't seem to
be a Spark issue, but a problem with your query.

> Getting an exception while calling the except method on the dataframe
> ---------------------------------------------------------------------
>
>                 Key: SPARK-21853
>                 URL: https://issues.apache.org/jira/browse/SPARK-21853
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Shell
>    Affects Versions: 2.1.1
>            Reporter: Shailesh Kini
>         Attachments: SparkException.txt
>
>
> I am getting an exception while calling except on the Dataset.
> org.apache.spark.sql.AnalysisException: resolved attribute(s) SVC_BILLING_PERIOD#37723
missing from
> I read 2 csv files into datasets DS1 and DS2, which I join (full outer) to create DS3.
DS3 has some rows which are similar with the exception of one column. I need to isolate those
rows and remove the similar rows. I use groupBy with the count > 1 on a few columns in
DS3 to get those similar rows - dataset DS4. DS4 has only a few columns and not all so I join
it back with DS3 on the aggregate columns to get a new dataset DS5 which has the same columns
as DS3. To get a clean dataset without any of those similar rows, I am calling DS3.except(DS5)
which throws the exception. The attribute is one of the filtering criteria I use which creating
DS1.
> Attaching the exception to this ticket.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org


Mime
View raw message