Hive helps you leverage the power of Distributed computing and Hadoop for Analytical processing. It's 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.
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.
Everything is taught using real-life examples, working queries and code .
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 requires knowledge of SQL. The course includes and SQL primer at the end. Please do that first if you don't know SQL. You'll need to know Java if you want to follow the sections on custom functions.
Who is this course intended for?
Analysts who want to write complex analytical queries on large scale data
Engineers who want to know more about managing Hive as their data warehousing solution