Welcome to the segment on ‘Advanced Hive Queries’.
In the previous session, you learnt about databases and the creation of tables. You now have a clear understanding of the internal and external tables. You also learnt about sorting, user-defined functions and indexing.
You gained an understanding of basic querying, various keys and aggregate functions from the SQL module.
Now, let’s look at some advanced Hive queries.
In this session
You will learn about the following concepts:
- Map joins
- Partitioning and its demonstration.
- Bucketing and its demonstration.
- Various query optimisation techniques.