How to print query result of elasticsearch in python?

Question

Following query gives the vocabulary size of my document in elasticsearch:

GET my_index/my_type/_search
{
  "size": 0, 
  "aggs": {
     "vocab": {
        "cardinality": {
           "field": "text"}}}}

The output is:

{
"took": 0,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"failed": 0
},
"hits": {
"total": 84678,
"max_score": 0,
"hits": []
},
"aggregations": {
"vocab": {
"value": 178050**
  }
 }
}

Now I want to print the value of the field "value"(=178050) in python.

I wrote the following in python:

query_body={
  "size": 0, 
  "aggs": {
     "vocab": {
        "cardinality": {
           "field": "text"}}}}

res = es.search(index = INDEX_NAME, body=query_body)

How can I print that value? Thanks.

2ps · Accepted Answer · 2017-05-25 03:55:51Z

1

Given that your result dictionary looks like this:

{
    "took": 0,
    "timed_out": false,
    "_shards": {
        "total": 1,
        "successful": 1,
        "failed": 0
    },
    "hits": {
        "total": 84678,
        "max_score": 0,
        "hits": []
    },
    "aggregations": {
        "vocab": {
            "value": 178050
        }
    }
}

You can access the result like @mohammedyasin recommended:

res['aggregations']['vocab']['value']

if res is a str, you can convert it to a dictionary using json.loads

import json
res = json.loads(s)
value = res['aggregations']['vocab']['value']

answered May 25, 2017 at 3:55

2ps

16k2 gold badges34 silver badges53 bronze badges

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

1 Comment

2ps Over a year ago

Please upvote/mark as answered if the answer helped.

Mohammed Yasin · Accepted Answer · 2017-05-25 04:01:53Z

1

This is you expecting?. In python we can get the value from dict by key.

from your output:

output = {
"took": 0,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"failed": 0
},
"hits": {
"total": 84678,
"max_score": 0,
"hits": []
},
"aggregations": {
"vocab": {
"value": 178050**
  }
 }
}

print (output["aggregations"]["vocab"]["value"]) # It will print the value or use output.get("aggregations").get("vocab").get("value")
178050

edited May 25, 2017 at 4:01

answered May 25, 2017 at 3:54

Mohammed Yasin

5371 gold badge7 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to print query result of elasticsearch in python?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related