Druid SQL 504 timeout error while using GroupBy

Hi All, I am getting 504 error while using Druid SQL, I am doing a group by operation on about 5 Billion data points. I have tried changing the druid.server.http.defaultQueryTimeout parameter to about some minutes in broker config, but it still times out in just 30 seconds. Any suggestions, please?

1 Like

Hi Ankit_Kharb,

Welcome to the Druid forum.

I think one of your subqueries may be timing out, What is the timeout period configured in your historicals? You might also find some more information in the broker logs if they are accessible to you.

Thanks!