Hi, I don't quite understand your case, but with LEFT JOIN you will have results even if there is no matching id in B, that's why "FROM A.R as r LEFT JOIN B.I as T ON r.id = T.id" works. By default cross cache join will operate only on data available locally on each particular node.
Probably the following documentation will give you more hints https://apacheignite.readme.io/docs/sql-queries#section-cross-cache-queries https://apacheignite.readme.io/docs/sql-queries#section-distributed-joins https://apacheignite.readme.io/docs/sql-queries#section-distributed-collocated-joins Kind regards, Alex. On Fri, Jul 14, 2017 at 8:49 AM, neerajbhatt [via Apache Ignite Users] < ml+s70518n14865...@n6.nabble.com> wrote: > Any update ? > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://apache-ignite-users.70518.x6.nabble.com/wrong- > data-from-cluster-nodes-while-using-left-join-tp14782p14865.html > To start a new topic under Apache Ignite Users, email > ml+s70518n1...@n6.nabble.com > To unsubscribe from Apache Ignite Users, click here > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> > . > NAML > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/wrong-data-from-cluster-nodes-while-using-left-join-tp14782p14886.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.