Hello!
This looks like a query where the result is only correct if the data in
orders and accounts are collocated.
If they are not, you may check it by setting distributedJoins=true
connection property and re-running the query.
Please see
Hi,
We are using ignite 2.8.1, with this sql statement, SELECT * FROM orders p
WHERE NOT exists (SELECT accountid FROM account b WHERE b.accountid =
p.accountid);
Retured result accountid actually exists in table account, change to NOT IN
also is not correct. But I have another table result is