MySQL Forums
Forum List  »  General

workaround for window functions
Posted by: Arun Ramakrishnan
Date: May 31, 2016 01:02AM

I have an event table that has the following fields:

event_id
event_type
event_time

Given a time window and a number k, I need a count of all the event_type's that had activity of more than k events within the time window at any time. This basically requires a window relative to each event.

I am not sure how to work around this without window functions.

(I am on mysql 5.6. I am talking about a dataset of under 1 million rows.)

Options: ReplyQuote


Subject
Written By
Posted
workaround for window functions
May 31, 2016 01:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.