Thanks Alex for the explanation. I guess, I will need to set the distributed join option to false, if the affinity is in action. But doesn't the primary keys result in indexes? If so, then the requirement for having an index should be satisfied, right? I am joining the two tables on the field, orgid.
On Tue, Apr 21, 2020 at 2:43 PM akorensh <alexanderko...@gmail.com> wrote: > 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/ >