Group By clause groups the particular columns that are being mentioned with the group by clause.
Group By
hive> select dept,count(*) from person group by dept; OK HR 2 IT 2 PR 1