Hi Guys,
I am using druid's approx histogram to calculate 50, 90, 95 and 99
percentile values trying out various "resolution" value - starting from 50
right up to 50k.
What I observe is that either I get positive values close to each other
like 3.82, 3.72 etc. or just 0.0.
Here are 2 sample results.
[ {
"timestamp" : "2018-08-15T00:00:00.000Z",
"result" : {
"percentile95_total_page_load_time" : 3832.3792,
"total_count" : 1.25911643E8,
"median_total_page_load_time" : 3831.9978,
"total_page_load_time" : {
"breaks" : [ -2.55716491264E11, 0.0, 2.55716491264E11, 5.11432982528E11,
7.67149473792E11, 1.022865965056E12, 1.27858245632E12, 1.534298947584E12 ],
"counts" : [ 1.0, 1.25909888E8, 0.0, 0.0, 0.0, 0.0, 1.0 ]
},
"percentile99_total_page_load_time" : 3832.4082,
"min_total_page_load_time" : 0.0,
"max_total_page_load_time" : 1.53429895E12
}
} ]
[ {
"timestamp" : "2018-08-15T00:00:00.000Z",
"result" : {
"percentile95_total_page_load_time" : 0.0,
"total_count" : 1.25911643E8,
"median_total_page_load_time" : 0.0,
"total_page_load_time" : {
"breaks" : [ -2.55716491264E11, 0.0, 2.55716491264E11, 5.11432982528E11,
7.67149473792E11, 1.022865965056E12, 1.27858245632E12, 1.534298947584E12 ],
"counts" : [ 0.0, 1.25909888E8, 0.0, 0.0, 0.0, 0.0, 1.0 ]
},
"percentile99_total_page_load_time" : 0.0,
"min_total_page_load_time" : 0.0,
"max_total_page_load_time" : 1.53429895E12
}
} ]
When the "breaks", and "counts" arrays are the same, I am unable to
understand why the percentile values are different (ex:
percentile95_total_page_load_time is 3832.3792 the first time and 0.0 the
next time).
Can anyone help with this?
Druid version we are using is 0.9.2 and will be upgrading shortly to Imply
2.6.x which I believe is based on druid 0.12.0.
