Re: TreeNodeException: Unresolved attributes

2015-03-04 Thread Anusha Shamanur
(appending strings), and hql function is deprecated. You should use sql. http://spark.apache.org/docs/1.1.0/api/scala/index.html#org.apache.spark.sql.hive.HiveContext On Wed, Mar 4, 2015 at 6:15 AM, Anusha Shamanur anushas...@gmail.com wrote: Hi, I am trying to run a simple select query

TreeNodeException: Unresolved attributes

2015-03-03 Thread Anusha Shamanur
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 this?

Re: Spark SQL Thrift Server start exception : java.lang.ClassNotFoundException: org.datanucleus.api.jdo.JDOPersistenceManagerFactory

2015-03-03 Thread Anusha Shamanur
/2015/02/22/getting-hivecontext-to-work-in-cdh/ Or you may also need to download the datanucleus*.jar files try to add the option of “--jars” while starting the spark shell. *From:* Anusha Shamanur [mailto:anushas...@gmail.com] *Sent:* Wednesday, March 4, 2015 5:07 AM *To:* Cheng, Hao

Re: Failed to parse Hive query

2015-02-28 Thread Anusha Shamanur
Hi, I reconfigured everything. Still facing the same issue. Can someone please help? On Friday, February 27, 2015, Anusha Shamanur anushas...@gmail.com wrote: I do. What tags should I change in this? I changed the value of hive.exec.scratchdir to /tmp/hive. What else? On Fri, Feb 27, 2015

Failed to parse Hive query

2015-02-27 Thread Anusha Shamanur
Hi, I am trying to do this in spark-shell: val hiveCtx = neworg.apache.spark.sql.hive.HiveContext(sc) val listTables =hiveCtx.hql(show tables) The second line fails to execute with this message: warning: there were 1 deprecation warning(s); re-run with -deprecation for details

Running hive query from spark

2015-02-27 Thread Anusha Shamanur
Hi, I am trying to do this in spark-shell: val hiveCtx = neworg.apache.spark.sql.hive.HiveContext(sc) val listTables =hiveCtx.hql(show tables) The second line fails to execute with this message: warning: there were 1 deprecation warning(s); re-run with -deprecation for details

Re: Failed to parse Hive query

2015-02-27 Thread Anusha Shamanur
there? On Fri, Feb 27, 2015 at 7:17 AM, Anusha Shamanur anushas...@gmail.com wrote: Hi, I am trying to do this in spark-shell: val hiveCtx = neworg.apache.spark.sql.hive.HiveContext(sc) val listTables =hiveCtx.hql(show tables) The second line fails to execute with this message: warning