Hi Stan

If I do not have the affinity key column as part of the primary key, it does
not allow me to create the table itself. 

If I want to execute a join query on both the tables, I had to use affinity
key to collocate the data

select p.party_id, a.party_id, first_name, A.SERVICE_ID_LIST  from Customer
P, Account  A where P.PARTY_ID= A.PARTY_ID and A.PARTY_ID IN ('P1', 'P2');

How can we make use of Affinity to collocate CUSTOMER and ACCOUNT data in
this case.


Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Reply via email to