0

I would like to run following query

SELECT key, LAST_VALUE(value) OVER (PARTITION BY key ORDER BY ts) AS value
  FROM [table]
 GROUP BY key, TUMBLE(ts, INTERVAL '5' MINUTE)

I would expect that LAST_VALUE would return last value of each time window. Instead I get

 Expression 'value' is not being grouped

Any ideas how to solve it?


Edit 1: Tried something like

SELECT key, LAST_VALUE(value) OVER (PARTITION BY key, TUMBLE(ts, INTERVAL '5' MINUTE) ORDER BY ts) AS value
  FROM [table]

but got instead

Unsupported call: TUMBLE(TIMESTAMP(3) *ROWTIME*, INTERVAL SECOND(3) NOT NULL) 

(also: I think this is not equivalent as now I probably get retract stream instead of append stream)

bottaio
  • 4,963
  • 3
  • 19
  • 43

0 Answers0