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 <itishagupta.2...@gmail.com> 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