ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Kasnacheev <ilya.kasnach...@gmail.com>
Subject Re: Non Distributed Join between tables
Date Fri, 19 Jun 2020 13:20:46 GMT
Hello!

Do you have a SQL script to reproduce this issue?

Regards,
-- 
Ilya Kasnacheev


пт, 12 июн. 2020 г. в 09:48, manueltg89 <manuel.trinidad.garcia@hotmail.com
>:

> 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/
>

Mime
View raw message