Eugene Panaitov thinks this is interesting: collect_set(sex_age.age) From 6. Data Aggregation and Sampling from Apache Hive Essentials by Dayong Du Publisher: Packt Publishing Released: February 2015 Note Take first element under GROUP BY Share this highlight http://www.safaribooksonline.com/a/apache-hive-essentials/387467/ Twitter Facebook Google Plus Email Get Instant Access Now Start a Free Trial Learn about Safari for Business Have an account? Sign in. Minimise Unlock the rest of Apache Hive Essentials and 30,000 other books and videos By clicking this box, you confirm that you have read and agree to the terms and conditions of our Membership Agreement, and you understand that when your trial period ends, you will be required to provide billing information if you wish to continue using the service. Unlock the rest of this book Start a Free 10-Day Trial loading Learn about Safari for Business Have an account? Sign in.