# Exists query returns the same record more than once

**URL:** <https://discuss.elastic.co/t/exists-query-returns-the-same-record-more-than-once/3964>\
**Category:** Elasticsearch\
**Created:** [February 23, 2011, 3:34am UTC](https://discuss.elastic.co/t/exists-query-returns-the-same-record-more-than-once/3964 "2011-02-23T03:34:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![byuva](https://avatars.discourse-cdn.com/v4/letter/b/b5ac83/32.png) [@byuva](https://discuss.elastic.co/u/byuva)\
**Post date:** [February 23, 2011, 3:34am UTC](https://discuss.elastic.co/t/exists-query-returns-the-same-record-more-than-once/3964/1 "2011-02-23T03:34:37Z")

</div>

The results of the following query (when iterated) seems to return the identical record multiple times.

'{"query": {"filtered": {"filter": {"exists": {"field": "APPNAME"}}, "query": {"match\_all": {}}}}, "size": 100, "from": 0}

I am fairly confident the "\_id" is not actually in the index more than once (ie I do not play with op\_type when indexing).

I am using 0.15.0 and I believe the field APPNAME is analyzed fwiw.

-brian

---

<div class="post-metadata">

**Author:** ![Clinton\_Gormley](https://avatars.discourse-cdn.com/v4/letter/c/50afbb/32.png) [@Clinton\_Gormley](https://discuss.elastic.co/u/Clinton_Gormley)\
**Post date:** [February 23, 2011, 10:20am UTC](https://discuss.elastic.co/t/exists-query-returns-the-same-record-more-than-once/3964/2 "2011-02-23T10:20:05Z")

</div>

On Tue, 2011-02-22 at 19:34 -0800, byuva wrote:

> The results of the following query (when iterated) seems to return the  
> identical record multiple times.
> 
> '{"query": {"filtered": {"filter": {"exists": {"field": "APPNAME"}},  
> "query": {"match\_all": {}}}}, "size": 100, "from": 0}
> 
> I am fairly confident the "\_id" is not actually in the index more than once  
> (ie I do not play with op\_type when indexing).
> 
> I am using 0.15.0 and I believe the field APPNAME is analyzed fwiw.

Brian - please gist a recreation of this problem

See [Elasticsearch Platform — Find real-time answers at scale | Elastic](http://www.elasticsearch.org/help)

thanks

clint

---

<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:** [July 6, 2017, 4:11am UTC](https://discuss.elastic.co/t/exists-query-returns-the-same-record-more-than-once/3964/3 "2017-07-06T04:11:40Z")

</div>