You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2021/04/17 22:06:00 UTC
[GitHub] [arrow] andygrove commented on pull request #10086: ARROW-12437: [Rust] [Ballista] Create DataFusion context without repartition
andygrove commented on pull request #10086:
URL: https://github.com/apache/arrow/pull/10086#issuecomment-821894186
```
❯ ../../target/release/tpch benchmark --query 12 --path /mnt/tpch/parquet-sf100-partitioned/ --format parquet --host localhost --port 50050 --debug
Running benchmarks with the following options: BenchmarkOpt { host: "localhost", port: 50050, query: 12, debug: true, iterations: 1, batch_size: 32768, path: "/mnt/tpch/parquet-sf100-partitioned/", file_format: "parquet" }
Running benchmark with query 12:
select
l_shipmode,
sum(case
when o_orderpriority = '1-URGENT'
or o_orderpriority = '2-HIGH'
then 1
else 0
end) as high_line_count,
sum(case
when o_orderpriority <> '1-URGENT'
and o_orderpriority <> '2-HIGH'
then 1
else 0
end) as low_line_count
from
lineitem
join
orders
on
l_orderkey = o_orderkey
where
l_shipmode in ('MAIL', 'SHIP')
and l_commitdate < l_receiptdate
and l_shipdate < l_commitdate
and l_receiptdate >= date '1994-01-01'
and l_receiptdate < date '1995-01-01'
group by
l_shipmode
order by
l_shipmode;
Query 12 iteration 0 took 38920.5 ms
+------------+-----------------+----------------+
| l_shipmode | high_line_count | low_line_count |
+------------+-----------------+----------------+
| MAIL | 623115 | 934713 |
| SHIP | 622979 | 934534 |
+------------+-----------------+----------------+
Query 12 avg time: 38920.45 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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org