# Visualizing rollup index with timezone result in error
**URL:** https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064
**Category:** Kibana
**Created:** [December 2, 2018, 11:52pm UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064 "2018-12-02T23:52:51Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@kareyama](https://discuss.elastic.co/u/kareyama)
#### Post date: [December 2, 2018, 11:52pm UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/1 "2018-12-02T23:52:51Z")
Hi, I'd like to use Rollup index in visualize but when I set timezone:Japan in rollup jobs, it result in error .
Here is how I work for.
ES 6.5
Windows10
1 Get Kibana Sample Data "Sample eCommerce orders"
2 Management \> Rollup Job \> Create new job as below and start it.
・Index pattern: kibana\_sample\*
・Rallup index name: rollup\_sample
・Schedule: minute
・Interval: 24h
・Time zone: Japan
・Timestamp: order\_date
3 Management \> Index pattern \> create new pattern \> Rollup index \> create "rollup\_sample" pattern with setting timestamp:"order\_date".
4 Visualize \> New \> Line \> set X-axis: "Date histogram" and apply.
→cause an error.
Rollup search error: [illegal\_argument\_exception] There is not a rollup job that has a 2018-12-02 23:52:51 agg on field [order\_date] which also satisfies all requirements of query.
Is this a bug?
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [December 4, 2018, 12:45am UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/2 "2018-12-04T00:45:25Z")
Hi there, thank you for reporting this to us. I'm one of the engineers who worked on this feature. I'm able to reproduce what you're seeing. It does sound like a bug at first glance but I'm going to dig into it first and I'll let you know what I discover.
Thanks,
CJ
---
### Author:  [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [December 4, 2018, 7:02pm UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/3 "2018-12-04T19:02:24Z")
I've spoken with the ES engineers working on this and it does indeed look like a bug. Thanks again for reporting this. I've created an issue which you can follow to stay on top of progress: [https://github.com/elastic/elasticsearch/issues/36229](https://github.com/elastic/elasticsearch/issues/36229)
CJ
---
### Author:  [@polyfractal](https://discuss.elastic.co/u/polyfractal)
#### Post date: [December 4, 2018, 10:29pm UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/4 "2018-12-04T22:29:36Z")
Hi @kareyama, thanks for the bug report (and sorry you ran into this bug!)
I just opened a PR to fix this ([https://github.com/elastic/elasticsearch/pull/36237](https://github.com/elastic/elasticsearch/pull/36237)). In the mean time, if you change your rollup job to use `Asia/Tokyo` instead of `Japan`, I believe everything should work for you.
The issue is that the `Japan` timezone is technically deprecated by the standards committee in charge of timezones. So internally the query translates `Japan` into `Asia/Tokyo`. But we had a bug where Rollup didn't do the same translation, which caused the problem.
Once the PR bugfix merges it shouldn't matter as we will do the translation in Rollup as well.
---
### Author:  [@kareyama](https://discuss.elastic.co/u/kareyama)
#### Post date: [December 6, 2018, 3:49am UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/5 "2018-12-06T03:49:01Z")
Thank you tow for quick response.
I tryed "Asia/Tokyo" instead of "Japan" but the visualize returned an another error.
Rollup search error: [illegal\_argument\_exception] Field [@timestamp] in [range] query was found in rollup indices, but requested timezone is not compatible. Options include: [Asia/Tokyo]
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [January 3, 2019, 3:49am UTC](https://discuss.elastic.co/t/visualizing-rollup-index-with-timezone-result-in-error/159064/6 "2019-01-03T03:49:07Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.