Bound filter not working for double values greater than 6 digits

Hi,

When i am filtering for values with 6 digits in bound filter, i am able to fetch correct results, but when i am using 7 or more digits in bound filter i am getting blank result, but values with more than 7 digits are present in druid.

{

“version” : “v1”,

“timestamp” : “2019-01-01T08:02:00.000Z”,

“event” : {

"NodeB_P_10" : "EER",

"NodeB_P_1" : "NodeB96410",

"extract_time" : "2019-03-03T07:30:00.000Z",

"RELIABILITY_INDICATOR" : 0.0,

"AVG_NodeB_C_1" : 1.0,

"NodeB_C_1" : 2019399.0,

"COUNTER_GROUP_ID" : "NodeB_CG_1"

}

}, {

“version” : “v1”,

“timestamp” : “2019-01-01T08:02:00.000Z”,

“event” : {

"NodeB_P_10" : "EER",

"NodeB_P_1" : "NodeB96410",

"extract_time" : "2019-03-03T07:45:00.000Z",

"RELIABILITY_INDICATOR" : 0.0,

"AVG_NodeB_C_1" : 1.0,

"NodeB_C_1" : 2244514.0,

"COUNTER_GROUP_ID" : "NodeB_CG_1"

}

}, {

“version” : “v1”,

“timestamp” : “2019-01-01T08:02:00.000Z”,

“event” : {

"NodeB_P_10" : "EER",

"NodeB_P_1" : "NodeB96410",

"extract_time" : "2019-03-03T08:00:00.000Z",

"RELIABILITY_INDICATOR" : 0.0,

"AVG_NodeB_C_1" : 1.0,

"NodeB_C_1" : 2809757.0,

"COUNTER_GROUP_ID" : "NodeB_CG_1"

}

}.

Below is my json query:

{

“queryType” : “groupBy”,

“dataSource” : “NodeB”,

“granularity” : “All”,

“intervals” : [ “2019-01-01T08:02:00.000Z/2019-03-03T08:02:00.000Z” ],

“descending” : “true”,

“aggregations” : [ {

"type" : "doubleSum",

"name" : "NodeB_C_1",

"fieldName" : "NodeB_C_1"

} ],

“filter” : {

"type" : "and",

"fields" : [{

  "type" : "and",

  "dimension" : null,

  "value" : null,

  "function" : null,

  "fields" : [ {

        "type": "bound",

        "dimension": "NodeB_C_1",

        "value": null,

        "function": null,

        "fields": null,

        "lower": "2244514.0",

        "upper": null,

        "ordering": "numeric",

        "lowerStrict": null,

        "upperStrict": null,

        "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

}]

},

“dimensions” : [ {

"type" : null,

"dimension" : "COUNTER_GROUP_ID",

"outputName" : null,

"extractionFn" : null

} ]

}

Please Help!!

Thanks in Advance

Hey Amit,

You are doing a data-level bound “filter” but then showing aggregated results. Could you double check that the data itself actually has points greater than 2244514.0? Maybe try running these SQL queries to shed light on things,

SELECT * FROM NodeB WHERE NodeB_C_1 > 2244514.0

SELECT COUNTER_GROUP_ID, SUM(NodeB_C_1) FROM NodeB HAVING NodeB_C_1 > 2244514.0

Thanks a lot Gian for clearing my doubt.