[ https://issues.apache.org/jira/browse/IGNITE-22110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Nikita Sivkov resolved IGNITE-22110. ------------------------------------ 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 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)