Nikita Sivkov created IGNITE-22112: -------------------------------------- Summary: [SQL] TPC-H q9 query with sc=0.1 takes long time Key: IGNITE-22112 URL: https://issues.apache.org/jira/browse/IGNITE-22112 Project: Ignite Issue Type: Bug Components: sql Reporter: Nikita Sivkov
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)