unfortunately the 's' on B here can't be derived from a number 0..n - e.g. it isn't a numeric id.
E.g. in practice lets say: A is a "Location" it has properties: "city", "street" etc B is a "Person" with key: p = city q = street r = social security number E.g. an A and associated B's are updated in a transaction, we want our client app to see the updated A and B's where the Person lives at that that Location. E.g. A is updated and our continuous query on A picks up: city = London street = Downing Street We would like to say: Select * from B where city="London" and street="Downing Street" Is there any way at all in Ignite to do this transactionally, so if an A and associated B's are updated in one transaction (e.g. a street is renamed from "Downing Street" to "Regent Street"), then our client app can see them consistently? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/