Hash Join resides in the L1/benchmarks/hash_join_v3_sc directory. This benchmark tests the performance of hashJoinV3 from hash_join_v3.hpp with the following query:
.. code-block:: bash
- SELECT
- SUM(l_extendedprice * (1 - l_discount)) as revenue
- FROM
- Orders, Lineitem
- WHERE
- l_orderkey = o_orderkey
;
Here Orders is a self-made table 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.