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