...
Part of subquery
Code Block |
---|
sm_data = CONNECTOR({
port = 0,
source = 'preprocessing_source',
schema = ${sm_schema}
}
)
[...]
calc_w1 = PREDICATEWINDOW({
start = 'true',
#IF OUTOFORDER="TRUE"
end = "!isNull(__last_1.i) && floor(__last_1.i/${w1_size}) != floor(i/${w1_size})",
#ELSE
end = "size(__all) == ${w1_size}-1",
#ENDIF
nesting = true,
keependingelement = true,
USEELEMENTONLYFORSTARTOREND = true,
allowsamestartandendts = true,
keepTimeOrder = false
},
w1_preprocess
) |
Additional: The options given are available in the query query as parameters in Odysseus Script format (i.e. ${OUTOFORDER} in the above example)
For a complete and complex example see our solution for the debs grand challenge 2020:
https://git.swl.informatik.uni-oldenburg.de/projects/ODR/repos/gc2020/browse
Or directly the workspace:
https://git.swl.informatik.uni-oldenburg.de/projects/ODR/repos/gc2020/browse/workspace/DEBS_GC_20