# Query\_shard\_exception

**URL:** <https://discuss.elastic.co/t/query-shard-exception/324756>\
**Category:** Elasticsearch\
**Created:** [February 6, 2023, 5:56am UTC](https://discuss.elastic.co/t/query-shard-exception/324756 "2023-02-06T05:56:18Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tussingh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tussingh/32/116802_2.png) [@Tussingh](https://discuss.elastic.co/u/Tussingh)\
**Post date:** [February 6, 2023, 5:56am UTC](https://discuss.elastic.co/t/query-shard-exception/324756/1 "2023-02-06T05:56:18Z")

</div>

I am getting below error when I am trying to query :slight\_smile :  
{  
"error": {  
"root\_cause": [  
{  
"type": "query\_shard\_exception",  
"reason": "failed to create query: [nested] failed to find nested object under path [product]",  
"index\_uuid": "taZ8q8FPT2OTbpD4nNF\_PA",  
"index": "stores"  
}  
],  
"type": "search\_phase\_execution\_exception",  
"reason": "all shards failed",  
"phase": "query",  
"grouped": true,  
"failed\_shards": [  
{  
"shard": 0,  
"index": "stores",  
"node": "ceqDO\_ZlR06XQ-vNlnyn5A",  
"reason": {  
"type": "query\_shard\_exception",  
"reason": "failed to create query: [nested] failed to find nested object under path [product]",  
"index\_uuid": "taZ8q8FPT2OTbpD4nNF\_PA",  
"index": "stores",  
"caused\_by": {  
"type": "illegal\_state\_exception",  
"reason": "[nested] failed to find nested object under path [product]"  
}  
}  
}  
]  
},  
"status": 400

* * *

* * *

Query:  
GET stores/\_search  
{  
"query": {  
"nested": {  
"path": "product",  
"query": {  
"bool": {  
"must": [  
{"match": {"product.product.keyword": "Mustang"}}  
]  
}  
}  
}  
}  
}

* * *

cluster: Single node Cluster

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 6, 2023, 6:00am UTC](https://discuss.elastic.co/t/query-shard-exception/324756/2 "2023-02-06T06:00:50Z")

</div>

Welcome to our community! 😃

What is the mapping of the index?  
Also please format your code/logs/config using the `</>` button, or markdown style back ticks. It helps to make things easy to read which helps us help you 🙂

---

<div class="post-metadata">

**Author:** ![Tussingh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tussingh/32/116802_2.png) [@Tussingh](https://discuss.elastic.co/u/Tussingh)\
**Post date:** [February 6, 2023, 6:10am UTC](https://discuss.elastic.co/t/query-shard-exception/324756/3 "2023-02-06T06:10:05Z")

</div>

Thanks mark

here is the mapping:

```auto
{
  "stores": {
    "mappings": {
      "properties": {
        "product": {
          "properties": {
            "product": {
              "type": "text",
              "fields": {
                "keyword": {
                  "type": "keyword",
                  "ignore_above": 256
                }
              }
            },
            "quantity": {
              "type": "long"
            }
          }
        },
        "suburb": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        }
      }
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [February 6, 2023, 6:12am UTC](https://discuss.elastic.co/t/query-shard-exception/324756/4 "2023-02-06T06:12:20Z")

</div>

What version of Elasticsearch are you running?

---

<div class="post-metadata">

**Author:** ![Tussingh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tussingh/32/116802_2.png) [@Tussingh](https://discuss.elastic.co/u/Tussingh)\
**Post date:** [February 6, 2023, 4:23pm UTC](https://discuss.elastic.co/t/query-shard-exception/324756/5 "2023-02-06T16:23:44Z")

</div>

version 8.6

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [February 6, 2023, 4:45pm UTC](https://discuss.elastic.co/t/query-shard-exception/324756/6 "2023-02-06T16:45:01Z")

</div>

Can you please get the mappings from the index you are querying? The mappings you specified seem to contain a mapping conflict (`product` field mapped both as object and string), which I believe should cause an error.

---

<div class="post-metadata">

**Author:** ![Tussingh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tussingh/32/116802_2.png) [@Tussingh](https://discuss.elastic.co/u/Tussingh)\
**Post date:** [February 6, 2023, 5:29pm UTC](https://discuss.elastic.co/t/query-shard-exception/324756/7 "2023-02-06T17:29:42Z")

</div>

```auto
Mapping

PUT job 
{
  "mappings": {
    "properties": {
      "desingnation":{
        "type": "keyword"
      },
      "skills":{
        "type": "nested"
      }
    }
  }
}

Doc

```

```auto
POST job/_doc
{
  "desingnation": "ELK",
  "skills": [
    {
      "core": "developer",
      "experience": 10
    },
    {
      "core": "administrator",
      "experience": 5
    }
  ]
}

```

```auto
POST job/_doc
{
  "desingnation": "Monitoring",
  "skills": [
    {
      "core": "developer",
      "experience": 10
    },
    {
      "core": "consultant",
      "experience": 6
    }
  ]
}

```

SEARCH

```auto
GET job/_search
{
  "query": {
    "nested": {
      "path": "core",
      "query": {
        "bool": {
          "must": [
            {"match": {"skills.core.keyword": "developer"} }
          ]
        }
      }
    }
  }
}

```

ERROR

```auto
 "error": {
    "root_cause": [
      {
        "type": "query_shard_exception",
        "reason": "failed to create query: [nested] failed to find nested object under path [core]",
        "index_uuid": "mg-w1GaURISAzlDsfAxhYw",
        "index": "job"
      }
    ],
    "type": "search_phase_execution_exception",
    "reason": "all shards failed",
    "phase": "query",
    "grouped": true,
    "failed_shards": [
      {
        "shard": 0,
        "index": "job",
        "node": "ceqDO_ZlR06XQ-vNlnyn5A",
        "reason": {
          "type": "query_shard_exception",
          "reason": "failed to create query: [nested] failed to find nested object under path [core]",
          "index_uuid": "mg-w1GaURISAzlDsfAxhYw",
          "index": "job",
          "caused_by": {
            "type": "illegal_state_exception",
            "reason": "[nested] failed to find nested object under path [core]"
          }
        }
      }
    ]
  },
  "status": 400
}

```

```auto

```

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [February 6, 2023, 5:35pm UTC](https://discuss.elastic.co/t/query-shard-exception/324756/8 "2023-02-06T17:35:28Z")

</div>

In order to run a nested query you need to have it nested in your mapping as well.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 6, 2023, 5:35pm UTC](https://discuss.elastic.co/t/query-shard-exception/324756/9 "2023-03-06T17:35:51Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.