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;
Data Visualisation Aurora
Hadoop and Big Data
Agile and SAFE
New York, NY 10012, US
© Copyright 2018-2023 www.madanswer.com. All rights reserved. Developed by Madanswer.