belugabehr commented on pull request #2323: URL: https://github.com/apache/hive/pull/2323#issuecomment-849788882
``` sqlite> create table a (id int, value int); sqlite> create table b (id int, a_id, value int); sqlite> insert into a values (1,1); sqlite> insert into a values (2,2); sqlite> insert into b values (1,1,3); sqlite> select * from a where exists (select * from b where a.id=1) and a.id=1; ``` I think this is what you are attempting. I'm not sure what DN will do with this or what the underlying DB will do but please investigate. -- 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. For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
