$29.99
Certification

Industry recognized certification enables you to add this credential to your resume upon completion of all courses

Need Custom Training for Your Team?
Get Quote
Call Us

Toll Free (844) 397-3739

Inquire About This Course
Instructor
Krishna Venkatrama, Instructor -  Apache Hive Crash Course - Quick Tutorial

Krishna Venkatrama

Has 30 years high tech experience working with RDBMS, data models, data warehousing, Hadoop architecture. He also worked in large multinationals like IBM, AT&T, Sabre, Corning, TCS, CSX, and Florida Blue. He earned graduate degrees in Mechanical Engineering, Mathematics & an M.S. in Tech Operations and MBA in Tech Management.

Instructor: Krishna Venkatrama

Get an introduction to Hive with our quick tutorial.

  • Learn how to create tables, point to locations, file formats, and many more.
  • Learn how to point to data files loaded into HDFS and use Hive to point to those files.
  • Instructor has 30 years of high tech experience working at multinational companies.

Duration: 43m

Course Description

Apache Hive is a data warehouse software project built on top of Apache Hadoop to provide data summarization, query and analysis. Hive gives a SQL-like interface to query data stored in various databases and file systems that integrate with Hadoop. This course will give you a quick introduction to Hive and explore most of its features in under an hour.

What am I going to get from this course?

  • DDL – create table, point to locations, file formats, create index, create table with partitions etc.
  • How to point to data files loaded into HDFS and use Hive to point to those files
  • Difference between internal and external tables
  • Demo/hands-on
  • Tables/partitioning/buckets
  • Turning on ACID and DML – insert/update/delete/merge
  • Complex data types – Struct, Map, Array
  • Fine Tuning – Advanced queries and explain plan
  • How to use HiveQL using Select and complex joins

Prerequisites and Target Audience

What will students need to know or do before starting this course?

  • Familiarity with Big Data 
  • Comfortable at the command line

Who should take this course? Who should not?

Big Data professionals looking to learn a new technology 

Curriculum

Module 1: Hive

Lecture 1 Introduction to Hive for Beginners
Lecture 2 HDSF & Hive
Lecture 3 Table – Create, Insert, and Select – Basic ddl/dml
Lecture 4 Beginners Summary
Lecture 5 HiveQL – Supports Standard SQL for Enterprise Users – Easy to Learn
Lecture 6 Hive Demo
350