Step 1: When you create a new connection, for example as shown here Connect To hadoop , you will get to Preview Screen.

 

Step 2: On preview screen,on right panel, you will see a section of "Other Operations".

 

 

 

   

Step 3: You get to see various options available under this section :

  • Aggregate - By selecting this tab, you actually get the functionality of grouping the data and obtain the data counts over the grouped item. You will be rendered with a popup with following fields:
    • You need to select the column to be grouped by from the dropdown.
    • And you need to select the column to aggregate from the second dropdown.
    • On successful selection of the above two, you will be obtained with the result on the right side of the popup.


 Step 4 : You can click on save to save the result.