Re: Spark SQL 1.3 not finding attribute in DF

2015-12-07 Thread Davies Liu
Could you reproduce this problem in 1.5 or 1.6? On Sun, Dec 6, 2015 at 12:29 AM, YaoPau wrote: > If anyone runs into the same issue, I found a workaround: > df.where('state_code = "NY"') > > works for me. > df.where(df.state_code == "NY").collect() > > fails with

Re: Spark SQL 1.3 not finding attribute in DF

2015-12-07 Thread Jon Gregg
I'm working with a Hadoop distribution that doesn't support 1.5 yet, we'll be able to upgrade in probably two months. For now I'm seeing the same issue with spark not recognizing an existing column name in many hive-table-to-dataframe situations: Py4JJavaError: An error occurred while calling

Spark SQL 1.3 not finding attribute in DF

2015-12-06 Thread YaoPau
When I run df.printSchema() I get: root |-- durable_key: string (nullable = true) |-- code: string (nullable = true) |-- desc: string (nullable = true) |-- city: string (nullable = true) |-- state_code: string (nullable = true) |-- zip_code: string (nullable = true) |-- county: string

Re: Spark SQL 1.3 not finding attribute in DF

2015-12-06 Thread YaoPau
If anyone runs into the same issue, I found a workaround: >>> df.where('state_code = "NY"') works for me. >>> df.where(df.state_code == "NY").collect() fails with the error from the first post. -- View this message in context: