Raw-to-hour aggregation process can result in "hole"

XMLWordPrintable

    • 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:

      1. the previous datum's hour is more than 1 hour earlier than the stale hour
      2. 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.

            Assignee:
            Matt Magoffin
            Reporter:
            Matt Magoffin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: