Skip to content

Benchmarking Results JoinSortMerge AggregateSort

Alexander Löser edited this page Feb 4, 2019 · 2 revisions

performed in hyriseConsole on TPCH tables with scale factor 1

executed query: "For each order, get priority and total quantity of items ordered".
While it feels somewhat constructed, its not so much different from some TPCH queries, In particular, it feels pretty similar to (a part of) TPCH-18.

SELECT o_orderkey, o_orderpriority, SUM(l_quantity) as TotalQuantity
FROM lineitem, orders
WHERE o_orderkey = l_orderkey
GROUP BY  o_orderkey, o_orderpriority

Results:

HashJoin + SortAggregate 13 s 983 ms
HashJoin + HashAggregate 4 s 353 ms
SortMergeJoin + SortAggregate 2 s 796 ms
SortMergeJoin + HashAggregate 6 s 871 ms