This course begins with a review of SQL-on-Hadoop tools, then covers how to create, load, query, and manipulate tables in Hive. You will learn how to use Hive to query structured data without writing MapReduce code. You will learn how Apache Hive fits in the Hadoop ecosystem, how to create and load tables in Hive, and how to query data using the Hive Query Language. Together with DA 450 - Transform Data with Apache Pig, you can learn how to use Pig and Hive as part of a single data flow in a Hadoop cluster.
This course is part of the preparation needed for the MapR Certified Data Analyst (MCDA) certification exam.
Have questions? View our Frequently Asked Questions to get answers.