# Parse Failure \[No mapping found for \[@timestamp\] in order to sort on

**URL:** <https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698>\
**Category:** Elasticsearch\
**Created:** [December 1, 2016, 1:49am UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698 "2016-12-01T01:49:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![negar](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@negar](https://discuss.elastic.co/u/negar)\
**Post date:** [December 1, 2016, 1:49am UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/1 "2016-12-01T01:49:40Z")

</div>

Hi,

I have been trying to use the following query to get data back, sorted by @timestamp:

```
var my_indices=["news","oct", "finance", "othernews","bing","reports","fda",
"research","twitter","facebook","indeed","discussion","craigslist","jobs", "newsfeed"];

       query = {
        size: 1000,
        from: 1,
        "query": {
            "indices": {
                "indices":my_indices,
                "query": {
                  "query_string": {
                    "query": event.term,
                     "default_operator":"OR"
                  }
                },
                "no_match_query": "none"
              }
        },
        "aggs": {
          "types": {
            "terms": {
              "field": "datasource",
              size:0
            }
          }
          
        },
        "sort" : [
            { "@timestamp" : {"order" : "desc"}
            }
        ]
    };

```

This is the error, I get though (I am using AWS ElasticSearch with ES version 1.5):

```
 {"took":324,"timed_out":false,"_shards":{"total":426,"successful":425,"failed":1,"failures":[{"index":".kibana-4","shard":0,"status":400,"reason":"SearchParseException[[.kibana-4][0]: query[MatchNoDocsQuery],from[1],size[1000]: Parse Failure [Failed to parse source [{\"size\":1000,\"from\":1,\"query\":{\"indices\":{\"indices\":[\"news\",\"oct\",\"finance\",\"othernews\",\"bing\",\"reports\",\"fda\",\"research\",\"twitter\",\"facebook\",\"indeed\",\"discussion\",\"craigslist\",\"jobs\"],\"query\":{\"query_string\":{\"query\":\"my search term\",\"default_operator\":\"OR\"}},\"no_match_query\":\"none\"}},\"aggs\":{\"types\":{\"terms\":{\"field\":\"datasource\",\"size\":0}}},\"sort\":[{\"@timestamp\":{\"order\":\"desc\"}}]}]]]; nested: SearchParseException[[.kibana-4][0]: query[MatchNoDocsQuery],from[1],size[1000]: Parse Failure [No mapping found for [@timestamp] in order to sort on]]; "}]},"hits":{"total":4177,"max_score":nu ...

```

Based on what was suggested on [this post](http://stackoverflow.com/questions/17051709/no-mapping-found-for-field-in-order-to-sort-on-in-elasticsearch) , I tired both of the following:

1. Adding "ignore\_unmapped" : true
2. Adding "unmapped\_type" : "long"

Both of which get rid of the error, but the results that come back are still not sorted.

I have some questions here:

1. ElasticSearch is trying to search within .kibana-4 index, while I have explicitly specified the indices it should search and set "no\_match\_query"to"none". How is that happening? Am I missing something?

2. Is there any other way for me to explicitly eliminate searching within Kibana index?

3. What else can I do to get this query to work?

I truly appreciate any help.  
Thanks

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [December 1, 2016, 11:32am UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/2 "2016-12-01T11:32:46Z")

</div>

Normally the list of indices you wish to query is passed as part of the search request (ie. outside of the JSON body).

---

<div class="post-metadata">

**Author:** ![negar](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@negar](https://discuss.elastic.co/u/negar)\
**Post date:** [December 1, 2016, 6:02pm UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/3 "2016-12-01T18:02:03Z")

</div>

I am not sure how to do so. Can you please elaborate a little bit more? I am using Node.js 4.3. Here is how I am sending the search request (using the query mentioned above):

```
var options={
        hostname: 'search-dev-compete-search-my_elastic_search_instance.us-east-1.es.amazonaws.com',
        port: 80,
        path: '/_search',
        method: 'POST',
        headers: {
            'accept': 'application/json'
        }
    };

const req = http.request(options, function(res){
     var body = '';
    res.setEncoding('utf8');
    res.on('data', function(chunk){
        body += chunk;
        
    });
    res.on('end', function(){
        // If we know it's JSON, parse it
        if (res.headers['content-type'] === 'application/json') {
            body = JSON.parse(body);
        }
        callback(null, body);
    });
});
req.on('error', callback);
req.write(JSON.stringify(query)); // This is the query mentioned in the first post
req.end();

```

};

---

<div class="post-metadata">

**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\
**Post date:** [December 1, 2016, 9:44pm UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/4 "2016-12-01T21:44:39Z")

</div>

Not used the JS client but the path is normally:  
/[index names here....]/\_search

---

<div class="post-metadata">

**Author:** ![negar](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@negar](https://discuss.elastic.co/u/negar)\
**Post date:** [December 1, 2016, 9:46pm UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/5 "2016-12-01T21:46:27Z")

</div>

Thank you very much 🙂

---

<div class="post-metadata">

**Author:** ![negar](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@negar](https://discuss.elastic.co/u/negar)\
**Post date:** [December 1, 2016, 9:47pm UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/6 "2016-12-01T21:47:55Z")

</div>

My issue was in the client side! The query is working fine, just by adding "ignore\_unmapped" : true or "unmapped\_type" : "long", the sorting will work.

---

<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:** [December 29, 2016, 9:47pm UTC](https://discuss.elastic.co/t/parse-failure-no-mapping-found-for-timestamp-in-order-to-sort-on/67698/7 "2016-12-29T21:47:54Z")

</div>

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