tarpdalton commented on issue #9993:
URL: https://github.com/apache/druid/issues/9993#issuecomment-640775238
I'll share my use case for segment granularity. Here is my granularity spec
for loading some data:
```json
"granularitySpec": {
"segmentGranularity": {
"type": "period",
"period": "P1D",
"timeZone": "America/New_York"
},
"queryGranularity": {
"type": "period",
"period": "P1D",
"timeZone": "America/New_York"
},
"rollup": true,
"intervals": [
"2020-05-12T00:00:00-04:00/2020-05-13T00:00:00-04:00"
]
},
```
I am rolling up in daily buckets, but offset by the timezone. The
granularity is big so the roll up is more efficient.
The event data that I am storing in druid occurs in the EST/EDT timezone.
When I query druid to see how many events happened March 12th; I want to see
events from March 12th EDT, not March 12th UTC.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
