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 https://ignite.apache.org/docs/latest/data-modeling/affinity-collocation Regards, -- Ilya Kasnacheev ср, 18 нояб. 2020 г. в 06:03, [email protected] < [email protected]>: > 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 correct. > > Is there any suggestions? thanks. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
