Re: Non Distributed Join between tables

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

Re: Non Distributed Join between tables

Hello! If both tbl_a and tbl_c use tbl_b.id == tbl_a.fk_id == tbl_c.fk_id as affinity key, then I assume it would. Regards, -- Ilya Kasnacheev чт, 25 июн. 2020 г. в 19:17, manueltg89 : > With the following structure, and partitioned cache in the three tables: > > tbl_a tbl_b tbl_c

Re: Non Distributed Join between tables

With the following structure, and partitioned cache in the three tables: 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 Should it

Re: Non Distributed Join between tables

Hello! This seems to be a MySQL script. Can you please provide an Ignite SQL script to demonstrate the issue? Thanks, -- Ilya Kasnacheev пт, 19 июн. 2020 г. в 16:35, manueltg89 : > I attach required file SQL. dbaffinity.sql >

Re: Non Distributed Join between tables

I attach required file SQL. dbaffinity.sql -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Non Distributed Join between tables

Hello! Do you have a SQL script to reproduce this issue? Regards, -- Ilya Kasnacheev пт, 12 июн. 2020 г. в 09:48, manueltg89 : > 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

Re: Non Distributed Join between tables

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

Re: Non Distributed Join between tables

a.id when putting object c). Hopefully this helps but might possibly cause more questions. Cheers, Craig From: manueltg89 Sent: Thursday, June 11, 2020 1:05 PM To: user@ignite.apache.org Subject: Re: Non Distributed Join between tables CAUTION: This email originat

Re: Non Distributed Join between tables

Yes, table c is child of table b. But, It is redundant in my RDBMS, Would have other solution whitout changing my schema? -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Non Distributed Join between tables

er@ignite.apache.org 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 followin

Re: Non Distributed Join between tables

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

Re: Non Distributed Join between tables

I had to set baseline topology to all nodes. Now this works perfectly, thanks. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Non Distributed Join between tables

Hello! Yes, if both nodes are in baseline then both nodes should have the same data. In fact, when you query your cluster, you should get the same result regardless of node which does the query. Regards, -- Ilya Kasnacheev пн, 8 июн. 2020 г. в 21:12, manueltg89 : > Hello Ilya!, > > Thanks

Re: Non Distributed Join between tables

Hello Ilya!, Thanks for your response. I've created a new project and seems that now It works correctly, I must have a problem. But I have another doubt with REPLICATED cache. I think that all nodes must have same data in this mode, Is It true?, with online tool of Apache Ignite I make a query to

Re: Non Distributed Join between tables

Hello! Do you have a reproducer SQL script to observe that? Regards, -- Ilya Kasnacheev пн, 8 июн. 2020 г. в 10:46, manueltg89 : > I have three tables in Apache Ignite, each table has a affinity key to > other > table, when I make a join between tables with direct relations this works >

Non Distributed Join between tables

I have three tables in Apache Ignite, each table has a affinity key to other table, when I make a join between tables with direct relations this works perfectly, but if I make a non distributed join between three tables this return empty, is normal this behaviour?, Could I make in another way?