Query timeout not working

Hi,

Not able to aggregate 1 day data in Druid. Able to fetch all data without aggregate function , but if i use aggregate function getting Request failed with status code 504 . Tried increasing timeout in query context but no use.

Same query if i use groupBy getting timeout

timeout query context parameter also not working

all queries got terminated after 30seconds

someone help how to set query timeout value

The property that comes to mind is druid.server.http.defaultQueryTimeout. Have you checked the Broker logs for any errors?

no logs in broker. also we set druid.server.http.defaultQueryTimeout druid_server_http_defaultQueryTimeout: 1500000

Hi,

please note that:

  • if it is only the groupBy queries that are timing out, you may need to investigate merge buffers and make sure that you are following the tuning recommendations noted here: Basic cluster tuning · Apache Druid

  • timeouts are set at both the historicals as well as the broker. Please check both: Configuration reference · Apache Druid

  • You may also have to look at broker backpressure as well as spill-to-disk settings

One of these should solve your issue. Please reach out if you need further help.