Re: Running sum not working as expected, bug?

[Armen Chamyan]

Hi!

Would like to know if anyone had the chance to look into this issue. I would 
really appreciate an answer to know if this is not supported or if it should be 
filed as a bug.

Thanks in advance,
Armen

From: Armen Chamyan <acham...@roku.com>
Date: Wednesday, 6 October 2021 at 12:32
To: "dev@druid.apache.org" <dev@druid.apache.org>
Cc: Dong Jiang <dji...@roku.com>
Subject: Running sum not working as expected, bug?

Hi all,

Was wondering if someone could help me find if the following was a Druid bug, 
or just a not supported feature, but it seems odd.

The following query below calculates a daily sum of a measure, and a running 
sum of the same measure for a given date range. It does it in a particular way, 
but I would need it to do it in that way though. The only problem: it’s not 
working when L17 is commented instead of L18.

This photo shows L18 commented, works.
[cid:image001.png@01D7C04C.EC8B0420]


This photo shows with L17 commented instead of L18, doesn’t work.
[cid:image002.png@01D7C04C.EC8B0420]


It’s actually 4 use cases I find:

  *   Equal sign with fixed date • works
  *   Equal sign with variable date • works
  *   Less than sign with fixed date • works (1st photo)
  *   Less than sign with variable date • doesn’t work (2nd photo)

It looks odd to me that it works for the other 3 use cases, but not the 4th.
So, why is it not working for the last use case? Would this be a bug, or simply 
not supported?

Thanks a lot in advance!
Cheers,
Armen



PD:
Here’s the query text:

SELECT
    t1.__time as date_time,

    (SELECT SUM(impressions)
     FROM agg_adi_ump_flight_inventory
     WHERE
        advertiser_uid = '0DM4GFDcKr' AND
        __time = t1.__time
    ) daily_impressions,

    (SELECT SUM(impressions)
     FROM agg_adi_ump_flight_inventory
     WHERE
        __time >= TIME_PARSE('2021-04-10 00:00:00.000', 'yyyy-MM-dd 
HH:mm:ss.SSS') AND
        __time <  TIME_PARSE('2021-04-30 00:00:00.000', 'yyyy-MM-dd 
HH:mm:ss.SSS') AND
        advertiser_uid = '0DM4GFDcKr'
        AND __time <= TIME_PARSE('2021-04-11 00:00:00.000', 'yyyy-MM-dd 
HH:mm:ss.SSS')
        --AND __time <= t1.__time
    ) running_sum_impressions

FROM (
    SELECT distinct __time FROM agg_adi_ump_flight_inventory
    WHERE
        __time >= TIME_PARSE('2021-04-10 00:00:00.000', 'yyyy-MM-dd 
HH:mm:ss.SSS') AND
        __time <  TIME_PARSE('2021-04-30 00:00:00.000', 'yyyy-MM-dd 
HH:mm:ss.SSS')
) t1