Hello! Looks like affinity collocation does not work. Can you share country-city script (and DDL) so I could check?
Regards, -- Ilya Kasnacheev пт, 15 мар. 2019 г. в 19:16, NileshKhaire <[email protected]>: > 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/ >
