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

stanislas
stanislas Registered Posts: 5 ✭✭✭✭

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

Answers

  • bencoffey
    bencoffey Dataiker Alumni, Registered Posts: 5 ✭✭✭✭✭

    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
Setup Info
    Tags
      Help me…