This message was deleted.

1. not sure about memory limits specifically, but

druid.server.http.maxSubqueryRows

allows you to limit by row count.

The best way to do this is try to do the join after aggregation. Can you paste the sql query here?

in general, Druid queries use a controlled amount of memory, and if they need too much you will get a

Resource limit exceeded

error: https://druid.apache.org/docs/latest/querying/querying.html#query-errors