About Us Icon About Us Icon Business Analyst Icon Business Analyst Icon CEO Icon CEO Icon Datameer Icon Datameer Icon Envelope Icon Envelope Icon Facebook Icon Facebook Icon Google Plus Icon Google Plus Icon Instagram Icon Instagram Icon IT Professional Icon IT Professional Icon Learn Icon Learn Icon Linkedin Icon Linkedin Icon Product Icon Product Icon Partners Icon Partners Icon Search Icon Search Icon Social Networks Icon Social Networks Icon Share Icon Share Icon Support Icon Support Icon Testimonial Icon Testimonial Icon Twitter Icon Twitter Icon

Datameer Blog

How-to: Use Datameer Spreadsheet Analytics on Hadoop | GROUPBY, GROUPCONCAT, LISTELEMENT

By on April 2, 2014

I am a big fan of Datameer’s simple spreadsheet UI for Hadoop data analysis, which offers more than 240+ point-and-click functions for creating different “views” of any data. The entire paradigm makes extracting information that might normally take hours to pull, fast and straightforward.

For example, let’s say you’re really interested in the Gold, Silver and Bronze medal winners in a specific Olympic sport from the years 1976 through 2012 but all you have is a giant lump of data with names, years and scores, like the below:

Datameer Workbook Function

How can you find what you’re looking for? Check out the video at the end of my post to see how you can use functionalities like GROUPBY, GROUPSUM, GROUPCONCAT and LISTELEMENT  to come up with your answer:

Datameer Workbook Functions

And now, for the full video:

**In this weekly blog series, engineering and support staff at Datameer share their favorite features in Datameer.**

Connect with Datameer

Follow us on Twitter
Connect with us on LinkedIn, Google+ and Facebook

Viacheslav Avramenko