Support for sub queries in predicates hasn't been resolved yet - please
refer to SPARK-4226
BTW, Spark 1.3 default bindings to Hive 0.13.1
On Fri, Apr 17, 2015 at 09:18 ARose wrote:
> So I'm trying to store the results of a query into a DataFrame, but I get
> the
> following exception thrown:
>
> Exception in thread "main" java.lang.RuntimeException: [1.71] failure:
> ``*''
> expected but `select' found
>
> SELECT DISTINCT OutSwitchID FROM wtbECRTemp WHERE OutSwtichID NOT IN
> (SELECT
> SwitchID FROM tmpCDRSwitchIDs)
>
> And it has a ^ pointing to the second SELECT. But according to this
> (
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SubQueries
> ),
> subqueries should be supported with Hive 0.13.0.
>
> So which version is Spark using? And if subqueries are not currently
> supported, what would be a suitable alternative to this?
>
>
>
> --
> View this message in context:
> http://apache-spark-user-list.1001560.n3.nabble.com/Which-version-of-Hive-QL-is-Spark-1-3-0-using-tp22542.html
> Sent from the Apache Spark User List mailing list archive at Nabble.com.
>
> -
> To unsubscribe, e-mail: user-unsubscr...@spark.apache.org
> For additional commands, e-mail: user-h...@spark.apache.org
>
>
