We are looking to improve query response timings on our druid cluster. Right now some queries take thousands of milliseconds to respond. We expect them to be <1s just as what druid describes normal value of ‘query/time’ to be. We are not sure if its the type of queries we have or the cluster configuration thats needs to be addressed to improve response timings. Any guidance from folks here is appreciated.
Please find attached files for containing the query, peon task log and broker log and config info.
I will be happy to provide more information.
query.txt (2.85 KB)
broker.txt (18.4 KB)
indexer-peon.txt (13.6 KB)
important-configs.txt (1.63 KB)