# Elasticsearch Search return blank results

**URL:** <https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311>\
**Category:** Elasticsearch\
**Created:** [April 9, 2018, 11:28am UTC](https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311 "2018-04-09T11:28:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bruce88](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@bruce88](https://discuss.elastic.co/u/bruce88)\
**Post date:** [April 9, 2018, 11:28am UTC](https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311/1 "2018-04-09T11:28:45Z")

</div>

I have an index with 1.9 billion data. When I try to do a search, it always return a blank result which is "". But the HTTP status code is 200. Then I just don't know what happens.

Did anyone ever have this problem? Or anyone knows what happens? Thanks!

My query clause is as below.

```
{
"size": 0,
"query": {
	"bool": {
		"filter": [{
			"range": {
				"timestamp": {
					"gte": 1523059200,
					"lt": 1523145600
				}
			}
		}]
	}
},
"aggs": {
	"duplications": {
		"terms": {
			"field": "hash",
			"size": 5000
		},
		"aggs": {
			"top_duplications": {
				"top_hits": {
					"size": 3
				}
			}
		}
	}
}

```

}

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [April 9, 2018, 2:50pm UTC](https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311/2 "2018-04-09T14:50:17Z")

</div>

Hey,

I assume that with `return a blink result which is ""` you mean, the number of hits is zero?

Can you change the `timestamp` query to be a date in ISO8601 format? By default the date format is also `epoch_millis` but you seem to be using epoch seconds, which means you date may be off a lot. One of the reasons why you should try using a human readable date, it is much easier to debug.

--Alex

---

<div class="post-metadata">

**Author:** ![bruce88](https://avatars.discourse-cdn.com/v4/letter/b/b3f665/32.png) [@bruce88](https://discuss.elastic.co/u/bruce88)\
**Post date:** [April 10, 2018, 6:57am UTC](https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311/3 "2018-04-10T06:57:27Z")

</div>

Hi Alex

Thanks for your reply.

Actually, this query works fine when the data is less than 10 billion. But after the data increased, it returns blank result. The blank result mean nothing, which is only an empty string. I expect to see some error information if it's failed to execute. But nothing!

Regards  
Bruce

---

<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:** [May 8, 2018, 6:57am UTC](https://discuss.elastic.co/t/elasticsearch-search-return-blank-results/127311/4 "2018-05-08T06:57:46Z")

</div>

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