ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From NileshKhaire <ngkha...@gmail.com>
Subject Re: Finding collocated data in ignite nodes
Date Fri, 15 Mar 2019 16:16:16 GMT
Hello,

I have inserted 1000 cities now and 3 countries. 

1st Country = 500 cities
2nd Country = 300 cities
3rd Country = 200 cities

After executing first query

select * from City c join Country cc on cc.Code = c.CountryCode;  *record
count is 0*

after executing second query 

select * from City c join Country cc on cc.Code != c.CountryCode;* record
count is 1200*

This is completely opposite to your result , in first query you have 0
records and for second query you have some records.




--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Mime
View raw message