Hive to ADVANCE Hive (Real time usage) :Hadoop querying tool
What you will learn
Learn the complete in-and-out details of Apache Hive from Basic to Advance level.
Start by exploring the fundamentals of Hive including Hive's Introduction, Architecture, Installation, SQL vs Hive etc.
Learn Basic Hive concepts to Create Databases & Tables, Insert data, Joins, Views, Mathematical functions, String functions, Conditional statements etc.
Strength of this course is ADVANCE HIVE, covering those Hive features that are actively used in Real-time projects.
Partitioning, Bucketing, Explode & Lateral views, Tablesampling, Variables, Optimized Map Joins, User defined functions (UDFs)
ACID features of Hive, Different types of files in Hive, Custom input formatter, Archiving and Compression techniques etc.
Learn about various Hive Tableproperties - Skip header & footer, Immutable table, Purge, Null format, Parallelism and ORC table properties.
Implement Slowly changing Dimensions (SCD 1) using Hive queries.
How to create a Hive table for XML data and load data in it.
Learn Interviews asked Hive Questions and Use cases.
Course Gallery
Charts
Comidoc Review
Our Verdict
The Hive to ADVANCE Hive (Real time usage) course on Udemy proves to be a valuable resource for learners aiming to explore Apache Hive. Its wide-ranging scope from basic concepts to advance features like partitioning, bucketing, and user-defined functions will appeal to both beginners and intermediate level students. The instructor's familiarity with the subject matter unveils hidden gems in the form of less-known but essential Hive functionalities; however, deeper exploration of real-world use cases could elevate learners' understanding. Limited resources and suboptimal setup instructions introduce friction, which could be streamlined or improved. Additionally, sporadic use case explanations may leave practitioners pining for more context behind certain features. In essence, this Hive course provides a solid foundation in both basic and advanced Hive concepts yet requires improvements in the consistency of resources provided, real-world applicability, and audio quality to create an even better learning experience.
What We Liked
- Comprehensive coverage of Apache Hive from basic to advanced concepts, including real-world use cases and interview questions.
- Instructor's familiarity with Hive functions, unveiling several \
- of knowledge that are hard to find elsewhere.
- The course follows good practices in HQL code presentation, making it easy to understand for learners.
- Clear explanations and organized way of presenting the content make it suitable for beginners in Big Data.
Potential Drawbacks
- Setup and environment configuration can be time-consuming and chaotic due to sparse resources and outdated instructions.
- Lack of in-depth explanation and context behind certain Hive features, resulting in superficial understanding.
- Sporadic use cases for various functions may leave learners craving more real-world application examples.
- Audio quality issues affect the overall learning experience negatively and should be addressed.