elasticsearch-dsl-py query formation

Question

can someone show me how to frame this example query using this dsl python module?

I have only so far something like for a portion of the query string.

from elasticsearch_dsl import Search, Q, A, query, aggs
s = Search()
s.aggs.bucket('2', 'terms', field = 'Subscriber Type', size=5)

I'm not sure how the syntax is for the rest of the query. Any help is much appreciated.

The required query construction is below.

{
   "size": 0,
   "query": {
   "filtered": {
   "query": {
    "query_string": {
      "query": "lincoln",
      "analyze_wildcard": true
    }
  },
  "filter": {
    "bool": {
      "must": [
        {
          "range": {
            "Start date": {
              "gte": 936157359664,
              "lte": 1472701359665,
              "format": "epoch_millis"
            }
          }
        }
      ],
      "must_not": []
    }
  }
}
},
 "aggs": {
 "2": {
    "terms": {
    "field": "Subscriber Type",
    "size": 5,
    "order": {
      "_count": "desc"
    }
  },
  "aggs": {
    "3": {
      "terms": {
        "field": "Start Station",
        "size": 5,
        "order": {
          "_count": "desc"
        }
       }
      }
     }
    }
   }
  }

Oleksiy · Accepted Answer · 2017-07-06 18:48:28Z

8

This should do the trick:

s = Search()
s = s.query("query_string", query="lincoln", analyze_wildcard=True)
s = s.filter("range", **{"Start date": {"gte": 936157359664, "lte": 1472701359665, "format": "epoch_millis"}})
s = s[0:0]
s.aggs.bucket("2", "terms", field="Subscriber Type", size=5)\
    .bucket("3", "terms", field="Start Station", size=5)

Note that the spaces in field names make things a tiny bit more complicated, without them you could say: s.filter("range", start_date={"gte": 936157359664, "lte": 1472701359665, "format": "epoch_millis"}).

edited Jul 6, 2017 at 18:48

Oleksiy

6,5675 gold badges44 silver badges61 bronze badges

answered Dec 15, 2016 at 5:16

Honza Král

3,03216 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

elasticsearch-dsl-py query formation

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