HPCC-9378 Remove DISTRIBUTE from the RHS of a global lookup join

Signed-off-by: Gavin Halliday <gavin.halliday@lexisnexis.com>
Merge pull request #4876 from ghalliday/issue9378

HPCC-9378 Remove DISTRIBUTE from the RHS of a global lookup join

Reviewed-By: Richard Chapman <rchapman@hpccsystems.com>