i am having the same problem
filter" : {
“type” : “and”,
“fields” : [ {
“type” : “and”,
“dimension” : null,
“value” : null,
“function” : null,
“fields” : [ {
“type” : “bound”,
“dimension” : “metric_name”,
“value” : null,
“function” : null,
“fields” : null,
“lower” : null,
“upper” : “104852865”,
“ordering” : “numeric”,
“lowerStrict” : null,
“upperStrict” : true,
“intervals” : null,
“field” : null,
“values” : null,
“pattern” : null
} ],
“lower” : null,
“upper” : null,
“ordering” : null,
“lowerStrict” : null,
“upperStrict” : null,
“intervals” : null,
“field” : null,
“values” : null,
“pattern” : null
}]
}
providing this value as upper bound gives me blank result 104852865 when upperStrict is set to true, though i have values less than 104852865 in the datasource.
And the same query works fine and gives me result if i set upperStrict to false.
Also, if i set the upper value to 104852869, it works fine. But the upper value is selected via UI-User.
The druid version is 0.10.