Group By Sql command in Hive

Question

Group By

Group By clause groups the particular columns that are being mentioned with the group by clause.

hive> select dept,count(*) from person group by dept;
OK
HR    2
IT    2
PR    1