Hash Join V4 - 2024.1 English

Hash Join V4 resides in the L1/benchmarks/hash_join_v4_sc directory. This benchmark tests the performance of the hashJoinV4 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 three columns named l_orderkey, l_extendedprice, and l_discount.