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.2396@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
|