I'm going to explain a bit more. I use Apache Ignite as front cache to my RDBMS, I've done automatic RDBMS integration. Table A, Table B, Table C is a example simplified for my real schema. My schema is much more complex.
I answer the questions: 1. True. 2. True 3. I use thin client with sql queries and DISTRIBUTED_JOINS=false. I want to know if tbl_a <- tbl_b <- tbl_c, if I have collocated table_a with table_b and table_b with table_c, then, Could I make a query with three tables? I understand that it is necessary to put affinity key from table_c to table_a, so table_b and table_c have same affinity key. It is unique solution or put table_a as replicated and only table_c with affinity key to table_b. It is true? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
