Is table c, a child of table b?
You have:
tbl_a tbl_b tbl_c
----- ------ -----
aff_a aff_b
You want:
tbl_a tbl_b tbl_c
----- ------ -----
aff_a aff_a
You want a "cosmic parent" in this case it seems that tbl_c is grandchild of A
and table C's affinity key should have table A's "id" so that all related data
ends up on the same node as the id of table a.
Cheers,
Craig
________________________________
From: manueltg89 <[email protected]>
Sent: Thursday, June 11, 2020 12:39 PM
To: [email protected] <[email protected]>
Subject: Re: Non Distributed Join between tables
CAUTION: This email originated outside 24 Hour Fitness. Do not click links or
open attachments unless you recognize the sender and know the content is safe.
Sorry Ilya, in my first post had an error. My structure is the following:
tbl_a tbl_b tbl_c
----- ------ -----
aff_a aff_b
When I make: select * from tbl_a INNER JOIN tbl_b ON tbl_b.id = tbl_a.fk_id
INNER JOIN tbl_c.fk_id = tbl_b.id -> Return empty results.
Could I to have three partitioned caches here?
Is there any way to make this with join collocated and whitout replicated
cache?
Thanks un advance.
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
