Visualize date histogram incorrectly set for Rollup-based visualization, causing it to fail

[cjcenizal]

This bug exists on master, possibly on older release branches too.

To reproduce:

1. Add sample data and create a rollup job with this config:

PUT _rollup/job/test
{
    "index_pattern": "k*",
    "rollup_index": "test",
    "cron": "0 * * * * ?",
    "page_size" :1000,
    "groups" : {
      "date_histogram": {
        "fixed_interval": "24h",
        "field": "order_date",
        "time_zone": "UTC"
      }
    }
}

2. Create an index pattern and a visualization. Use a date histogram visualization with a 24h interval and a time range of several days, per this screenshot:

The request will fail. Notice that the date_histogram aggregation we're sending with the request has an interval of 3h, not the 24h we specified.

If we manually fix this by setting it to 24h and send the request in Console, the request succeeds:

GET test3/_rollup_search
{
  "size":0,
  "aggregations":{
    "2":{
      "date_histogram":{
        "field":"order_date",
        "interval":"30s",
        "time_zone":"UTC",
        "min_doc_count":1
      }
    }
  },
  "query":{
    "bool":{
      "must":[
        {
          "range":{
            "order_date":{
              "format":"strict_date_optional_time",
              "gte":"2019-05-03T18:37:32.779Z",
              "lte":"2019-05-08T18:52:32.779Z"
            }
          }
        }
      ],
      "filter":[
        {
          "match_all":{

          }
        }
      ],
      "should":[

      ],
      "must_not":[

      ]
    }
  }
}

[elasticmachine]

Pinging @elastic/kibana-app

[cjcenizal]

This seems related to #34690

[cjcenizal]

This was fixed in TSVB by #36081.

[wylieconlon]

I've found the source of the bug. It's unrelated to #34690, although that is also happening at the same time. I'll have a PR up soon that fixes the issue.

[wylieconlon]

@cjcenizal Is this a bug in 7.2 as well? The current plan is to backport to 7.3

[cjcenizal]

@wylieconlon I'm not sure, would you mind downloading that version and testing?

• https://www.elastic.co/downloads/past-releases/kibana-7-2-0
• https://www.elastic.co/downloads/past-releases/elasticsearch-7-2-0

[wylieconlon]

@cjcenizal I can confirm that this is a bug in 7.2 as well.