[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:
--
Release Note: Improved estimation of rows number of join operation.
> 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 CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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 CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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:
--
Description:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
{code}
Workarounds: `/*+ ENFORCE_JOIN_ORDER */`, `/*+ NO_NL_JOIN +/`
was:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
```
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
```
Current code shows:
```
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
```
Workarounds: `/*+ ENFORCE_JOIN_ORDER */`, `/*+ NO_NL_JOIN +/`
> 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
>Reporter: Vladimir Steshin
>Priority: Major
>
> `TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
> ms/op
> {code}
> Workarounds: `/*+ ENFORCE_JOIN_ORDER */`, `/*+ NO_NL_JOIN +/`
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
[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:
--
Ignite Flags: Release Notes Required (was: Docs Required,Release Notes
Required)
> 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
>Reporter: Vladimir Steshin
>Priority: Major
> Labels: calcite, ignite-2, ise
>
> _TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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:
--
Description:
_TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
{code}
Workarounds:
{code:java}
/*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
{code}
was:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
{code}
Workarounds:
{code:java}
/*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
{code}
> 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
>Reporter: Vladimir Steshin
>Priority: Major
> Labels: ise
>
> _TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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:
--
Labels: calcite ignite-2 ise (was: ise)
> 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
>Reporter: Vladimir Steshin
>Priority: Major
> Labels: calcite, ignite-2, ise
>
> _TpchBenchmark_ with build at 31.03.2025, the query q5 and scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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:
--
Labels: ise (was: )
> 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
>Reporter: Vladimir Steshin
>Priority: Major
> Labels: ise
>
> `TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
[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:
--
Description:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
{code}
Workarounds:
{code:java}
/*+ ENFORCE_JOIN_ORDER */, /*+ NO_NL_JOIN +/
{code}
was:
`TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode CntScore
Error Units
TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
120.338 ms/op
TpchBenchmark.cold H2 5 0.01ss 805.308
ms
{code}
Current code shows:
{code:java}
Benchmark (engine) (queryId) (scale) Mode Cnt Score
Error Units
TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
216.738 ms/op
TpchBenchmark.cold CALCITE 5 0.01ss 1786.908
ms/op
{code}
Workarounds: `/*+ ENFORCE_JOIN_ORDER */`, `/*+ NO_NL_JOIN +/`
> 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
>Reporter: Vladimir Steshin
>Priority: Major
>
> `TpchBenchmark` with build of 31.03.2025, the query q5, scale 0.01 shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode CntScore
> Error Units
> TpchBenchmark.cachedH2 5 0.01 avgt3 146.985 ±
> 120.338 ms/op
> TpchBenchmark.cold H2 5 0.01ss 805.308
> ms
> {code}
> Current code shows:
> {code:java}
> Benchmark (engine) (queryId) (scale) Mode Cnt Score
> Error Units
> TpchBenchmark.cached CALCITE 5 0.01 avgt3 619.041 ±
> 216.738 ms/op
> TpchBenchmark.cold CALCITE 5 0.01ss 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)
