gortiz opened a new issue, #13127: URL: https://github.com/apache/pinot/issues/13127
Like https://github.com/apache/pinot/issues/13126 but for EXCEPT. In Postgres: ``` postgres=# select * from A; 1 1 2 3 4 postgres=# select * from B; 2 postgres=# select * from (select a from A) as a except (select b from B); 3 4 1 postgres=# select * from (select a from A) as a except all (select b from B); 3 4 1 1 ``` But in Pinot we just ignore the `all` modifier. This can be tested in `ColocatedJoinEngineQuickStart`, where ```sql select count(userUUID) from userGroups where userUUID = 'user-5' ``` returns `2` but ``` select userUUID from (select userUUID from userGroups) except all (select userUUID from userAttributes where userUUID <> 'user-5') ``` returns only 1 row. -- 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: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
