From user-return-30841-archive-asf-public=cust-asf.ponee.io@ignite.apache.org Fri Jun 19 13:21:09 2020 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 89D64180647 for ; Fri, 19 Jun 2020 15:21:09 +0200 (CEST) Received: (qmail 15906 invoked by uid 500); 19 Jun 2020 13:21:08 -0000 Mailing-List: contact user-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@ignite.apache.org Delivered-To: mailing list user@ignite.apache.org Received: (qmail 15896 invoked by uid 99); 19 Jun 2020 13:21:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Jun 2020 13:21:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id D07CEC0225 for ; Fri, 19 Jun 2020 13:21:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.001 X-Spam-Level: * X-Spam-Status: No, score=1.001 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_REPLY=1, HTML_MESSAGE=0.2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id g8rC-zzgGALM for ; Fri, 19 Jun 2020 13:21:06 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2607:f8b0:4864:20::92c; helo=mail-ua1-x92c.google.com; envelope-from=ilya.kasnacheev@gmail.com; receiver= Received: from mail-ua1-x92c.google.com (mail-ua1-x92c.google.com [IPv6:2607:f8b0:4864:20::92c]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id D2AA67DD07 for ; Fri, 19 Jun 2020 13:21:05 +0000 (UTC) Received: by mail-ua1-x92c.google.com with SMTP id b13so3168775uav.3 for ; Fri, 19 Jun 2020 06:21:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=LKSLE0d5z3SnR7cUkbnMUQzNbsmJRhZWBX/PPVjzZVY=; b=C6RWXXfxL5VhpyScqCHp2nlzn+VBwHCnf9J5wjDAHt4UIbg7Jt+p1Imt/8hm9LzozZ EDq+1aOPNG4kJcckr6pyNenB+jSVGdc/mIOEC6wDMv1kUJ1MqNCt+u+4UZomJdyhUbpk l4ZVLwcWirFozxQHdKsFyNzy19lFXeg7At7wGxN3jRtZQjnarcO5dgW7i7DF0Yc1S2oj Y9uVzDXpTdiTsqdZ/I4ROOq33N5bDp/2LCNBuNWvofxPSCTfOua9KEZ/IuyOWIeWu+KN nG1SnzPQ+HN0rKXoegNK7tnHMN7jiXfm3BnriA9sfkiOnsDVH/2cF2ytLVwlTs9zTWxQ xnhQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=LKSLE0d5z3SnR7cUkbnMUQzNbsmJRhZWBX/PPVjzZVY=; b=JFgLUHNLH3N9ILE/sQGUSTrywM7O/Qx5xy4eLyx1oFpNrzS6UA0geDN62kfyjlExyd PndNljlml/H6u49fB63hqrIjbIAMtpCi9ZzhjLQ9dI1WlW9KPwDssAU/wVl2eI5AooSv O3Y048A8XtkwazbRQiswyPRKVWjTPyJOq4hdl8y+tJy4A2YPI4XckZ70S7SqWtzQ4YIi Q+5+goXRaJFUg8oOi+5xAqIw9MVRun+oD0rciigmesPNv4xL1wkZeJf+OtKhalf6KQqT w7YpSan9ECbd+qbJgHx0rSI31mw5VwLl6eauMmnZoy+c9NygSq9KxZjKPn9/eBod73BZ DAhQ== X-Gm-Message-State: AOAM530c9EHSfFcBayKPUFoleT+dajShRfF2ZHT+B4yX5M4FlNvK0xew a0lLbiY4f9U1H6ybwS3hoZ9UFjxc4r8rOc0KUGtz3A== X-Google-Smtp-Source: ABdhPJzk3qHfKGbluI2hRvo3drYrX9wU3n+RlVwrf2ckd3gUihqWA20PgPiN+jR6woJljWao+M3s+Bq0Gm1VBoc1cao= X-Received: by 2002:ab0:7701:: with SMTP id z1mr2590936uaq.30.1592572858525; Fri, 19 Jun 2020 06:20:58 -0700 (PDT) MIME-Version: 1.0 References: <1591602398346-0.post@n6.nabble.com> <1591639923062-0.post@n6.nabble.com> <1591904370666-0.post@n6.nabble.com> <1591905959633-0.post@n6.nabble.com> <1591944503926-0.post@n6.nabble.com> In-Reply-To: <1591944503926-0.post@n6.nabble.com> From: Ilya Kasnacheev Date: Fri, 19 Jun 2020 16:20:46 +0300 Message-ID: Subject: Re: Non Distributed Join between tables To: user@ignite.apache.org Content-Type: multipart/alternative; boundary="00000000000082ee4705a86fc326" --00000000000082ee4705a86fc326 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hello! Do you have a SQL script to reproduce this issue? Regards, --=20 Ilya Kasnacheev =D0=BF=D1=82, 12 =D0=B8=D1=8E=D0=BD. 2020 =D0=B3. =D0=B2 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 i= s > 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=3Dfalse. > > 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/ > --00000000000082ee4705a86fc326 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hello!

Do you have a SQL scr= ipt to reproduce this issue?

Regards,
--
Ilya Kasnacheev


=D0=BF=D1=82= , 12 =D0=B8=D1=8E=D0=BD. 2020 =D0=B3. =D0=B2 09:48, manueltg89 <manuel.trinidad.garcia@hotma= il.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=3Dfalse.

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.nabbl= e.com/
--00000000000082ee4705a86fc326--