xudong963 edited a comment on pull request #1566:
URL:
https://github.com/apache/arrow-datafusion/pull/1566#issuecomment-1013673068
Currently, query 8 can't seem to pass due to `case ... when ... then ...
else`, so I delete it to run the bench
```sql
select
o_year,
from
(
select
extract(year from o_orderdate) as o_year,
l_extendedprice * (1 - l_discount) as volume,
n2.n_name as nation
from
part,
supplier,
lineitem,
orders,
customer,
nation n1,
nation n2,
region
where
p_partkey = l_partkey
and s_suppkey = l_suppkey
and l_orderkey = o_orderkey
and o_custkey = c_custkey
and c_nationkey = n1.n_nationkey
and n1.n_regionkey = r_regionkey
and r_name = 'AMERICA'
and s_nationkey = n2.n_nationkey
and o_orderdate between date '1995-01-01' and date '1996-12-31'
and p_type = 'ECONOMY ANODIZED STEEL'
) as all_nations
group by
o_year
order by
o_year;
```
### master
```
➜ benchmarks git:(master) cargo run --release --bin tpch -- benchmark
datafusion --iterations 3 --path ./data --format tbl --query 8 --batch-size 4096
Query 8 iteration 0 took 5047.0 ms
Query 8 iteration 1 took 4540.6 ms
Query 8 iteration 2 took 4552.0 ms
Query 8 avg time: 4713.19 ms
```
### xudong963:fix_cross_join
```
➜ benchmarks git:(fix_cross_join) ✗ cargo run --release --bin tpch --
benchmark datafusion --iterations 3 --path ./data --format tbl --query 8
--batch-size 4096
Query 8 iteration 0 took 2823.8 ms
Query 8 iteration 1 took 2543.9 ms
Query 8 iteration 2 took 2442.7 ms
Query 8 avg time: 2603.48 ms
```
--
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: github-unsubscr...@arrow.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
