You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Nikita Sivkov (Jira)" <ji...@apache.org> on 2024/04/25 11:06:00 UTC

[jira] [Created] (IGNITE-22111) [SQL] TPC-H q21 query hangs with sc=0.1

Nikita Sivkov created IGNITE-22111:
--------------------------------------

             Summary: [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


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)