RecursiveHashJoin is a variant of HashJoin, and is used for recursive union queries. For more information, see HashJoin algorithms (JH, JHSP, JHFO, JHAP, JHO, JHPO), and Recursive common table expressions.