[
https://issues.apache.org/jira/browse/IGNITE-25129?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18056112#comment-18056112
]
Evgeny Stanilovsky commented on IGNITE-25129:
---------------------------------------------
[~vladsz83] do you plan to continue here ?
> 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: 1h 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)
