Discover's Date histogram disappears at "presence of null values"

Hi,

I recently upgraded to the brand new ELK version 7.5, everything is working great except one annoying issue at the Discover's Pane:

I have an Index which contains 2 years worth of data, each document is timestamped (using the Date field), but documents before a specific date have missing/null values in one of the fields (which is not the Date field).

Whenever i set the Date's range to show data with documents that have null-value in the specific field, the Date histogram (at the top of the Discover's Pane) suddenly disappears.

In other words, the Date histogram is showing only when i filter the index to show only documents with existing value at the specific field.

I couldn't find any setting to solve this in the documentation.
Before the upgrade i was using ELK version 6.5 and i had no problem of this kind.

Thanks.

Hey @tomervain, I'm having trouble replicating what you're seeing. Do you have any "filters" specified for Discover?

Also, if you wouldn't mind clicking the "Inspect" header button, selecting the "Request" tab, and then copying the query and posting it here, it'll help us diagnose further:

Hey @Brandon_Kobel, i don't have any filters enabled.
As you requested, the Request is:

{
  "version": true,
  "size": 500,
  "sort": [
    {
      "Date": {
        "order": "desc",
        "unmapped_type": "boolean"
      }
    }
  ],
  "_source": {
    "excludes": []
  },
  "aggs": {
    "2": {
      "date_histogram": {
        "field": "Date",
        "calendar_interval": "1d",
        "time_zone": "Asia/Jerusalem",
        "min_doc_count": 1
      }
    }
  },
  "stored_fields": [
    "*"
  ],
  "script_fields": {},
  "docvalue_fields": [
    {
      "field": "Date",
      "format": "date_time"
    }
  ],
  "query": {
    "bool": {
      "must": [],
      "filter": [
        {
          "match_all": {}
        },
        {
          "range": {
            "Date": {
              "format": "strict_date_optional_time",
              "gte": "2018-12-16T17:11:31.000Z",
              "lte": "2019-12-16T17:11:31.000Z"
            }
          }
        }
      ],
      "should": [],
      "must_not": []
    }
  },
  "highlight": {
    "pre_tags": [
      "@kibana-highlighted-field@"
    ],
    "post_tags": [
      "@/kibana-highlighted-field@"
    ],
    "fields": {
      "*": {}
    },
    "fragment_size": 2147483647
  }
}

I hope it helps...

Thanks!

I believe this is https://github.com/elastic/kibana/issues/52152 which will be fixed starting in 7.5.1

Seems to be the same issue. Thanks!

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