Reindexing Data from Druid don't update doubleSum metrics

Hi

I’m trying to re-index data from druid the data have granularity HOUR and I would like to get it DAY.
The initial data come from JSON and I’m using tranquility to index the data

the metrics definition is like this in the tranquility config file:

“metricsSpec”: [
{
“name”: “PubNet”,
“type”: “doubleSum”,
“fieldName”: “publisherNet”
},
{
“name”: “PubGross”,
“type”: “doubleSum”,
“fieldName”: “publisherGross”
},
{
“name”: “InneractiveNet”,
“type”: “doubleSum”,
“fieldName”: “iaNet”
},
{
“name”: “InneractiveGross”,
“type”: “doubleSum”,
“fieldName”: “iaGross”
},
{
“name”: “Count”,
“type”: “longSum”,
“fieldName”: “occurrences”
}

``

So from my understanding the Json file have a field name occurrences but the name in the segment created is now Count
{
“name”: “Count”,
“type”: “longSum”,
“fieldName”: “occurrences”
}

``

Now I make a batch task to re-index these data like this

“dataSchema”: {
“dataSource”: “rtEventDaily”,
“granularitySpec”: {
“type”: “uniform”,
“segmentGranularity”: “DAY”,
“queryGranularity”: “DAY”
},
“parser”: {
“type”: “hadoopyString”,
“parseSpec”: {
“format”: “tsv”,
“columns”: [
“eventType”,
“eventTimestamp”,
“publisherId”,
“contentId”,
“countryCode”,
“adNetworkId”,
“deviceOs”,
“brandName”,
“PubGross”,
“PubNet”,
“InneractiveGross”,
“InneractiveNet”,
“Count”
],
“dimensionsSpec”: {
“dimensions”: [
“eventType”,
“publisherId”,
“contentId”,
“adNetworkId”,
“countryCode”,
“deviceOs”
]
},
“timestampSpec”: {
“format”: “dd-MM-yyyy HH:mm:ss.SSS”,
“column”: “eventTimestamp”
}
}
},
“metricsSpec”: [
{
“name”: “Pub Net”,
“type”: “doubleSum”,
“fieldName”: “PubNet”
},
{
“name”: “Pub Gross”,
“type”: “doubleSum”,
“fieldName”: “PubGross”
},
{
“name”: “IA Net”,
“type”: “doubleSum”,
“fieldName”: “InneractiveNet”
},
{
“name”: “IA Gross”,
“type”: “doubleSum”,
“fieldName”: “InneractiveGross”
},
{
“name”: “Count”,
“type”: “longSum”,
“fieldName”: “Count”
}
]
},

``

Now the problem only the field Count is update all other stay at 0 I mean all doubleSum are not updated
Could you help me please

Thanks

Hi, how are you doing the batch reindexing and are you sure the name/fieldNames of the various metrics match up?

For example, I see “Pub Net” and “PubNet” in your different specs. On the ingestion side, “fieldnName” refers to the value in the raw data and “name” refers to value that will be stored in the column. On the query side, the “name” is how the field will be displayed in the result. The “fieldName” is what internally the column is called. When you go and reindex, you have to use the fieldName.

Thanks you very munch