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.
Thanks
Naveen
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
