The Asof join engine output does not match expectations

11 views Asked by At

Why does the cumsum calculation for the TV column restart at the red line, even though the calculations before it are correct?

enter image description here

1

There are 1 answers

0
JaneYe On

The window function like cumsum is not applicable within the Asof join engine; it should be split into two separate engines: one for the Asof join engine and another for the reactive state engine (used for computing cumsum, prev, etc.). These two engines should then be linked together to implement the computing logic.