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<jeffsar...@hotmail.com> wrote: <!--#yiv2531922491 P {margin-top:0;margin-bottom:0;}--> 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