# Kibana Discover not showing data for any time range **URL:** \ **Category:** Kibana\ **Created:** [December 20, 2019, 5:10am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597 "2019-12-20T05:10:50Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [December 20, 2019, 5:10am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/1 "2019-12-20T05:10:50Z")
I have an index with timestamp field mapping as following: ``` "@timestamp": { "type": "date", "format": "EEE, dd MMM YYYY HH:mm:ss z" } ``` `@timestamp` field in document shows `"@timestamp" : "Wed, 26 Sep 2018 11:55:41 GMT"`. When I create an index pattern for this index and and choose Time Filter field name as @timestamp, with default type as date, Kibana discover does not show any result. How can I get it to work? ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [December 20, 2019, 1:16pm UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/2 "2019-12-20T13:16:16Z")
Can you check to see how the date was ingested in Elasticsearch? Easiest way to do is to go in Dev Tools / Console in Kibana and run that default query from there, it should show you docs in ES. ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [December 23, 2019, 5:20am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/3 "2019-12-23T05:20:03Z")
Hello @Marius_Dragomir, What do you mean by default query? I queried a document of index `temp-http` and the output of `GET /temp-http/_doc/D0u8FWYB-0GCY8C8HHdq` is: ``` { "_index" : "temp-http", "_type" : "_doc", "_id" : "D0u8FWYB-0GCY8C8HHdq", "_version" : 1, "_seq_no" : 39600, "_primary_term" : 1, "found" : true, "_source" : { "response_time" : "162", "@timestamp" : "Wed, 26 Sep 2018 11:55:41 GMT", "deviceId" : "", "url" : "", "response_code" : "200", "response_msg" : "OK", "request_type" : "GET", "response" : "", "request" : "", "uid" : "" } } ``` ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [January 6, 2020, 11:28am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/4 "2020-01-06T11:28:17Z")
Hello @Marius_Dragomir, Please help. ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [January 16, 2020, 6:07am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/5 "2020-01-16T06:07:42Z")
I have another index `http-logs` with timestamp field mapping as following: ``` "@timestamp": { "type": "date", "format": "MMM dd, yyyy HH:mm:ss.SSS" } ``` Kibana discover shows data for this index with @timestamp type as date for the index pattern. It seems like there is issue with the timestamp format used for the index `temp-http` but I can't figure it out. ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [January 28, 2020, 11:52am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/6 "2020-01-28T11:52:33Z")
All the data seems from 2018, based on that timestamp. On the top right of DIscover or visualization page there is a time picker which by default is set to "Last 15 minutes", hence Kibana will show no results. Change that to something that will fit your data(something like "Last 5 years") and this way you will see your documents. ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [January 29, 2020, 4:13am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/7 "2020-01-29T04:13:36Z")
Hello @Marius_Dragomir > [@Marius\_Dragomir](#): > > All the data seems from 2018, based on that timestamp All the data isn't from 2018. Changing the search time to 5 years didn't work. The issue started on 11th December when I upgraded Elasticsearch and Kibana to 7.4.0 from 6.8.3. Index `temp-http` has been present since the beginning with the timestamp field format as "EEE, dd MMM YYYY HH:mm:ss z". But after the upgrade, it doesn't seem to work in Kibana discover. On the other hand, I created index `http-logs` after the upgrade with timestamp field format as "MMM dd, yyyy HH:mm:ss.SSS" and it works. Not sure what got messed up. ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [January 29, 2020, 11:00am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/8 "2020-01-29T11:00:48Z")
It's probably due to the breaking changes in ES 7.0 regarding the transition from Joda time to Java time: [https://www.elastic.co/guide/en/elasticsearch/reference/current/breaking-changes-7.0.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/breaking-changes-7.0.html) ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [January 29, 2020, 11:27am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/9 "2020-01-29T11:27:33Z")
Yes, seems like it. But how do I fix this because I can't re-index `temp-http` to a new index with timestamp format based on Java time due to format mismatch? ---
**Author:** ![sharry007](https://avatars.discourse-cdn.com/v4/letter/s/d07c76/32.png) [@sharry007](https://discuss.elastic.co/u/sharry007)\ **Post date:** [January 30, 2020, 6:10am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/10 "2020-01-30T06:10:02Z")
I followed this: > [@Issue with date format change while reindexing](https://discuss.elastic.co/t/issue-with-date-format-change-while-reindexing/169590/10): > > The source and destination are in yyyy-mm-dd format so to have a uniform data format we are looking for this change. we do have some other fields with changes in mappings and settings so we would like to do all the changes in one shot by doing reindexing And I tried to create an ingest pipeline like following for re-indexing: ``` POST _ingest/pipeline/_simulate { "pipeline" :{ "description": "date pipeline ", "processors": [ { "script": { "source": """ SimpleDateFormat format = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss Z"); ctx._source['@timestamp'] = format.format(format.parse(ctx._source['@timestamp'])); """ } } ]}, "docs": [ { "_index" : "temp-http", "_type" : "_doc", "_id" : "ROhMSGgBnWcQaR3FnxJ2", "_version" : 2, "found" : true, "_source" : { "response_time" : "175", "@timestamp" : "Sun, 13 Jan 2019 17:40:07 GMT" } } ] } ``` But it gives `"class java.lang.Integer cannot be cast to class java.lang.Long (java.lang.Integer and java.lang.Long are in module java.base of loader 'bootstrap')"`. What should I change to make this work? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [February 27, 2020, 6:17am UTC](https://discuss.elastic.co/t/kibana-discover-not-showing-data-for-any-time-range/212597/11 "2020-02-27T06:17:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.