Advanced query with nested object

Hi,

I have the following objects in elasticsearch:

{
  "traceID" : "27c4e73814565e74",
  "spanID" : "c957afee8a34cbf8",
  "parentSpanID" : "27c4e73814565e74",
  "flags" : 1,
  "operationName" : "InfluxService.getKnownEmployees",
  "references" : [ ],
  "startTime" : 1512984656613000,
  "startTimeMillis" : 1512984656613,
  "duration" : 15219,
  "tags" : [
        {
          "type" : "string",
          "value" : "Open Projects Tab",
          "key" : "businessTransaction"
        }
  ],
}

The problem is the data structure is defined by the tool we use to obtain traces and we cannot change it. We wrote a java program to identify and tag all traces with a business transaction name and now we want to display some charts in Grafana. But we were unable to aggregate or filter our data based on the business transaction tag. The problem is we somehow need to define a nested query or nested aggregation. Is there any way we can accomplish this with Grafana?
So far it seems as this is not possible with Lucene and Grafana but maybe I missed something?

Thanks for your support.

Regards,
Thomas

1 Like

Hi,

Grafana doesn’t support nested queries or aggregations at the moment. There’s an open issue over at Github that you can upvote.

Marcus