Paul is right, Drill does not support Except syntax. In this Jira in comments you can find ways how to rewrite the query to achieve the same result: https://issues.apache.org/jira/browse/DRILL-4232 <https://issues.apache.org/jira/browse/DRILL-4232>
Kind regards, Arina > On Jan 16, 2020, at 1:09 AM, Paul Rogers <[email protected]> wrote: > > Hi Itisha, > > Welcome to the Drill user mail list! > > For those readers (like me) who are not familiar with the keyword, EXCEPT > works like UNION to join to SELECT statements: SELECT ... EXCEPT SELECT ... > See [1]. Seems pretty useful. > > A quick check of our parser source code suggests that Drill does not support > the EXCEPT syntax. Drill does not even treat EXCEPT as a keyword. > > Please file a JIRA ticket to request this feature. > > Thanks, > - Paul > > > [1] https://www.tutorialspoint.com/sql/sql-except-clause.htm > > > > On Wednesday, January 15, 2020, 12:50:36 AM PST, itisha Gupta > <[email protected]> wrote: > > Hey team, > > I am trying to use EXCEPT operator of Apache drill but it's not working. > Does Apache drill supports EXCEPT? > > Regards, > Itisha
