[ https://issues.apache.org/jira/browse/IGNITE-22110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikita Sivkov updated IGNITE-22110: ----------------------------------- Description: 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 [Q16|https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/tpch/procedures/Q16.java] query: {noformat} SELECT p_brand, p_type, p_size, COUNT(DISTINCT ps_suppkey) AS supplier_cnt FROM partsupp, part WHERE p_partkey = ps_partkey AND p_brand <> ? AND p_type NOT LIKE ? AND p_size IN (?, ?, ?, ?, ?, ?, ?, ?) AND ps_suppkey NOT IN ( SELECT s_suppkey FROM supplier WHERE s_comment LIKE '%Customer%Complaints%' ) GROUP BY p_brand, p_type, p_size ORDER BY supplier_cnt DESC, p_brand, p_type, p_size{noformat} was: 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 [Q4|https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/tpch/procedures/Q4.java] query: {noformat} SELECT o_orderpriority, COUNT(*) AS order_count FROM orders WHERE o_orderdate >= DATE ? AND o_orderdate < DATE ? + INTERVAL '3' MONTH AND EXISTS ( SELECT * FROM lineitem WHERE l_orderkey = o_orderkey AND l_commitdate < l_receiptdate ) GROUP BY o_orderpriority ORDER BY o_orderpriority {noformat} > CLONE - [SQL] TPC-H q16 query hangs with sc=0.1 > ----------------------------------------------- > > Key: IGNITE-22110 > URL: https://issues.apache.org/jira/browse/IGNITE-22110 > 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 > [Q16|https://github.com/cmu-db/benchbase/blob/main/src/main/java/com/oltpbenchmark/benchmarks/tpch/procedures/Q16.java] > query: > > {noformat} > SELECT > p_brand, > p_type, > p_size, > COUNT(DISTINCT ps_suppkey) AS supplier_cnt > FROM > partsupp, > part > WHERE > p_partkey = ps_partkey > AND p_brand <> ? > AND p_type NOT LIKE ? > AND p_size IN (?, ?, ?, ?, ?, ?, ?, ?) > AND ps_suppkey NOT IN > ( > SELECT > s_suppkey > FROM > supplier > WHERE > s_comment LIKE '%Customer%Complaints%' > ) > GROUP BY > p_brand, > p_type, > p_size > ORDER BY > supplier_cnt DESC, > p_brand, > p_type, > p_size{noformat} -- This message was sent by Atlassian Jira (v8.20.10#820010)