Disable Approximate count- Not able to receive results

I have disabled the ApproximateCountDistinct and trying to get the distinct count by scanning the full volume of data but I am not getting the results from the query

Druid Details

Druid Version - 0.22.1
Master Node - 1(8 CPU and 32 GB Memory)
Data Node -2 (16 CPU and 122 GB Memory )
Query Node -1(8 CPU , 32 GB Memory and EBS - 800 GB)
Query - select count(distinct patient_hash) from druid.drug_analyzer_mx
Number of tables is one and storage is 25.2 GiB

Broker properties
“useApproximateCountDistinct”: false

Query - select count(distinct patient_hash) from druid.drug_analyzer_mx

Hello,

What is the error you are getting?

It is getting timeout after 5 mins

This could just be a question of an undersized cluster.

We’d have to look at your segments and the segment scan times. I’d suggest running this query with a time filter to restrict the full table scan and verify if that works.

If that runs successfully, I’d scale the data nodes and possibly bring the segments to the recommended size of ~5M rows and about 300-700MB and try the full scan again.

Thanks for your response Sagar. Sorry I am new to druid and how to check segments scan time. Could you please help

Meanwhile I will try to get the segments size and will test with filter

and

I have run the query for 1 month and 1 year and it took 30s and 220s respectively but I am getting gateway time out for 2 years

Segment information

Broker Log

7418:2022-04-21T17:35:55,050 INFO [HttpClient-Netty-Worker-30] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:55.050Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/ttfb”,“value”:22117,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.181:8083”,“type”:“groupBy”}
7419:2022-04-21T17:35:58,970 INFO [HttpClient-Netty-Worker-31] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:58.969Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/ttfb”,“value”:26036,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT63072000.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.204:8083”,“type”:“groupBy”}
8204:2022-04-21T17:41:51,460 INFO [HttpClient-Netty-Worker-30] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:51.460Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/time”,“value”:378527,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.181:8083”,“type”:“groupBy”}
8205:2022-04-21T17:41:51,460 INFO [HttpClient-Netty-Worker-30] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:51.460Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/bytes”,“value”:2058390488,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.181:8083”,“type”:“groupBy”}
8206:2022-04-21T17:41:52,561 INFO [HttpClient-Netty-Worker-31] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.561Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/time”,“value”:379627,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT63072000.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.204:8083”,“type”:“groupBy”}
8207:2022-04-21T17:41:52,561 INFO [HttpClient-Netty-Worker-31] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.561Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/node/bytes”,“value”:2277425548,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:600000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“queryFailTime”:1650563132931,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT63072000.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“server”:“10.224.112.204:8083”,“type”:“groupBy”}
8208:2022-04-21T17:41:52,566 INFO [qtp757257137-129] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.566Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/cpu/time”,“value”:16382268,“context”:{“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT9223372036854775.807S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:["-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"],“numComplexMetrics”:“0”,“numDimensions”:“0”,“numMetrics”:“1”,“type”:“groupBy”}
8209:2022-04-21T17:41:52,566 INFO [qtp757257137-129] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.566Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“query/time”,“value”:379635,“context”:{“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT9223372036854775.807S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:["-146136543-09-08T08:23:32.096Z/146140482-04-24T15:36:27.903Z"],“numComplexMetrics”:“0”,“numDimensions”:“0”,“numMetrics”:“1”,“remoteAddress”:"",“success”:“true”,“type”:“groupBy”}
8210:2022-04-21T17:41:52,566 INFO [qtp757257137-129] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.566Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“sqlQuery/time”,“value”:379658,“dataSource”:"[drug_analyzer_mx]",“id”:“3336c052-7647-4baf-9236-b987e42f12df”,“nativeQueryIds”:"[0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57]",“remoteAddress”:“10.224.112.240”,“success”:“true”}
8211:2022-04-21T17:41:52,566 INFO [qtp757257137-129] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:41:52.566Z”,“service”:“druid/broker”,“host”:“10.224.112.240:8082”,“version”:“0.22.1”,“metric”:“sqlQuery/bytes”,“value”:24,“dataSource”:"[drug_analyzer_mx]",“id”:“3336c052-7647-4baf-9236-b987e42f12df”,“nativeQueryIds”:"[0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57]",“remoteAddress”:“10.224.112.240”,“success”:“true”}

Historical Log

2022-04-21T17:35:34,245 INFO [groupBy_drug_analyzer_mx_[2020-05-01T00:00:00.000Z/2020-06-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.245Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segment/time”,“value”:1306,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-05-01T00:00:00.000Z_2020-06-01T00:00:00.000Z_2022-04-19T19:46:04.970Z_2”,“type”:“groupBy”}
2022-04-21T17:35:34,245 INFO [groupBy_drug_analyzer_mx_[2020-05-01T00:00:00.000Z/2020-06-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.245Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/wait/time”,“value”:0,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-05-01T00:00:00.000Z_2020-06-01T00:00:00.000Z_2022-04-19T19:46:04.970Z_2”,“type”:“groupBy”}
2022-04-21T17:35:34,245 INFO [groupBy_drug_analyzer_mx_[2020-05-01T00:00:00.000Z/2020-06-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.245Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segmentAndCache/time”,“value”:1306,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-05-01T00:00:00.000Z_2020-06-01T00:00:00.000Z_2022-04-19T19:46:04.970Z_2”,“type”:“groupBy”}
2022-04-21T17:35:34,437 INFO [groupBy_drug_analyzer_mx_[2020-01-01T00:00:00.000Z/2020-02-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.436Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segment/time”,“value”:1498,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-01-01T00:00:00.000Z_2020-02-01T00:00:00.000Z_2022-04-19T19:13:22.226Z_4”,“type”:“groupBy”}
2022-04-21T17:35:34,437 INFO [groupBy_drug_analyzer_mx_[2020-01-01T00:00:00.000Z/2020-02-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.437Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/wait/time”,“value”:0,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-01-01T00:00:00.000Z_2020-02-01T00:00:00.000Z_2022-04-19T19:13:22.226Z_4”,“type”:“groupBy”}
2022-04-21T17:35:34,437 INFO [groupBy_drug_analyzer_mx_[2020-01-01T00:00:00.000Z/2020-02-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.437Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segmentAndCache/time”,“value”:1498,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-01-01T00:00:00.000Z_2020-02-01T00:00:00.000Z_2022-04-19T19:13:22.226Z_4”,“type”:“groupBy”}
2022-04-21T17:35:34,443 INFO [groupBy_drug_analyzer_mx_[2020-04-01T00:00:00.000Z/2020-05-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.443Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segment/time”,“value”:1505,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-04-01T00:00:00.000Z_2020-05-01T00:00:00.000Z_2022-04-19T19:35:13.716Z_1”,“type”:“groupBy”}
2022-04-21T17:35:34,444 INFO [groupBy_drug_analyzer_mx_[2020-04-01T00:00:00.000Z/2020-05-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.444Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/wait/time”,“value”:0,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-04-01T00:00:00.000Z_2020-05-01T00:00:00.000Z_2022-04-19T19:35:13.716Z_1”,“type”:“groupBy”}
2022-04-21T17:35:34,444 INFO [groupBy_drug_analyzer_mx_[2020-04-01T00:00:00.000Z/2020-05-01T00:00:00.000Z]] LoggingEmitter - {“feed”:“metrics”,“timestamp”:“2022-04-21T17:35:34.444Z”,“service”:“druid/historical”,“host”:“10.224.112.181:8083”,“version”:“0.22.1”,“metric”:“query/segmentAndCache/time”,“value”:1505,“context”:{“applyLimitPushDown”:false,“defaultTimeout”:300000,“finalize”:false,“fudgeTimestamp”:“1577836800000”,“groupByOutermost”:false,“groupByStrategy”:“v2”,“maxQueuedBytes”:5242880,“maxScatterGatherBytes”:9223372036854775807,“mergeRunnersUsingChainedExecution”:true,“queryFailTime”:1650563132937,“queryId”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“resultAsArray”:true,“sortByDimsFirst”:false,“sortResults”:false,“sqlOuterLimit”:101,“sqlQueryId”:“3336c052-7647-4baf-9236-b987e42f12df”,“timeout”:599999,“useApproximateCountDistinct”:false},“dataSource”:“drug_analyzer_mx”,“duration”:“PT60393600.001S”,“hasFilters”:“false”,“id”:“0b2ffdd5-90e1-4c4f-8c3f-4b1ae2cd6a57”,“interval”:[“2020-01-01T00:00:00.000Z/2020-08-01T00:00:00.000Z”,“2020-09-01T00:00:00.000Z/2021-12-31T00:00:00.001Z”],“numComplexMetrics”:“0”,“numDimensions”:“1”,“numMetrics”:“0”,“segment”:“drug_analyzer_mx_2020-04-01T00:00:00.000Z_2020-05-01T00:00:00.000Z_2022-04-19T19:35:13.716Z_1”,“type”:“groupBy”}