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?
Thanks