SELECT * FROM SAX2 (
ON sax_example AS INPUT
PARTITION BY id
ORDER BY id
ValueColumns ('expenditure')
TimeColumn ('period')
WindowType ('sliding')
WindowSize (20)
PrintCodeStats ('true')
Accumulate ('id')
) ORDER BY id;
SELECT * FROM SAX2 (
ON sax_example AS INPUT
PARTITION BY id
ORDER BY id
ValueColumns ('expenditure')
TimeColumn ('period')
WindowType ('sliding')
WindowSize (20)
PrintCodeStats ('true')
Accumulate ('id')
) ORDER BY id;