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: > 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. >
