[
https://issues.apache.org/jira/browse/IGNITE-22111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Sivkov resolved IGNITE-22111.
------------------------------------
Resolution: Not A Problem
Fixed with creating indexes as it done in
[https://github.com/apache/ignite-3/tree/main/modules/sql-engine/src/testFixtures/resources/tpch/ddl]
> [SQL] TPC-H q21 query hangs with sc=0.1
> ---------------------------------------
>
> Key: IGNITE-22111
> URL: https://issues.apache.org/jira/browse/IGNITE-22111
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Nikita Sivkov
> Priority: Major
> Labels: ignite-3, ignite3_performance
>
> Benchmark:
> [https://github.com/cmu-db/benchbase/tree/main/src/main/java/com/oltpbenchmark/benchmarks/tpch]
>
> h1. Setup
> * 1 server node
> * TPC-H with scale factor = 0.1
> h1. Steps
> # Start an Ignite node
> # Run benchbase with {{-s 1 --create=true --load=true --execute=false}} to
> preload data
> # Observe via the benchbase log that the data was successfully loaded
> # Run {{benchbase with -s 1 --create=false --load=false --execute=true}} to
> run the benchmark
> h1. Expected result
> The benchmark finishes after warmup + duration time
> h1. Actual result
> The benchmark hangs for hours on
> [Q21|https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/tpch/procedures/Q21.java]
> query:
>
> {noformat}
> SELECT
> s_name,
> COUNT(*) AS numwait
> FROM
> supplier,
> lineitem l1,
> orders,
> nation
> WHERE
> s_suppkey = l1.l_suppkey
> AND o_orderkey = l1.l_orderkey
> AND o_orderstatus = 'F'
> AND l1.l_receiptdate > l1.l_commitdate
> AND EXISTS
> (
> SELECT
> *
> FROM
> lineitem l2
> WHERE
> l2.l_orderkey = l1.l_orderkey
> AND l2.l_suppkey <> l1.l_suppkey
> )
> AND NOT EXISTS
> (
> SELECT
> *
> FROM
> lineitem l3
> WHERE
> l3.l_orderkey = l1.l_orderkey
> AND l3.l_suppkey <> l1.l_suppkey
> AND l3.l_receiptdate > l3.l_commitdate
> )
> AND s_nationkey = n_nationkey
> AND n_name = ?
> GROUP BY
> s_name
> ORDER BY
> numwait DESC,
> s_name LIMIT 100{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
