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

Achievements for this centre

2016

Compare this course with other similar courses
See all