[
https://issues.apache.org/jira/browse/IGNITE-24753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17937321#comment-17937321
]
Ignite TC Bot commented on IGNITE-24753:
----------------------------------------
{panel:title=Branch: [pull/11955/head] Base: [master] : No blockers
found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/11955/head] Base: [master] : New Tests
(2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Calcite SQL{color} [[tests
2|https://ci2.ignite.apache.org/viewLog.html?buildId=8360180]]
* {color:#013220}IgniteCalciteTestSuite: TpchTest.test[queryId=20] -
PASSED{color}
* {color:#013220}IgniteCalciteTestSuite: TpchTest.test[queryId=16] -
PASSED{color}
{panel}
[TeamCity *--> Run :: All*
Results|https://ci2.ignite.apache.org/viewLog.html?buildId=8360265&buildTypeId=IgniteTests24Java8_RunAll]
> Calcite. TPC-H query #16: too long for scale=0.1 and 1.0
> --------------------------------------------------------
>
> Key: IGNITE-24753
> URL: https://issues.apache.org/jira/browse/IGNITE-24753
> Project: Ignite
> Issue Type: Bug
> Reporter: Sergey Korotkov
> Assignee: Aleksey Plekhanov
> Priority: Major
> Labels: ise, tpch
> Attachments: TpchQ16Test.java
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Works for scale factor 0.01 but doesn't complete in 5 minutes for scale
> factors 0.1 and 1.0.
> ***
> Load test (1 client node, 3 server nodes) shows that there is an
> unproportional increase of HEAP memory usage for scales 0.1 and 1.0 comparing
> to 0.01.
> For scale=0.01 it were executed about 700 queries in 5 seconds. With average
> 2.99Mb and 5.68Mb of heap allocation per request (on client and server
> correspondingly).
> For scales 0.1 and 1.0 single query was calcelled after 5 minutes, having
> Gigabytes of allocated per the single query.
>
> | ** | ** |*{color:#000000}Scale = 0.01{color}*|*{color:#000000}Scale =
> 0.1{color}*|*{color:#000000}Scale = 1.0{color}*|
> |*{color:#000000}benchmark{color}*|*{color:#000000}metric{color}*|*{color:#000000}value{color}*|*{color:#000000}value{color}*|*{color:#000000}value{color}*|
> |{color:#000000}Q16{color}|{color:#000000}client_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}2.99{color}|{color:#000000}11,390.24{color}|{color:#000000}11,495.04{color}|
> |{color:#000000}Q16{color}|{color:#000000}client_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}2,071.28{color}|{color:#000000}11,390.24{color}|{color:#000000}11,495.04{color}|
> |{color:#000000}Q16{color}|{color:#000000}server_heap_inTestAllocatedPerCall_MB/call_mean{color}|{color:#000000}5.68{color}|{color:#000000}15,489.86{color}|{color:#000000}8,576.07{color}|
> |{color:#000000}Q16{color}|{color:#000000}server_heap_inTestTotalAllocated_MB_mean{color}|{color:#000000}3,939.98{color}|{color:#000000}15,489.86{color}|{color:#000000}8,576.07{color}|
> |{color:#000000}Q16{color}|{color:#000000}count{color}|{color:#000000}693.33{color}|{color:#000000}1.00{color}|{color:#000000}1.00{color}|
> |{color:#000000}Q16{color}|{color:#000000}failed_count{color}|{color:#000000}0.00{color}|{color:#000000}1.00{color}|{color:#000000}1.00{color}|
> ***
> Performance of the TPC-H queries can also be tested locally in JMH test at
> [https://github.com/apache/ignite/blob/master/modules/benchmarks/src/main/java/org/apache/ignite/internal/benchmarks/jmh/sql/tpch/TpchBenchmark.java]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
