Re: Is there "EXCEPT ALL" in Spark SQL?

emi Cc: user@spark.apache.org Subject: Re: Is there "EXCEPT ALL" in Spark SQL? There is Except in DataFrame API. df1.except(df2) Same can be used in SQL as well. public DataFrame<https://spark.apache.org/docs/1.6.1/api/java/org/apache/spark/sql/DataFrame.html>

Re: Is there "EXCEPT ALL" in Spark SQL?

There is Except in DataFrame API. df1.except(df2) Same can be used in SQL as well. public DataFrame except(DataFrame other)

Re: Is there "EXCEPT ALL" in Spark SQL?

To add to it, is there any specific documentation or reference where we could check out what SQL functions and features are available in spark spl for a specific sparksql version.? Thanks,Upendra On Thu, Jul 6, 2017 at 2:22 PM, jeff saremi wrote: I tried this

Is there "EXCEPT ALL" in Spark SQL?

I tried this query in 1.6 and it failed: SELECT * FROM Table1 EXCEPT ALL SELECT * FROM Table2 Exception in thread "main" java.lang.RuntimeException: [1.32] failure: ``('' expected but `all' found thanks Jeff