This message was deleted.

Hi Ganesh, Although it is listed in the docs in the ingestion section, you should be able to use it for straight querying. You can either run it from the web console Query tab or through the MSQ Task API (and download results after the job finishes) Either way just add

"sqlJoinAlgorithm": "sortMerge"

into the query context to use the sort merge logic, otherwise it should use the standard broadcast/hash method.

Thanks! Will try this out. For some reason I don't see the MSQ engine option in my 0.25 druid cluster.

You may still need to add it in as an extension:

druid.extensions.loadList=["druid-histogram", "druid-datasketches", "druid-kafka-indexing-service", "imply-utility-belt", "druid-multi-stage-query", "imply-sql-async"]

Let me try. Thanks for the quick reply.