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 <ashley.r...@telarix.com> 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 > >