We can query the datasets that have been mapped to Hive tables using HiveQL, which is similar to SQL. These queries can be simple data-exploration operations such as counts,
orderby, and group by as well as complex joins, summarizations, and analytic operations. In this recipe, we'll explore simple data exploration Hive queries. The subsequent recipes in this chapter will present some of the advanced querying use cases.
Install Hive and follow the earlier Creating databases and tables using Hive CLI recipe.
This section demonstrates how to perform a simple SQL-style query using Hive.