SELECT * FROM SAX2 (
ON sax_example AS INPUT
PARTITION BY id
ORDER BY id
ValueColumns ('expenditure', 'income', 'investment')
TimeColumn ('period')
Output ('bitmap')
BitmapLevel (1)
WindowType ('sliding')
WindowSize (20)
Accumulate ('id')
) ORDER BY id;