Running Query more than a hour

Hello, I’m new using dremio and having a hard time running SQL query which joining 2 datasets.
One of the datasets has like 600k rows and 100+ collumns and the other one has only 230K rows but has a comment-like column. I tried optimizing the query but it does not finished even more than a hour and still running.

How do I solve this problem?

@Napoleon We have to see the job profile to see where the time was spent, are you able to download the job profile and send it over?