...
General HPCC Systems core platform
Thor jobs locking up when using SMART join
This may happen in specific circumstances, when using a SMART join that has failed over to a local hash join and the LHS is stopped early. The workaround if this issue is being hit in builds prior to this fix (7.4.34), would be to switch from using a SMART join, to either a regular HASH join, or a standard JOIN.
Note: Because this only happens when it has already run out of memory (and failed over to a local hash join), coding specifically as a HASH join is no worse performance wise.
https://track.hpccsystems.com/browse/HPCC-23068
Whitelisting feature in DALI
...