Impala Training
Course
Online
Description
-
Type
Course
-
Methodology
Online
Simplilearn is the World’s Largest Certification Training Provider, with over 400,000+ professionals trained globally
Trusted by the Fortune 500 companies as their learning provider for career growth and training
2000+ certified and experienced trainers conduct trainings for various courses across the globe
All our Courses are designed and developed under a tried and tested Unique Learning Framework that is proven to deliver 98.6% pass rate in first attempt.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Course programme
- Impala-An Open Source SQL Engine for Hadoop
- Lesson 0 - Course Introduction
- 0.1 Course Introduction
- 0.2 Table of Contents
- 0.3 Objectives
- 0.4 Course Overview
- 0.5 Value to Professionals and Organizations
- 0.6 Course Prerequisites
- 0.7 Lessons Covered
- 0.8 Conclusion
- Lesson 1 - Introduction to Impala
- 1.1 Introduction to Impala
- 1.2 Objectives
- 1.3 What is Impala
- 1.4 Benefits of Impala
- 1.5 Benefits of Impala (Contd.)
- 1.6 Exploratory Business Intelligence
- 1.7 Impala Installation
- 1.8 Demo - Using Cloudera Manager for Impala
- 1.9 Demo - Using Cloudera Manager for Impala (contd.)
- 1.10 Starting and Stopping Impala
- 1.11 Demo - Starting Impala from Command Line
- 1.12 Demo - Starting Impala from Command Line (contd.)
- 1.13 Data Storage
- 1.14 Managing Metadata
- 1.15 Controlling Access to Data
- 1.16 Impala Shell Commands and Interface
- 1.17 Impala Shell Commands and Interface (contd.)
- 1.18 Demo - Launching Impala Shell and Shell Command
- 1.19 Demo - Launching Impala Shell and Shell Command (contd.)
- 1.20 Quiz
- 1.21 Summary
- 1.22 Summary (contd.)
- 1.23 Conclusion
- Lesson 2 - Querying with Hive and Impala
- 2.1 Querying with Hive and Impala
- 2.2 Objectives
- 2.3 SQL Language Statements
- 2.4 DDL Statements
- 2.5 DML Statements
- 2.6 CREATE DATABASE
- 2.7 CREATE TABLE
- 2.8 CREATE TABLE - Examples
- 2.9 Internal and External Tables
- 2.10 Loading Data into Impala Table
- 2.11 ALTER TABLE
- 2.12 DROP TABLE
- 2.13 DROP DATABASE
- 2.14 DESCRIBE Statement
- 2.15 EXPLAIN Statement
- 2.16 SHOW TABLE Statement
- 2.17 INSERT Statement
- 2.18 INSERT Statement - Examples
- 2.19 SELECT Statement
- 2.20 Data Type
- 2.21 Data Type (contd.)
- 2.22 Operators
- 2.23 Functions
- 2.24 CREATE VIEW in Impala
- 2.25 Hive and Impala Query Syntax
- 2.26 Demo - Using Impala Shell for DDL and DDML SQL Statements
- 2.27 Demo - Using Impala Shell for DDL and DDML SQL Statements (contd.)
- 2.28 Quiz
- 2.29 Summary
- 2.30 Conclusion
- Lesson 3 - Data Storage and File Format
- 3.1 Data Storage and File Format
- 3.2 Objectives
- 3.3 Partitioning Tables
- 3.4 SQL Statements for Partitioned Tables
- 3.5 File Format and Performance Considerations
- 3.6 Choosing File Type and Compression Technique
- 3.7 Demo - File Formats and Compression Techniques
- 3.8 Demo - File Formats and Compression Techniques (contd.)
- 3.9 Quiz
- 3.10 Summary
- 3.11 Conclusion
- Lesson 4 - Working with Impala
- 4.1 Working with Impala
- 4.2 Objectives
- 4.3 Impala Architecture
- 4.4 Impala Daemon
- 4.5 Impala Statestore
- 4.6 Impala Catalog Service
- 4.7 Query Execution Flow in Impala
- 4.8 User - Defined Functions
- 4.9 Hive UDFs with Impala
- 4.10 Demo - UDF in Impala
- 4.11 Demo - UDF in Impala(contd.)
- 4.12 Improving Impala Performance
- 4.13 Quiz
- 4.14 Summary
- 4.15 Conclusion
- Lesson 0 - Course Introduction
Impala Training