Frame specification not supported

HeavyDB
#1

Hi Team,
I am getting below exception when query is run on OMNISCI db.

SELECT
starttime,
start_station_id,
bikeid,
COUNT(*) OVER (
ORDER BY EXTRACT(EPOCH FROM starttime)
RANGE BETWEEN 300000 PRECEDING AND 300000 FOLLOWING
) AS trip_demand
FROM test10m
WHERE starttime >= ‘2020-12-20 00:00:00’ AND starttime <‘2020-12-21 00:00:00’
ORDER BY
starttime;

Error:
Frame specification not supported

Can you please help us with this

Regards
Ajay

#2

Hi @Ajay_Chaudhary,

We currently don’t support frame specifications for Windows function so the behavior that you are experiencing is expected.

Not having too much experience with the Frmes in WF, do you want to partition the windows on preceding and following 300k rows, or 300k seconds?

Candido

#3

Hi Candido,
We want to fetch the data for 10 minutes sliding window and value mentioned in query is in Milli seconds (300000)

Regards
Ajay