[jira] [Updated] (IGNITE-22110) [SQL] TPC-H q16 query hangs with sc=0.1

["Nikita Sivkov (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-22110?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Nikita Sivkov updated IGNITE-22110:
-----------------------------------
    Summary: [SQL] TPC-H q16 query hangs with sc=0.1  (was: CLONE - [SQL] TPC-H q16 query hangs with sc=0.1)

> [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)