• Onboard For Tech Teams

    • Reduce initial time to productivity.
    • Increase employee tenure.
    • Plug-and-play into HR onboarding and career pathing programs.
    • Customize for ad-hoc and cohort-based hiring approaches.

    Learn more
  • Upskill For Tech Teams

    • Upgrade and round out developer skills.
    • Tailor to tech stack and specific project.
    • Help teams, business units, centers of excellence and corporate tech universities.

    Learn more
  • Reskill For Tech Teams

    • Offer bootcamps to give employees a running start.
    • Create immersive and cadenced learning journeys with guaranteed results.
    • Supplement limited in-house L&D resources with all-inclusive programs to meet specific business goals.

    Learn more
  • Design For Tech Teams

    • Uplevel your existing tech learning framework.
    • Extend HR efforts to provide growth opportunities within the organization.
    • Prepare your team for an upcoming tech transformation.

    Learn more

Working with Apache Hive

Get your team started on a custom learning journey today!

Our Boulder, CO-based learning experts are ready to help!

Get A Quote!

Course Summary

Home > Courses >Big Data Training >Hadoop >Working with Apache Hive

The Working with Apache Hive training course is designed to demonstrate how to use Apache Hive to efficiently run analytical queries on big data.

The course begins with the basics of Hive including architecture, Yarn, HDFS, and running Hive with different execution engines. Next, it explores the Hive basic operations, data formats, compressions, and Hive Functions. The course concludes by analyzing Hive’s advanced features and various optimization techniques to run queries faster.

Prerequisites: A basic knowledge of SQL is assumed.

Purpose
Promote an in-depth understanding of how to use Apache Hive in the most efficient way to run analytical queries on big data.
Audience
Business analysts, big data developers and testers who want to run analytics queries on big data systems.
Role
Business Analyst - Software Developer
Skill Level
Introduction
Style
Workshops
Duration
2 Days
Related Technologies
Download
imgprinter
  • Productivity Objectives:
    • Run analytics queries using Apache Hive
    • Tune and optimize Hive system to run queries faster
Learn About Virtual Training

Request Information

Get your team upskilled or reskilled today. Chat with one of our experts to create a custom training proposal. Fully customized at no additional cost.

100secure

If you are not completely satisfied with your training class, we'll give you your money back.

secure100 secure100 secure100 secure100

about our training

  • keywordicon1
    Real-World Content

    Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

  • keywordicon2
    Expert Practitioners

    Industry experts with 15+ years of industry experience that bring their battle scars into the classroom.

  • keywordicon3
    Experiential Learning

    More coding than lecture, coupled with architectural and design discussions.

  • keywordicon4
    Fully Customized

    One-size-fits-all doesn't apply to training teams. That's where we come in!

What You'll Learn

In the Working with Apache Hive training course, you'll learn:

  • Hive Overview
    • Understand Hadoop File System
    • Yarn Overview
    • Hive Overview and Architecture
    • Hive Execution Engines overview – Apache Spark, Tej and MapReduce
  • Hive Basic Operations
    • Hive Databases
    • Hive Managed/External Tables
    • Hive DDL and DML
  • Working with different File formats
    • Work with Parquet Files
    • Parquet versus Orc Files
    • Understand Avro
    • Schema Evolution with Avro
  • Hive Functions
    • Conditional Functions
    • String Functions
    • Date Functions
  • Hive Joins
    • Sort Merge Joins
    • Broadcast Joins
    • Bucket Joins
    • Multi Joins
  • Hive Analytics
    • Aggregations
    • Grouping
    • Subquery
    • Conditional statements
  • Hive Advance
    • Views/Lateral Explode
    • Windowing
    • Materialized view
  • Hive Optimization
    • File Partitioning
    • Bucketing
    • Dynamic Partition Pruning
Real-world content

Project-focused demos and labs using your tool stack and environment, not some canned "training room" lab.

Expert Practitioners

Industry experts that bring their battle scars into the classroom.

Experiential Learning

More coding than lecture, coupled with architectural and design discussions.

Fully Customized

One-size-fits-all doesn't apply to training teams. That's where we come in!

Elite Instructor Program

We recently launched our internal Elite Instructor Program. The community driven instructor program is designed to support instructors in transforming students’ lives by consistently showing a world-class level of engagement, ability, and teaching prowess. Reach out today to learn more about our instructors.

Customized Technical Learning Solutions to Help Attract and Retain Talented Developers

Get In Touch
Talk to one of our Learning Solution Architects today

Let DI help you design solutions to onboard, upskill or reskill your software development organization. Fully customized. 100% guaranteed.

DevelopIntelligence leads technical and software development learning programs for Fortune 500 companies. We provide learning solutions for hundreds of thousands of engineers for over 250 global brands.

99statisfaction1 Educate learners using experienced practitioners.
pularsight Proven customization process is guaranteed.
budgetnewlogo We're a strategic partner, not just another vendor.

“I appreciated the instructor’s technique of writing live code examples rather than using fixed slide decks to present the material.”

VMware
vmware View more