Hi, You are doing a join between a PARTITIONED and REPLICATED caches with distributedJoin=true. In this case an index is required . If you look at the full log, it will tell you where to place the index. see: https://apacheignite-sql.readme.io/docs/distributed-joins#non-collocated-joins Either add the index or change the PERSON cache to be REPLICATED as well.
The PERSON cache is created as PARTITIONED because it is the default when you don't explicitly set the cacheMode <bean class="org.apache.ignite.configuration.CacheConfiguration"> <property name="name" value="PERSON"/> Thanks, Alex -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/