You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Vladimir Steshin (Jira)" <ji...@apache.org> on 2025/05/30 13:10:00 UTC
[jira] [Updated] (IGNITE-25129) Calcite. TPC-H query #5: performance drop on scale 0.01
[ https://issues.apache.org/jira/browse/IGNITE-25129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Steshin updated IGNITE-25129:
--------------------------------------
Affects Version/s: 2.17
> Calcite. TPC-H query #5: performance drop on scale 0.01
> -------------------------------------------------------
>
> Key: IGNITE-25129
> URL: https://issues.apache.org/jira/browse/IGNITE-25129
> Project: Ignite
> Issue Type: Bug
> Affects Versions: 2.17
> Reporter: Vladimir Steshin
> Assignee: Vladimir Steshin
> Priority: Major
> Labels: calcite, ignite-2, ise
> Time Spent: 40m
> Remaining Estimate: 0h
>
> _TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score Error Units
> TpchBenchmark.cached H2 5 0.01 avgt 3 146.985 ± 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01 ss 805.308 ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt 3 619.041 ± 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01 ss 1786.908 ms/op
> {code}
> Workarounds:
> {code:java}
> /*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)