Elasticsearch aggregation query in elastic.js

Question

I have a hard time translating aggregation query for elastic search into elastic.js. I am reading the documentation but I just can not figure it out. And the examples that you can find online are mostly about deprecated facets feature, that is not very useful. The JSON for example aggregation is as follows:

{
  "aggs": {
    "foo": {
      "filter": {
        "bool": {
          "must": [
            {
              "query": {
                "query_string": {
                  "query": "*"
                }
              }
            },
            {
              "terms": {
                "shape": [
                  "wc"
                ]
              }
            }
          ]
        }
      },
      "aggs": {
        "field": {
          "terms": {
            "field": "shape",
            "size": 10,
            "exclude": {
              "pattern": []
            }
          }
        }
      }
    }
  },
  "size": 0
}

I am not es expert so I am sending the query to it to see it it is valid and yes it is valid and working as expected, where as the query proposed by Or Weinberger does not work. As I understand it to have filter for your aggregation, it has to be 'in side' of the aggregation. Where as the 'query' filed is out side of it but it has bit different syntax than filter one. — Tomasz Swider
– Tomasz Swider, Commented Dec 31, 2015 at 20:55

ChintanShah25 · Accepted Answer · 2015-12-31 21:29:35Z

2

This is how you would nest terms aggregation into filter aggregation with elasticjs

ejs.Request()
    .size(0)
    .agg(ejs.FilterAggregation("foo").filter(ejs.BoolFilter()
            .must(ejs.TermsFilter('shape', 'wc'))
            .must(ejs.QueryFilter(ejs.QueryStringQuery().query("*"))))
              .agg(ejs.TermsAggregation("field").field("shape").size(10).exclude("my_pattern"))
        )

BTW you are filtering on shape and then doing aggregations on it. I am not sure what exactly you are trying.

I found their documentation pretty good, Also they have a great tool to check if your query is valid and right. This would help you a lot

Hope this helps!!

edited Dec 31, 2015 at 21:29

answered Dec 31, 2015 at 18:28

ChintanShah25

12.7k3 gold badges45 silver badges44 bronze badges

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

4 Comments

Tomasz Swider Over a year ago

So it is not 100 % what I need it pointed me in right direction.

Tomasz Swider Over a year ago

So is it possible to express the original query in elastic.js ?

ChintanShah25 Over a year ago

It is possible, I have edited my answer pls have a look, also query string is not necessary, it is selecting everything

Tomasz Swider Over a year ago

Thanks for the tool thing it is very useful

Or Weinberger · Accepted Answer · 2015-12-31 16:38:23Z

0

It seems like you have misplaced your query under the aggs element. Try this:

{
  "size": 0,
  "query": {
    "bool": {
      "must": [
        {
          "query": {
            "query_string": {
              "query": "*"
            }
          }
        },
        {
          "terms": {
            "shape": [
              "wc"
            ]
          }
        }
      ]
    }
  },
  "aggs": {
    "foo": {
      "terms": {
        "field": "shape",
        "size": 10,
        "exclude": {
          "pattern": []
        }
      }
    }
  }
}

answered Dec 31, 2015 at 16:38

Or Weinberger

7,51223 gold badges73 silver badges117 bronze badges

1 Comment

Tomasz Swider Over a year ago

So I have tried that ( elasticsearch 1.7 ) and it is returning "error": "SearchPhaseExecutionException[Failed to execute phase [query], it is working when I replace root level 'query' with 'filter'. Anyway the question was about elastic.js syntax

Collectives™ on Stack Overflow

Elasticsearch aggregation query in elastic.js

2 Answers 2

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related