Internals of Hash-Semi-Join (Multi-Process-Unit Version) - 2024.1 English

Vitis Libraries

Release Date
2024-08-06
Version
2024.1 English

This document describes the structure and execution of Hash-Semi-Join, implemented as a hashSemiJoin function. Its implementation is based on Hash-Join-MPU.

Hash-Semi-Join returns rows from the outer table where a field of the outer table matches with the one of the inner table. Even if a record of the outer table matches with many rows in the inner table, the one of outer table is output only once.

the operation of hash semi join
Hash-Semi-Join is written using the EXISTS or IN constructs. For example:
select * from S where S.key in ( select key from T )