Section 10:117.Performing  Basic Aggregations Sum, Min,Max Using Group by

Performing basic aggregations using HAVING in Hive is a way to filter the results of a query based on a condition applied to an aggregate function result. HAVING clause is used with the GROUP BY clause and it filters the groups based on a condition specified after the HAVING keyword.

To perform basic aggregations using HAVING in Hive, you can follow these steps:

1. Open the Hive shell by typing hive in the command line.
2. Create a table and load the data.
3. You can use the HAVING clause to filter the results based on a condition applied to an aggregate function result.
4.