I have a question regarding the Druid query. I am trying to write a SQL code, calculating a simple next event type:
event_type next_event_type
media_play recommendation_hit
I tried to use the usual sql query:
LEAD(event_type) OVER (PARTITION BY user_id ORDER BY event_timestamp) as next_event
But I am getting an error :
No match found for function signature LEAD(<CHARACTER>)
Is it possible to use Window Functions in Druid and if not, what are the alternatives? Thank you in advance.