apache drill failed to execute SQL such as ' table1 left join table2 on condition 1 or condition 2'

Execute the following sql (although it may not make sense):
SELECT aa.employee_id FROM cp.`employee.json` aa left join cp.`employee.json` bb on aa.employee_id=bb.employee_id or aa.employee_id=bb.position_id ;


I got the results：

I tried to modify the corresponding parameters 'planner.enable_nljoin_for_scalar_only', but it still didn't work.