OpenMLDB icon indicating copy to clipboard operation
OpenMLDB copied to clipboard

long window: count where op with a rows bucket based pre-agg table may produce incorrect result

Open aceforeverd opened this issue 3 years ago • 1 comments

Describe the feature you'd like

deploy dp options (long_windows = 'w1:3')
select count_where(.....

3 as a rows based bucket size, since there is a extra filter key for pre-agg table added, rows in pre-agg table, where their ts_begin and ts_end value, are not aligned.

currently, this op (*_where with rows bucket) is turned off in #2255 -> compile time error

Additional context

Add any other context or screenshots about the feature request here.

aceforeverd avatar Aug 08 '22 02:08 aceforeverd