From 0 to 1: Hive for Processing Big Data [Video]

More Information
  • Write complex analytical queries on data in Hive and uncover insights
  • Leverage ideas of partitioning, bucketing to optimize queries in Hive
  • Customize hive with user-defined functions in Java and Python
  • Understand what goes on under the hood of Hive with HDFS and MapReduce

Hive is like a new friend with an old face (SQL). This course is an end-to-end, practical guide to using Hive for Big Data processing. Let's parse that A new friend with an old face: Hive helps you leverage the power of Distributed computing and Hadoop for Analytical processing. Its interface is like an old friend: the very SQL like HiveQL. This course will fill in all the gaps between SQL and what you need to use Hive. End-to-End: The course is an end-to-end guide for using Hive: whether you are analyst who wants to process data or an Engineer who needs to build custom functionality or optimize performance - everything you'll need is right here. New to SQL? No need to look elsewhere. The course has a primer on all the basic SQL constructs, Practical: Everything is taught using real-life examples, working queries and code.

Style and Approach

A 15- hour course which gives you a very detailed coverage of topics, excellent graphics used to explain concepts.

  • Analytical Processing: Joins, Subqueries, Views, Table Generating Functions, Explode, Lateral View, Windowing and more
  • Tuning Hive for better functionality: Partitioning, Bucketing, Join Optimizations, Map Side Joins, Indexes, Writing custom User Defined functions in Java. UDF, UDAF, GenericUDF, GenericUDTF, Custom functions in Python, Implementation of MapReduce for Select, Group by and Join
Course Length 15 hours 16 minutes
ISBN 9781788995054
Date Of Publication 15 Dec 2017



Loonycorn is Janani Ravi and Vitthal Srinivasan. Between them, they have studied at Stanford, been admitted to IIM Ahmedabad, and have spent years working in tech, in the Bay Area, New York, Singapore and Bangalore. Janani spent 7 years at Google (New York, Singapore); Studied at Stanford and also worked at Flipkart and Microsoft. Vitthal also worked at Google (Singapore) and studied at Stanford; Flipkart, Credit Suisse and INSEAD too. They think they might have hit upon a neat way of teaching complicated tech courses in a funny, practical, engaging way, which is why they are so excited to be here. They hope you will try their offerings, and you'll like them.