Optimizing Query Executions with Hive
Apache Hive 2.3.2
| Intermediate
- 7 videos | 42m 9s
- Includes Assessment
- Earns a Badge
In this 7-video Skillsoft Aspire course, learners can explore optimizations allowing Apache Hive to handle parallel processing of data, while users can still contribute to improving query performance. For this course, learners should have previous experience with Hive and familiarity with querying big data for analysis purposes. The course focuses only on concepts; no queries are run. Learners begin to understand how to optimize query executions in Hive, beginning with exploring different options available in Hive to query data in an optimal manner. Discuss how to split data into smaller chunks, specifically, partitioning and bucketing, so that queries need not scan full data sets each time. Hive truly democratizes access to data stored in a Hadoop cluster, eliminating the need to know MapReduce to process cluster data, and makes data accessible using the Hive query language. All files in Hadoop are exposed in the form of tables. Watch demonstrations of structuring queries to reduce numbers of map reduce operations generated by Hive, and speeding up query executions. Other concepts covered include partitioning, bucketing, and joins.
WHAT YOU WILL LEARN
-
Recognize how hive translates queries to hadoop mapreduce operations
Identify the different options available in hive to optimize query execution
Recall how partitioning of a dataset can help queries run efficiently and identify the types of partitioning available in hive -
Specify how bucketing improves query performance and compare it with partitioning a dataset
Identify how to join tables in hive to ensure the best performance of your query
Work with techniques to improve performance and work with partitioning, bucketing and structured queries
IN THIS COURSE
-
2m 18s
-
4m 52sAfter completing this video, you will be able to recognize how Hive translates queries into Hadoop MapReduce operations. FREE ACCESS
-
3. Techniques to Improve Query Performance in Hive6m 50sIn this video, find out how to identify the different optimization options available in Hive. FREE ACCESS
-
4. Partitioning Tables in Hive8m 36sUpon completion of this video, you will be able to recall how partitioning of a dataset can help queries run efficiently and identify the types of partitioning available in Hive. FREE ACCESS
-
5. Bucketing Tables in Hive7m 17sAfter completing this video, you will be able to specify how bucketing improves query performance and compare it with partitioning a dataset. FREE ACCESS
-
6. Structuring Join Queries in Hive4m 36sIn this video, you will learn how to join tables in Hive to ensure the best performance of your query. FREE ACCESS
-
7. Exercise: Optimizing Query Execution in Hive7m 40sIn this video, learn how to work with techniques to improve performance, work with partitioning, bucketing, and structured queries. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
