hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Robert Li <>
Subject collect_set question
Date Fri, 17 May 2013 19:25:25 GMT
For collect_set is it possible to only collect a few elements and then
stop? For example

Select user,collect_set(timestamp)
from XYZ
group by user.

For each user, there could be hundreds of timestamps, but I only need 3 or
4 per user. Is there a way to tell collect_set to stop collecting after
it's reached a certain number of elements?


Robert Li | Integration and Support Engineer  | Kontagent
Kontagent is Hiring! <> | Check us out
in the press! <>*
*Check out our blog: kScope <> | Twitter:
@Kontagent <>*

View raw message