Working with Apache Hive | Apache Hive Essentials

Learn Hive Essentials, Architecture & Skills for Data Warehousing Hadoop

TTDS6763

Introductory

2 Days

Course Overview

Apache Hive is the de-facto standard for data warehousing Hadoop. This course starts with standard Hive setup and operations, continues into Advanced Hive use, discusses performance and execution engines, and ends with a practical workshop.

Course Objectives

This course is intended for data scientists and software engineers. It gives them practical level of experience, achieved through a combination of about 50% lecture, 50% lab work.

Course Prerequisites

This is an Introductory-level course is geared for experienced data scientists and engineers seeking a quick start to working with Hive. Attendees should have some familiarity with basic SQL, and should also be able to navigate Linux command line and have basic knowledge of Linux editors (such as VI / nano) for editing code.

This course is a core component of our Big Data, AI & Machine Learning Skills Path, designed to train participants of all skill levels in modern data science across the enterprise. We offer courses in next level Hadoop, Hive, Analytics, Kafka and more. Please contact us for details and next step recommendations based on your specific roles and. goals.

Please see the Related Courses tab for specific Pre-Requisite courses, Related Courses that offer similar skills or topics, and next-step Learning Path recommendations

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most.  

Hive Basics

  • Defining Hive Tables
  • SQL Queries over Structured Data
  • Filtering / Search
  • Aggregations / Ordering
  • Partitions
  • Joins
  • Text Analytics (Semi-Structured Data)

Hive Advanced

  • Transformation, Aggregation
  • Working with Dates, Timestamps, and Arrays
  • Converting Strings to Date, Time, and Numbers
  • Create new Attributes, Mathematical Calculations, Windowing Functions
  • Use Character and String Functions
  • Binning and Smoothing
  • Processing JSON Data
  • Execution Engines (Tez, MR, Spark)

Impala (for Cloudera track)

  • Architecture
  • Impala joins and other SQL specifics

Bonus Project

  • Students will work in teams to do this end-to-end workshop
  • Setup a data warehouse with Hive
  • Query and analyze data with Hive and Spark

Course Materials

Student Materials: Each participant will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Hands-On Setup Made Simple! Our dedicated tech team will work with you to ensure our ‘easy-access’ cloud-based course environment is accessible, fully-tested and verified as ready to go well in advance of the course start date, ensuring a smooth start to class and effective learning experience for all participants. Please inquire for details and options.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Attend a Course

Please see the current upcoming available open enrollment course dates posted below. Please feel free to Register Online below, or call 844-475-4559 toll free to connect with our Registrar for assistance. If you need additional date options, please contact us for scheduling.

Course Title Days Date Time Price
Working with Apache Hive | Apache Hive Essentials 2 Days Sep 2 to Sep 3 10:00 AM to 06:00 PM EST $1,895.00 Register
Working with Apache Hive | Apache Hive Essentials 2 Days Oct 18 to Oct 19 10:00 AM to 06:00 PM EST $1,895.00 Register
Working with Apache Hive | Apache Hive Essentials 2 Days Nov 29 to Nov 30 10:00 AM to 06:00 PM EST $1,895.00 Register
Working with Apache Hive | Apache Hive Essentials 2 Days Dec 16 to Dec 17 10:00 AM to 06:00 PM EST $1,895.00 Register

See Our Special Offers and Promotions
Trivera offers exclusive promotional offers here at our site that change regularly. Check back often and don’t miss these limited opportunities to learn for less.

See our latest offers and promotions

Learn. Explore. Advance!

Trivera EveryCourse Extras
Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More