Why doesn't this Elasticsearch query return any results?

Question

Here are my mappings for index metadata

{
    "mappings": {
        "metric": {
            "properties": {
                'model_id': {"type": "string", "index": "not_analyzed"}
            }
        }
    }
 }

I can see that I have 1 document in Kibana under that index

Here is my query as a curl command:

curl -XGET 'localhost:9200/metadata/metric/_search?pretty' -H 'Content-Type: application/json' -d'
{
    "query" : {
        "constant_score" : {
            "filter" : {
                "term" : {
                    "model_id" : "2532070e-da4b-465f-ba3b-f96beaaa6d5c"
                }
            }
        }
    }
}
'

Here is what it returns:

{
  "took" : 0,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "skipped" : 0,
    "failed" : 0
  },
  "hits" : {
    "total" : 0,
    "max_score" : null,
    "hits" : [ ]
  }
}

I followed the directions in the documentation here to try and get this working:

https://www.elastic.co/guide/en/elasticsearch/guide/current/_finding_exact_values.html

Val · Accepted Answer · 2018-02-23 06:15:44Z

1

Because you're not querying the right type, you query metrics instead of metric, this should get you what you want:

curl -XGET 'localhost:9200/metadata/metric/_search?pretty' -H 'Content-Type: application/json' -d'
                                         ^
                                         |
                                   remove s here

answered Feb 23, 2018 at 6:15

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

Mark Jones Over a year ago

I had actually setup my index incorrectly. You are correct here, but it was just a typo in my stackoverflow post. I went back and confirmed I was using metric

Val Over a year ago

Gotcha, glad you figured it out

Mark Jones · Accepted Answer · 2018-02-24 04:28:27Z

0

Make sure your index is setup correctly.

answered Feb 24, 2018 at 4:28

Mark Jones

1471 gold badge3 silver badges13 bronze badges

1 Comment

Val Over a year ago

You should probably explain a bit more what you had wrong if you want your answer to be helpful to people :-)

L.Salah · Accepted Answer · 2018-02-25 15:27:20Z

0

I'm using ES 5.6.2 , try this mapping

"mappings":{
  "metric":{
     "properties":{
        "model_id":{
           "type":"string",
           "index":"not_analyzed",
           "fields":{
              "keyword":{
                 "type":"keyword",
                 "ignore_above":256
              }
           }
        }
    }
}

}

answered Feb 25, 2018 at 15:27

L.Salah

11 bronze badge

Collectives™ on Stack Overflow

Why doesn't this Elasticsearch query return any results?

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related