Event based function

davds

Here is example vertica site given, to create event id when stock big > $5 based on timestamp
SELECT stock, CONDITIONAL_CHANGE_EVENT(bid> 5)
OVER(ORDER BY ts) FROM Tickstore3;

My question is: this only work for one stock, if have more than one stock in the table, has any like: partition by or group by function to generate each stock event_id?

davds

reference link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AnalyzingData/SQLAnalytics/Event-basedWindows.htm

davds

CONDITIONAL_CHANGE_EVENT and CONDITIONAL_TRUE_EVENT do not support window framing.

Vertica DO NOT support this window function