You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Yury Gerzhedovich (Jira)" <ji...@apache.org> on 2020/10/14 09:52:00 UTC
[jira] [Created] (IGNITE-13580) Calcite integration. Perform of
JOIN 2 partitioned tables to a replicated.
Yury Gerzhedovich created IGNITE-13580:
------------------------------------------
Summary: Calcite integration. Perform of JOIN 2 partitioned tables to a replicated.
Key: IGNITE-13580
URL: https://issues.apache.org/jira/browse/IGNITE-13580
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Yury Gerzhedovich
As of now H2 based engine has a performance issue for case joining 2 partitioned tables to a replicated table. Calcite engine should choose a more optimal plan and perform such query faster
As example:
We have 3 tables:
P1 (PARTITIONED) - 100M rows
P2 (PARTITIONED) - 200K rows
R (REPLICATED) - 80 rows
SELECT count(*)
FROM P1,
P2,
R
WHERE P1.BATCHKEY = R.BATCHKEY
AND P1.TIDENTIFIER = P2.TIDENTIFIER
AND P1.TVER = P2.TVER
AND P2.BOOK = 'CONST'
AND R.ISLATEST = TRUE
--
This message was sent by Atlassian Jira
(v8.3.4#803005)