Name is required.
Email address is required.
Invalid email address
Answer is required.
Exceeding max length of 5KB

Full Outer Join Error

when joined 2 table with FULL join type, it throws following error.

"Validation error. org.postgresql.util.PSQLException: ERROR: could not devise a query plan for the given query"

Whereas, the same works for other join types.

1 Community Answers

Matillion Agent  

David Lipowitz —

Hi Madhab,

Thanks for the question. I noticed you’re using a gmail address so can you please confirm what company you work for?

And so we can better support you, can you please send us the Support Information available under the Help menu to the upper right of the canvas?

Could you please also send the SQL generated by the Join component you’re using?

Best Regards,
Dave

Post Your Community Answer

To add an answer please login