Hash Join resides in L1/benchmarks/hash_join_v3_sc
directory.
This benchmark tests the performance of hashJoinV3 from hash_join_v3.hpp
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 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.