Hash Multi-Join - 2023.1 English

Hash Multi-Join resides in L1/benchmarks/hash_multi_join directory. This benchmark tests the performance of hashMultiJoin primitive with the following query.

SELECT
       SUM(l_extendedprice * (1 - l_discount)) as revenue
FROM
       Orders,
       Lineitem
WHERE
       l_orderkey = o_orderkey
;

Here Orders is a self-made table filled with random data,which contains a column named o_orderkey;

Lineitem is also a table, which contains 3 columns named l_orderkey, l_extendedprice and l_discount.