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