Hash Anti-join - Hash Anti-join - 2022.2 English

Hash Anti-join resides in L1/benchmarks/hash_anti_join directory. This benchmark tests the performance of anti_join_build_probe from hash_anti_join.h with the following query.

SELECT
        SUM(l_extendedprice * (1 - l_discount))
FROM
        Lineitem
WHERE
        l_orderkey NOT IN (SELECT o_orderkey FROM Orders)
;

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.