But you changed the schema from the documentation. In the guide, CountryCode is the primary key for the country table/cache. In your schema, you have country_id in the Country table and country_code in City.
Two possible solutions: 1. Change the primary key of Country from country_id to country_name 2. Change the affinity key in City from country_name to country_id The key (pun intended) is that the key for Country and the affinity key for City are the same. > On 19 Mar 2019, at 08:31, NileshKhaire <ngkha...@gmail.com> wrote: > > Hello, > > Thanks for response. I don't think it is necessary to have country_id as key > in City. Because in the official documentation of ignite here > https://ignite.apache.org/features/collocatedprocessing.html (See SQL > schema) they haven't used 'Code CHAR(3)' as key in City table. > > By the way, if you know the schema for which collocation is working, please > share with us . > > Thanks > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/