You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@streampipes.apache.org by "SvenO3 (via GitHub)" <gi...@apache.org> on 2023/02/15 12:51:34 UTC
[I] Using wrong time window when aggregating by day (streampipes)
SvenO3 opened a new issue, #1292:
URL: https://github.com/apache/streampipes/issues/1292
### Apache StreamPipes version
dev (current development state)
### Affected StreamPipes components
Processing Elements
### What happened?
When aggregating a field over 1 day in the Data Explorer, it uses the wrong time window to aggregate this field. When using data within the CET time zone and you try to aggregate them, it uses the time window from 1:00 a.m. on his day to 1:00 am on the next day, which is probably the the time window of this day in UTC.
### How to reproduce?
Load this [data](https://github.com/apache/streampipes/files/10742814/test.csv) into StreamPipes.
When looking at the raw data you will see that the values are just the current number of hours of this day for every half hour (This may depend on your current timezone):
But when you aggregate the values for every day, you can see that the first value of the day is 1 and the last value is 0.5. And a day appears for which normally no data exist:
### Expected behavior
The problem is probably that the UTC time is used to aggregate the data. While the raw data is displayed depending on your current time zone.
### Additional technical information
_No response_
### Are you willing to submit a PR?
None
--
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.
To unsubscribe, e-mail: issues-unsubscribe@streampipes.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Using wrong time window when aggregating by day (streampipes)
Posted by "SteveYurongSu (via GitHub)" <gi...@apache.org>.
SteveYurongSu commented on issue #1292:
URL: https://github.com/apache/streampipes/issues/1292#issuecomment-1452265817
Let me take a look at this issue :)
--
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.
To unsubscribe, e-mail: issues-unsubscribe@streampipes.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] Using wrong time window when aggregating by day
Posted by "tenthe (via GitHub)" <gi...@apache.org>.
tenthe closed issue #1292: Using wrong time window when aggregating by day
URL: https://github.com/apache/streampipes/issues/1292
--
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.
To unsubscribe, e-mail: issues-unsubscribe@streampipes.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org