$TreeNodeException: Unresolved
attributes: *, tree:
'Project [*]
'Filter ('value LIKE Restaurant)
MetastoreRelation default, TableName, None
On Wed, Mar 4, 2015 at 5:39 AM, Arush Kharbanda ar...@sigmoidanalytics.com
wrote:
Why don't you formulate a string before you pass it to the hql function
==
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: *, tree:
'Project [*]
'Filter ('value LIKE Restaurant)
MetastoreRelation default, TableName, None
On Wed, Mar 4, 2015 at 5:39 AM, Arush Kharbanda
ar...@sigmoidanalytics.commailto:ar...@sigmoidanalytics.com wrote:
Why
...@gmail.com
wrote:
Hi,
I am trying to run a simple select query on a table.
val restaurants=hiveCtx.hql(select * from TableName where column like
'%SomeString%' )
This gives an error as below:
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes
:
Below is the code that I am running. I get an error for unresolved
attributes. Can anyone point me in the right direction? Running from
pyspark shell using yarn MASTER=yarn-client pyspark
Error is below code:
# Import SQLContext and data types
from pyspark.sql import *
# sc
in this
format.
Michael
On Mon, Jan 5, 2015 at 1:01 PM, Sam Flint sam.fl...@magnetic.com wrote:
Below is the code that I am running. I get an error for unresolved
attributes. Can anyone point me in the right direction? Running from
pyspark shell using yarn MASTER=yarn-client pyspark
Error
Hi,
I am trying to run a simple select query on a table.
val restaurants=hiveCtx.hql(select * from TableName where column like
'%SomeString%' )
This gives an error as below:
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: *, tree:
How do I solve
Below is the code that I am running. I get an error for unresolved
attributes. Can anyone point me in the right direction? Running from
pyspark shell using yarn MASTER=yarn-client pyspark
Error is below code:
# Import SQLContext and data types
from pyspark.sql import *
# sc is an existing
: Unresolved
attributes: *, tree:
Project [*]
Filter (((customer_id#144 = 6) (CAST(cat_id#148, DoubleType) =
CAST(205, DoubleType))) (period_desc#150 =
'Year_2011_Month_0_Week_0_Site))
Subquery seasonality
SparkLogicalPlan (ExistingRdd
[customer_id#144,period_id#145,season_id#146,cat_lvl#147
= Year_2011_Month_0_Week_0_Site
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: *, tree:
Project [*]
Filter (((customer_id#144 = 6) (CAST(cat_id#148, DoubleType) =
CAST(205, DoubleType))) (period_desc#150 =
'Year_2011_Month_0_Week_0_Site))
Subquery seasonality
$TreeNodeException: Unresolved
attributes: 'name, tree:
Project ['name]
Filter (business_id#1 = 'Ba1hXOqb3Yhix8bhE0k_WQ)
Subquery business
SparkLogicalPlan (ExistingRdd
[attributes#0,business_id#1,categories#2,city#3,full_address#4,hours#5,latitude#6,longitude#7,name#8,neighborhoods#9,open#10
main
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: 'name, tree:
Project ['name]
Filter (business_id#1 = 'Ba1hXOqb3Yhix8bhE0k_WQ)
Subquery business
SparkLogicalPlan (ExistingRdd
[attributes#0,business_id#1,categories#2,city#3,full_address#4,hours#5
at 12:22 PM
To: Michael Armbrust mich...@databricks.commailto:mich...@databricks.com
Cc: user@spark.apache.orgmailto:user@spark.apache.org
user@spark.apache.orgmailto:user@spark.apache.org
Subject: Re: SparkSQL - TreeNodeException for unresolved attributes
Hi Michael,
Thanks again for the reply
Hi all,
I’m getting a TreeNodeException for unresolved attributes when I do a simple
select from a schemaRDD generated by a join in Spark 1.1.0. A little background
first. I am using a HiveContext (against Hive 0.12) to grab two tables, join
them, and then perform multiple INSERT-SELECT
Have you tried this on master? There were several problems with resolution
of complex queries that were registered as tables in the 1.1.0 release.
On Mon, Oct 20, 2014 at 10:33 AM, Terry Siu terry@smartfocus.com
wrote:
Hi all,
I’m getting a TreeNodeException for unresolved attributes
@smartfocus.commailto:terry@smartfocus.com
Cc: user@spark.apache.orgmailto:user@spark.apache.org
user@spark.apache.orgmailto:user@spark.apache.org
Subject: Re: SparkSQL - TreeNodeException for unresolved attributes
Have you tried this on master? There were several problems with resolution of
complex queries
-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15376.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
$TreeNodeException: Unresolved
attributes: 'element.name, tree:
Project ['name]
Filter ('age = 13)
Subquery people
My question is how to access name, age from root node to query the same.
Thanks in advance.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Unresolved
is as follows.
{data: [{name:Michael}, {name:Andy, age:30}, {name:Justin,
age:19}]}
when I'm querying select name from people where age=13; I'm getting the
following exception.
org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved
attributes: 'element.name, tree:
Project ['name
].name FROM people where data[0].age =13*
Am I missing something? I'm trying to understand how the RDD is stored.
Thanks in advance.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15350.html
Sent from
.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15350.html
Sent from the Apache Spark User List mailing list archive at Nabble.com
-spark-user-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15350.html
Sent from the Apache Spark User List mailing list archive at Nabble.com.
-
To unsubscribe, e-mail: user-unsubscr
FROM people where data[0].age =13*
Am I missing something? I'm trying to understand how the RDD is stored.
Thanks in advance.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15350.html
Sent
I'm using the latest version i.e. Spark 1.1.0
Thanks.
--
View this message in context:
http://apache-spark-user-list.1001560.n3.nabble.com/Unresolved-attributes-SparkSQL-on-the-schemaRDD-tp15339p15376.html
Sent from the Apache Spark User List mailing list archive at Nabble.com
23 matches
Mail list logo