Community Conundrums are live! Learn more

Mysql left-outer join not working via DSS (but working in MySQL workbench)

Level 1
Mysql left-outer join not working via DSS (but working in MySQL workbench)

Hi,

i'm a newbie here and working on the Churn tutorial. 🙂

I was able to load/store 2 tables (events & products) in a MySQL database using a Prepare recipe.

However when i want to join both tables with a Join recipe (via left outer join) it looks being stuck at executing the query (for 50min +).

But if i run the query (generated in output of Join recipe) directly in MySQL workbench it runs fine in 15seconds...

Next, when I use an inner join it works instantly (both in DSS & MySQL workbench).

Any idea what could cause this issue?

thanks for your help on this.

br,

Stanislas

0 Kudos
1 Reply
Dataiker
Dataiker

Hi Stanislas,

Appreciate you reaching out to us with this issue.

To help us further investigate, would you mind opening a support ticket by sending an email to support@dataiku.com

In your email, please can you attach a diagnostic of the affected job ? From the job page, click on Actions > Download job diagnosis. 

If the resulting file is too large for mail (> 15 MB), you can use https://dl.dataiku.com to send it to us. Please don't forget to send the link that is generated when you upload the file.
 
Please let us know if you have any questions or require any clarification.
 
Regards,
 
Ben Coffey