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)
