xudong963 commented on issue #1082: URL: https://github.com/apache/arrow-datafusion/issues/1082#issuecomment-941940893
First of all, I'll implement `INTERSECT` My direct idea is to rewrite it to `left-semi Join` such as ```sql SELECT a1 FROM t1 INTERSECT SELECT a2 FROM t2; to SELECT DISTINCT a1 FROM t1 LEFT SEMI JOIN t2 ON a1 is distinct from a2 ``` How do you think about it? @houqp @alamb @Dandandan If it's ok, I think I should implement `is distinct from` firstly. https://www.postgresql.org/docs/14/functions-comparison.html -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
