Learn all about end-to-end Hive including UDFs, Windowing, Optimization HQL, Partitioning, Bucketing Map Joins, & Indexes
Enrolling into this course will give you hands-on expertise in:
- Writing complicated analytical queries on data in Hive & uncover insights
- Generating and implementing ideas of partitioning, bucketing in order to optimize queries in Hive
- Customizing hive with user defined functions in Java and Python
- Understanding what goes on under the hood of Hive with HDFS and Map Reduce
Some basic requirements for enrollment in this course are:-
- SQL Knowledge
- Java concept clarity
Hive can be considered as the new face of SQL and this course will prove to be the best possible practical guide in using Hive for Big Data Processing. Hive will be highly helpful in leveraging the power of distributed computing and Hadoop for analytical processing.
This course covers the following topics:-
- Analytical processing including Joins, Sub-queries, Views, Table Generating Functions, Explode, Lateral View, Windowing and more
- Hive Tuning including Partitioning, Bucketing, Join Optimizations, Map Side Joins, Indexes, Writing custom User Defined functions in Java. UDF, UDAF, Generic UDF, Generic UDTF, Custom functions in Python, Implementation of MapReduce for Select, Group by and Join
Some exceptional benefits associated with this course enrollment are:
- Quality course material
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
This course has 87 videos in total and will take you through all of these in maximum 16 hours. You can watch the videos at your own pace and accordingly can raise doubts or questions if you get stuck. The course is apt for Analysts and Engineers who look forward to manage Hive for data warehousing solution
Grab the opportunity and enroll today!
Curriculum
- 19 Sections
- 87 Lessons
- 10 Weeks
- You, Us & This Course1
- Introducing Hive4
- Hadoop and Hive Install5
- Hadoop and HDFS Overview2
- Hive Basics11
- 6.1Primitive Datatypes17 Minutes
- 6.1Collections_Arrays_Maps9 Minutes
- 6.1Structs and Unions6 Minutes
- 6.1Create Table13 Minutes
- 6.1Insert Into Table12 Minutes
- 6.1Insert into Table 27 Minutes
- 6.1Alter Table7 Minutes
- 6.1HDFS9 Minutes
- 6.1HDFS CLI – Interacting with HDFS11 Minutes
- 6.1Code-Along: Create Table10 Minutes
- 6.1Code-Along : Hive CLI3 Minutes
- Built-in Functions4
- Sub-Queries5
- Partitioning7
- Bucketing5
- Windowing4
- Understanding MapReduce3
- MapReduce logic for queries: Behind the scenes3
- Join Optimizations in Hive6
- 14.1Improving Join performance with tables of different sizes13 Minutes
- 14.1The Where clause in Joins5 Minutes
- 14.1The Left Semi Join12 Minutes
- 14.1Map Side Joins: The Inner Join10 Minutes
- 14.1Map Side Joins: The Left, Right and Full Outer Joins11 Minutes
- 14.1Map Side Joins: The Bucketed Map Join and the Sorted Merge Join8 Minutes
- Custom Functions in Python2
- Custom functions in Java10
- 16.1Introducing UDFs – you’re not limited by what Hive offers5 Minutes
- 16.1The Simple UDF: The standard function for primitive types7 Minutes
- 16.1The Simple UDF: Java implementation for replacetext()8 Minutes
- 16.1Generic UDFs, the Object Inspector and DeferredObjects14 Minutes
- 16.1The Generic UDF: Java implementation for containsstring()9 Minutes
- 16.1The UDAF: Custom aggregate functions can get pretty complex14 Minutes
- 16.1The UDAF: Java implementation for max()9 Minutes
- 16.1The UDAF: Java implementation for Standard Deviation11 Minutes
- 16.1The Generic UDTF: Custom table generating functions8 Minutes
- 16.1The Generic UDTF: Java implementation for namesplit()10 Minutes
- SQL Primer - Select Statemets3
- SQL Primer - Group By, Order By and Having5
- SQL Primer - Joins5
- Appendix2
An ex-Google, Stanford and Flipkart team
Loonycorn is a team by Janani Ravi and Vitthal Srinivasan, product of Stanford University and IIM Ahmedabad.
We hold several years of working experience in the field of technology in Bay Area, New York, Singapore and Bangalore.
Janani Ravi: 7 Years of work experience (Google, Flipkart and Microsoft)
Vitthal Srinivasan: Worked at Google, Flipkart, Credit Suisse and INSEAD
We have come together to teach and educate on various technological courses in the most easiest and entertaining manner. Also, our courses will be based on practical elaborations & illustrations.
Courses you might be interested in
-
15 Lessons
-
10 Lessons
-
13 Lessons
-
39 Lessons