RatulDawar commented on issue #21625:
URL: https://github.com/apache/datafusion/issues/21625#issuecomment-4246606398
This can be minimally reproduced using this (essentially the same as the
bench query)
```
cargo build --release -p datafusion-cli
## use the cli
DATAFUSION_EXECUTION_TARGET_PARTITIONS=24 ./target/release/datafusion-cli
-- Register TPC-H Tables
CREATE EXTERNAL TABLE lineitem STORED AS PARQUET LOCATION
'benchmarks/data/tpch_sf1/lineitem';
CREATE EXTERNAL TABLE orders STORED AS PARQUET LOCATION
'benchmarks/data/tpch_sf1/orders';
CREATE EXTERNAL TABLE customer STORED AS PARQUET LOCATION
'benchmarks/data/tpch_sf1/customer';
-- TPC-H Query 18 (The hanging query)
select
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice,
sum(l_quantity)
from
customer,
orders,
lineitem
where
o_orderkey in (
select
l_orderkey
from
lineitem
group by
l_orderkey having
sum(l_quantity) > 300
)
and c_custkey = o_custkey
and o_orderkey = l_orderkey
group by
c_name,
c_custkey,
o_orderkey,
o_orderdate,
o_totalprice
order by
o_totalprice desc,
o_orderdate
limit 100;
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
