-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Major
-
Component/s: DB
-
None
Discovered a specific scenario where the raw-to-hour datum aggregation process can result in a "hole" (no hourly aggregate) when one should have been generated. The requirements for this situation are, starting with a "stale hour" aggregation record on a single datum stream:
- the previous datum's hour is more than 1 hour earlier than the stale hour
- a datum exists exactly on the stale hour's start
Example raw data:
Time | Reading |
---|---|
12:00 | 0 |
12:30 | 1 |
16:00 | 3 |
16:30 | 4 |
17:00 | 5 |
Expected hour aggregate data:
Hour | Reading |
---|---|
12:00 | 1 |
15:00 | 2 |
16:00 | 2 |
Actual hour aggregate data:
Hour | Reading |
---|---|
12:00 | 1 |
16:00 | 2 |
Notice how the 15:00 = 2 hour is missing.