Convert Elasticsearch JSON query into C# NEST

Question

I have an Elasticsearch database and I have an index test

Here the schema:

PUT test
{
    "settings" : {
        "number_of_shards" : 1
    },
    "mappings" : {
        "channel" : {
            "properties" : {
                "id" : { "type" : "integer" },
                "name" : { "type" : "string" }
            }
        },
        "segment" : {
            "properties" : {
                "groupid" : { "type" : "text", "fielddata": true  },
                "instrName" : { "type" : "text", "fielddata": true },
                "channelList" : { "type" : "object" }
            }
        }
    }
}

I'd like to convert this query into C# NEST code:

 GET /test/segment/_search
    {
      "aggs": {
        "agg": {
          "terms": {
            "field": "instrName"
          },
          "aggs": {
            "agg2": {
              "terms": {
                "field": "groupid"
              }
            }
          }
        }
      }
}

I know how to convert a single aggregation query but not a nested aggregation

EDIT

Here the current code but I get a 500 error from ES

    var res = elastic.Search<SegmentRecord>(
        s => s.Index(esIndex).Aggregations(a => a.Terms("instrName", x => x.Aggregations(w => w.Terms("groupid", sel => sel)))));

Take a look at the nested aggregation usage example: elastic.co/guide/en/elasticsearch/client/net-api/current/… — Russ Cam
– Russ Cam, Commented Jun 29, 2017 at 20:59

Russ Cam · Accepted Answer · 2017-07-01 01:07:48Z

1

You haven't specified the field that each terms aggregation should run on. A terms aggregation with a terms sub aggregation looks like

var res = elastic.Search<SegmentRecord>(s => s
    .Index(esIndex)
    .Aggregations(a => a
        .Terms("agg", t => t
            .Field("instrName")
            .Aggregations(sa => sa
                .Terms("agg2", tt => tt
                    .Field("groupid")
                )
            )
        )
    )
);

answered Jul 1, 2017 at 1:07

Russ Cam

126k34 gold badges211 silver badges275 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert Elasticsearch JSON query into C# NEST

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related