subject:"NOT IN in Spark SQL"

RE: NOT IN in Spark SQL

2015-09-04 Thread Ewan Leith

://spark.apache.org/docs/1.2.0/api/java/org/apache/spark/sql/hive/HiveContext.html Thanks, Ewan From: Akhil Das [mailto:ak...@sigmoidanalytics.com] Sent: 04 September 2015 13:12 To: Pietro Gentile Cc: user@spark.apache.org Subject: Re: NOT IN in Spark SQL I think spark doesn't support NOT IN cl

Re: NOT IN in Spark SQL

2015-09-04 Thread Akhil Das

I think spark doesn't support NOT IN clauses, but you can do the same with a LEFT OUTER JOIN, Something like: SELECT A.id FROM A LEFT OUTER JOIN B ON (B.id = A.id) WHERE B.id IS null Thanks Best Regards On Thu, Sep 3, 2015 at 8:46 PM, Pietro Gentile < pietro.gentile89.develo...@gmail.com> wrote

NOT IN in Spark SQL

2015-09-03 Thread Pietro Gentile

Hi all, How can I do to use the "NOT IN" clause in Spark SQL 1.2 ?? He continues to give me syntax errors. But the question is correct in SQL. Thanks in advance, Best regards, Pietro.