Elasticsearch: Simple query not matching fields

Question

I want to query an elastic index with the simple query syntax.

My query:

{
  "query": {
    "simple_query_string" : {
        "query": "25",
        "fields" : ["product.size"]
    }
  }
}

is returning no results, altough there is an entry with the matching value in the field:

{
  "took" : 869,
  "timed_out" : false,
  "_shards" : {
    "total" : 2,
    "successful" : 2,
    "failed" : 0
  },
  "hits" : {
    "total" : 97241,
    "max_score" : 1.8576174,
    "hits" : [
      {
        "_index" : "deviceinformation",
        "_type" : "deviceinfo",
        "_id" : "314043",
        "_score" : 1.8576174,
        "_source" : {
          "baseinfo" : {
            "material_no" : "314043",
            "dimensional_drawing_nr" : "118600"
          },
          "product" : {
            "size" : "25",
            "range" : "I",
            "type" : "MAC"
          }
      }]
}

What am I doing wrong?

EDIT: I am using Elassandra 5.5.0.18 = Elasticsearch 5.5.0 + Cassandra 3.11.2 Excerpt from the mapping:

{
  "deviceinformation" : {
    "mappings" : {
      "deviceinfo" : {
          "product" : {
            "type" : "nested",
            "cql_collection" : "singleton",
            "cql_udt_name" : "product",
            "properties" : {
              "base_size" : {
                "type" : "keyword",
                "cql_collection" : "singleton"
              },
              "pressure_stage" : {
                "type" : "keyword",
                "cql_collection" : "singleton"
              },
              "range" : {
                "type" : "keyword",
                "cql_collection" : "singleton"
              },
              "size" : {
                "type" : "keyword",
                "cql_collection" : "singleton"
              },
              "type" : {
                "type" : "keyword",
                "cql_collection" : "singleton"
              }
            }
          }
}

Can you post mapping for the index and ES version you are using. Query is working fine for me. — Akash Yadav
– Akash Yadav, Commented Jul 10, 2018 at 12:05

Akash Yadav · Accepted Answer · 2018-07-10 13:26:35Z

1

try this

or this should work

{
  "query": {
    "nested": {
      "path": "product",
      "query": {
        "match": {
          "proucts.size" : "25"
        }
      }
    }
  }
}

edited Jul 10, 2018 at 13:26

answered Jul 10, 2018 at 12:42

Akash Yadav

8717 silver badges11 bronze badges

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

2 Comments

Akash Yadav Over a year ago

Haven't tried. Little busy right now. Will happy to hear your feedback thanks.

Alex Tbk Over a year ago

Nope - no results

Alex Tbk · Accepted Answer · 2018-07-10 13:23:55Z

0

This one works:

{
    "query": {
        "nested": {
            "path": "product",
            "query": {
                "match": {
                    "product.size": "25"
                }
            }
        }
    }
}

answered Jul 10, 2018 at 13:23

Alex Tbk

2,1142 gold badges22 silver badges47 bronze badges

3 Comments

Akash Yadav Over a year ago

Yeah also corrected my answer. Somehow missed to add "products" key name.

Alex Tbk Over a year ago

Thank you. But why is the simple one failing?

Akash Yadav Over a year ago

Because of mapping. Mapping of products is defined as nested mapping.

Collectives™ on Stack Overflow

Elasticsearch: Simple query not matching fields

2 Answers 2

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related