Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Lens] Time shift doesn't work on epoch_millis dates #119444

Closed
flash1293 opened this issue Nov 23, 2021 · 1 comment · Fixed by #119504
Closed

[Lens] Time shift doesn't work on epoch_millis dates #119444

flash1293 opened this issue Nov 23, 2021 · 1 comment · Fixed by #119504
Assignees
Labels
bug Fixes for quality problems that affect the customer experience Feature:Lens impact:high Addressing this issue will have a high level of impact on the quality/strength of our product. Team:Visualizations Visualization editors, elastic-charts and infrastructure

Comments

@flash1293
Copy link
Contributor

Kibana version: 7.15

Describe the bug: Time shift fails if some documents in the index are using epoch_millis dates

Screenshot 2021-11-23 at 11 50 09

Steps to reproduce:

PUT /test
{
  "settings" : {
    "index" : {
      "number_of_shards" : 1,
      "number_of_replicas" : 0,
      "refresh_interval" : "1s"
    }
  },
  "mappings" : {
    "dynamic" : "strict",
    "date_detection" : false,
    "properties" : {
      "timestamp" : {
        "type" : "date",
        "format" : "epoch_millis"
      }
    }
  }
}
POST test/_doc/
{
  "timestamp": 1636749579080
}

Screenshot 2021-11-23 at 11 50 27

Any additional context:

https://discuss.elastic.co/t/error-when-using-lens-with-time-shift/289802/3

This is happening because the filter building logic is not setting the "format": "strict_date_optional_time" property of the range filter.

Right now the only workaround is to only use time shift with strict_date_time dates.

@flash1293 flash1293 added bug Fixes for quality problems that affect the customer experience Team:Visualizations Visualization editors, elastic-charts and infrastructure Feature:Lens impact:high Addressing this issue will have a high level of impact on the quality/strength of our product. labels Nov 23, 2021
@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-vis-editors @elastic/kibana-vis-editors-external (Team:VisEditors)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Fixes for quality problems that affect the customer experience Feature:Lens impact:high Addressing this issue will have a high level of impact on the quality/strength of our product. Team:Visualizations Visualization editors, elastic-charts and infrastructure
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants