Quality Seal Emagister EMAGISTER CUM LAUDE

Impala Training

simplilearn
Online

Price on request
You can also call the Study Centre
81510... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Online
Description

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.

Important information

Opinions

There are no opinions on this course yet

Course programme

Course Preview
  • 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

Compare this course with other similar courses
See all