The hash anti-join desgin is validated on an AMD Alveo™ U280 board at a 250 MHz frequency. The hardware resource utilizations are listed in the following table.
Name | LUT | BRAM | URAM | DSP |
Platform | 130442 | 204 | 0 | 4 |
join_kernel | 134647 | 291 | 192 | 99 |
User Budget | 1172278 | 1812 | 960 | 9020 |
Percentage | 11.49% | 16.06% | 20.00% | 1.10% |
The performance is shown below. In above test, table Lineitem
has three columns and 6001215 rows, and Orders
does one column and 227597 rows. This means that the design takes 342.568 ms to process 69.55 MB, so it achieves 203.02 Mb/s throughput.