[
https://issues.apache.org/jira/browse/SPARK-14195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15214167#comment-15214167
]
Herman van Hovell commented on SPARK-14195:
-------------------------------------------
Uncorrelated subqueries are not supported in Spark 1.*. They have been added in
2.*. Could you try this with the latest master?
> Error: org.apache.spark.sql.AnalysisException: cannot recognize input near
> 'select' 'MAC' 'from' in expression specification; line 1 pos 16
> (state=,code=0)
> -----------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: SPARK-14195
> URL: https://issues.apache.org/jira/browse/SPARK-14195
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.5.1
> Environment: SUSE 11
> Reporter: Chetan Bhat
> Priority: Minor
> Original Estimate: 0.05h
> Remaining Estimate: 0.05h
>
> In Beeline when the SQL is executed using Spark the following error is
> displayed.
> select a.imei, (select MAC from testolap where imei like '%AA%' 1) MAC from
> testolap a limit 10;
> Error: org.apache.spark.sql.AnalysisException: cannot recognize input near
> 'select' 'MAC' 'from' in expression specification; line 1 pos 16
> (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
