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@01D7BAAE.3FD309B0]
This photo shows with L17 commented instead of L18, doesn’t work.
[cid:image002.png@01D7BAAE.3FD309B0]
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
