Skip to content

Rollup visualization doesn't send timezone with range query #29797

@jen-huang

Description

@jen-huang

Kibana version: 6.5

Elasticsearch version: 6.5

Describe the bug:
Visualizing rollup index patterns from rollup jobs configured with date histogram that has any other timezone than UTC results in an error like:
Field [utc_time] in [range] query was found in rollup indices, but requested timezone is not compatible. Options include: [Asia/Tokyo]

Steps to reproduce:

  1. Create rollup job with Asia/Tokyo date_histogram time zone
  2. Run job
  3. Create rollup index pattern from new rollup index
  4. Create area chart visualization using that rollup index pattern
  5. Observe that no visualization is rendered and error appears in console

The same error occurs when sending the query from console:
image

Expected behavior:
Rollup visualization should render. We need to send rollup job configuration's timezone with the date range query.

Any additional context:
Reported via Discuss threads:
https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/5
https://discuss.elastic.co/t/rollup-search-error-with-timezone/165624

Metadata

Metadata

Assignees

No one assigned

    Labels

    Feature:AggregationsAggregation infrastructure (AggConfig, esaggs, ...)Team:VisualizationsTeam label for Lens, elastic-charts, Graph, legacy editors (TSVB, Visualize, Timelion) t//bugFixes for quality problems that affect the customer experience

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions