Workbench doesn't support Group By in a MySQL query

Hi - 

I have a Workbench job that won't run successfully with the needed group by - if i remove the group by it runs, but only returns one row, due to the nature of the query.2018-07-05_17-06-38.jpg

 

 

 

Not a helpful error message...

Anyone experience this or have any suggestions?

thank you! 

please reach out to 

@bryanphillips

with any solutions.  

 

@tylermajor

Comments

  • Hi,

     

    Is anyone able to help with this request?

     

    Thanks,

  • Jarvis
    Jarvis Domo Employee

     Hey amycaroline,

    I think it may be best to have you contact your Domo account team for further support on that error! Make sure to provide job logs if you have them, as they can outline further details on what is occurring within your query.

     

    Thanks!

This discussion has been closed.