Hive 201 – Managing HiveQL (Cloud Agnostic)

Free membership level allows access to this content.


NOTE: As of the first week of July 2017 we will archive this Version 1 Engine Courses and will release our Persona Based Engine Courses which are focused more on the functionality you will need depending on your specific role. Please check back during the first week of July for the new course list. 


AWS, Azure


Hive 201 will take students deeper into the specifics of working with HiveQL with an analysis of the different By Clauses as well as Join and Dynamic Partitioning considerations. The course will also review the settings which are commonly used to control the behavior of the MapReduce generated in response to SQL submitted.

Try It

Qubole Education Hive 201 contains “Try It” sections which contain instructions that can be followed inside of a personal account if you have access to the default_qubole_airline_origin_destination demonstration table. Please contact your administrator if you have issues accessing the sample datasets from your personal accounts.

Quiz Questions 

Qubole Education Hive 201 contains quiz questions after several of the lessons – it will be necessary to answer the quiz questions to complete the lessons and the course.

Recommended PreRequisites:

  • User 101
  • Hive 101

Estimated Time: 30 to 45 minutes

Difficulty: Intermediate