Which spark version did you use? I tried spark-1.2.1 and didn’t meet this
problem.
scala> val m = hiveContext.sql(" select * from testtable where value like
'%Restaurant%'")
15/03/05 02:02:30 INFO ParseDriver: Parsing command: select * from testtable
where value like '%Restaurant%'
15/03/05 02:02:30 INFO ParseDriver: Parse Completed
15/03/05 02:02:30 INFO MemoryStore: ensureFreeSpace(462299) called with
curMem=1087888, maxMem=280248975
15/03/05 02:02:30 INFO MemoryStore: Block broadcast_2 stored as values in
memory (estimated size 451.5 KB, free 265.8 MB)
15/03/05 02:02:30 INFO MemoryStore: ensureFreeSpace(81645) called with
curMem=1550187, maxMem=280248975
15/03/05 02:02:30 INFO MemoryStore: Block broadcast_2_piece0 stored as bytes in
memory (estimated size 79.7 KB, free 265.7 MB)
15/03/05 02:02:30 INFO BlockManagerInfo: Added broadcast_2_piece0 in memory on
c6402.ambari.apache.org<http://c6402.ambari.apache.org>:33696 (size: 79.7 KB,
free: 267.0 MB)
15/03/05 02:02:30 INFO BlockManagerMaster: Updated info of block
broadcast_2_piece0
15/03/05 02:02:30 INFO DefaultExecutionContext: Created broadcast 2 from
broadcast at TableReader.scala:68
m: org.apache.spark.sql.SchemaRDD =
SchemaRDD[3] at RDD at SchemaRDD.scala:108
== Query Plan ==
== Physical Plan ==
Filter Contains(value#5, Restaurant)
HiveTableScan [key#4,value#5], (MetastoreRelation default, testtable, None),
None
scala>
Thanks.
Zhan Zhang
On Mar 4, 2015, at 9:09 AM, Anusha Shamanur
<[email protected]<mailto:[email protected]>> wrote:
I tried. I still get the same error.
15/03/04 09:01:50 INFO parse.ParseDriver: Parsing command: select * from
TableName where value like '%Restaurant%'
15/03/04 09:01:50 INFO parse.ParseDriver: Parse Completed.
15/03/04 09:01:50 INFO metastore.HiveMetaStore: 0: get_table : db=default
tbl=TableName
15/03/04 09:01:50 INFO HiveMetaStore.audit: ugi=as7339 ip=unknown-ip-addr
cmd=get_table : db=default tbl=TableName
results: org.apache.spark.sql.SchemaRDD =
SchemaRDD[86] at RDD at SchemaRDD.scala:108
== Query Plan ==
== Physical Plan ==
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
<[email protected]<mailto:[email protected]>> wrote:
Why don't you formulate a string before you pass it to the hql function
(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
<[email protected]<mailto:[email protected]>> 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: *, tree:
How do I solve this?
--
Regards,
Anusha
--
[Sigmoid Analytics]<http://htmlsig.com/www.sigmoidanalytics.com>
Arush Kharbanda || Technical Teamlead
[email protected]<mailto:[email protected]> ||
www.sigmoidanalytics.com<http://www.sigmoidanalytics.com/>
--
Regards,
Anusha
