Can you share your configuration and model? It would be great if you can provide simple maven project on Github.
On Thu, Dec 7, 2017 at 10:10 PM, Naveen <[email protected]> wrote: > I have created an index on partyId of Account cache, after that query is > responding in milli seconds. > > However, my basic affinity and collation does not seems to be working. > > I have created records with Ids from P101000000 to P101010000. > If you see below, some of the records are not returned, does that means > they are not collacated. > > 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, > P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where > P.PARTY_ID='P101000016' and P.PARTY_ID= A.PARTY_ID; > +--------------------------------+-------------------------- > ------+--------------------------------+ > | PARTY_ID | PARTY_ID | > ACCOUNT_ID_LIST | > +--------------------------------+-------------------------- > ------+--------------------------------+ > +--------------------------------+-------------------------- > ------+--------------------------------+ > No rows selected (0.01 seconds) > 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, > P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where > P.PARTY_ID='P101000023' and P.PARTY_ID= A.PARTY_ID; > +--------------------------------+-------------------------- > ------+--------------------------------+ > | PARTY_ID | PARTY_ID | > ACCOUNT_ID_LIST | > +--------------------------------+-------------------------- > ------+--------------------------------+ > | P101000023 | P101000023 | > A101000023 | > +--------------------------------+-------------------------- > ------+--------------------------------+ > 1 row selected (0.011 seconds) > 0: jdbc:ignite:thin://127.0.0.1> select P.PARTY_ID, A.PARTY_ID, > P.ACCOUNT_ID_LIST from "Customer".Customer P, "Account".Account A where > P.PARTY_ID='P101000024' and P.PARTY_ID= A.PARTY_ID; > +--------------------------------+-------------------------- > ------+--------------------------------+ > | PARTY_ID | PARTY_ID | > ACCOUNT_ID_LIST | > +--------------------------------+-------------------------- > ------+--------------------------------+ > +--------------------------------+-------------------------- > ------+--------------------------------+ > No rows selected (0.022 seconds) > > What could be the reason > > Thanks > Naveen > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
