Why does a query run as INNER JOIN but not on a left join? GENERIC_INTERNAL_ERROR: Unexpected identifier in logical plan: loc

Question

Hi,

Can someone explain to me why my query works as long as I use an inner join but as soon as I change it to an Left Join I got the error: GENERIC_INTERNAL_ERROR: Unexpected identifier in logical plan: loc.

It's the table on row 38. As long as I use Inner it works.
![Enter image description here](/media/postImages/original/IMv9_tV2_FTA2ELh5NjugctA)

Answer

If this is production then please do open a Support ticket.

Also the image has SQL scratched out, so kindly share your query text so we can understand better.

Why does a query run as INNER JOIN but not on a left join? GENERIC_INTERNAL_ERROR: Unexpected identifier in logical plan: loc

Contenuto pertinente