Re: collect_set question

2013-05-17 Thread Sanjay Subramanian
;user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Date: Friday, May 17, 2013 12:25 PM To: "user@hive.apache.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: collect_set question For collect_set is it possibl

collect_set question

2013-05-17 Thread Robert Li
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