Level aggregations on the metrics during realtime ingestion

Hi All ,

Can we give “level aggregations” during realtime ingestion of the data to druid using Realtime ingestion task

**for example : **

what if I want doublesum aggregator for the field “Tipcharge” at the level of lets say one of my dimension column ? Is there a way we can do it ?

“metricsSpec” : [

{

    "name": "count_ingested_druid",

    "type": "count"

  },

  {

    "name": "tripcharge_sum",

    "fieldName": "Tipcharge",

    "type": "doubleSum"

  }

]

Thanks,

Anoosha

Any takes on this question anyone ?

Thanks,

Anoosha

Hi Anoosha,

Your metrics spec looks correct for Kafka Indexing Task.

Thanks & Regards,

Vikram

Hi Vikram ,

Sure .

like above my metric tripcharge_sum will be aggregated at all the dimensions given in the spec , is there a way I can specify only one or two columns for this Tipcharge to be aggregated on ???

is it possible during ingestion ? or is it possible after ingestion in pivot layer ?

Thanks,

Anoosha