Let us get an overview of Basic Hive Queries.
- Let us make sure
_retaildatabase is created.
- Make sure orders and order_items tables are added in the database.
- SQL Clauses
- SELECT - Project fields or derived fields
- FROM - Specify Tables
- JOIN - Join multiple data sets. It can also be OUTER
- WHERE - To filter data
- GROUP BY [HAVING] - For group operations such as aggregation
- ORDER BY - To sort the data