Hi all,
I have an event table with (user_id, timestamp, event)
and I'm trying to write a query to get the first 10 events for each user.
My query goes like this :
SELECT user_id, event
FROM
(
SELECT
user_id,
event,
ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY time) as rownum
FROM
Hi Furcy,
Sorry that you run into this, but this is a non-trivial problem. But, good
news is Harish has done some good work in this area. See following links.
All this will be available in upcoming release, date for which is under
discussion on dev list.
1.
Thank you very much for your answer Ashutosh,
it seems non-trivial indeed !
2014-08-20 17:51 GMT+02:00 Ashutosh Chauhan hashut...@apache.org:
Hi Furcy,
Sorry that you run into this, but this is a non-trivial problem. But, good
news is Harish has done some good work in this area. See