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