FULL OUTER join not available with MySQL datasets

william
Level 1
FULL OUTER join not available with MySQL datasets

Hello,



I'm trying to use a FULL OUTER join in a recipe between 2 MySQL datasets. The option is not available while it appears that it should: "Not available in this mode, use a SQL or Hive database to use FULL OUTER joins."



Keep up,



William

0 Kudos
4 Replies
jrouquie
Dataiker Alumni
Hi William,

MySQL does not support FULL OUTER JOIN, apparently since some time:

http://bugs.mysql.com/bug.php?id=18003

So DSS had no choice but to disable it in the case of MySQL, to avoid errors. Maybe it's an option for you to use another DB engine, like PostgreSQL?

Best regards,

Jean-Baptiste Rouquier
0 Kudos
william
Level 1
Author
Yes i can do that.

Thank you
William
0 Kudos
jereze
Community Manager
Community Manager

Hi William,



MySQL does not officially support FULL OUTER joins.



There is common hack to emulate a FULL OUTER join with a left and a right join (as suggested in the comments of the documentation). But this hack is not implemented in the join (visual) recipe. I'm not sure it will be.



However, you could do it manually with the SQL (code) recipe.



I hope that helps,

Jeremy

Jeremy, Product Manager at Dataiku
0 Kudos
william
Level 1
Author
Thank you for your help.

William
0 Kudos

Labels

?
Labels (3)
A banner prompting to get Dataiku