Impala for Business Intelligence Training Course

  1. Big Data Training
  2. Hadoop Training
  3. Impala Training
  4. Impala for Business Intelligence Training Course

Course Code

Imp

Duration

21 hours (usually 3 days including breaks)

Requirements

  • knowledge of SQL

Overview

Cloudera Impala is an open source massively parallel processing (MPP) SQL query engine for Apache Hadoop clusters.

Impala enables users to issue low-latency SQL queries to data stored in Hadoop Distributed File System and Apache Hbase without requiring data movement or transformation.

Audience

This course is aimed at analysts and data scientists performing analysis on data stored in Hadoop via Business Intelligence or SQL tools.

After this course delegates will be able to

  • Extract meaningful information from Hadoop clusters with Impala.
  • Write specific programs to facilitate Business Intelligence in Impala SQL Dialect.
  • Troubleshoot Impala.

Course Outline

Introduction to Impala

  • What is Impala?
  • How Impala Differs from Relational Databases
  • Limitations and Future Directions
  • Using the Impala Shell
  • The Impala Daemon, Statestore and Catalogue service

Loading Impala

  • Explore a New Impala Instance
  • Load CSV Data from Local Files
  • Point an Impala Table at Existing Data Files

Analyzing Data with Impala

  • Describe the Impala Table
  • Basic Syntax and Querying
  • Data Types
  • Filtering, Sorting, and Limiting Results
  • Joining and Grouping Data
  • Data Loading and Querying Examples
  • Improving Impala Performance
  • How Impala works with Hadoop file formats
  • Hands-On Exercise: Interactive Analysis with Impala

Programming Impala Applications

  • Overview of the Impala SQL Dialect
  • Overview of Impala Programming Interfaces

Troubleshooting Impala

  • Troubleshooting Impala SQL Syntax Issues
  • Troubleshooting I/O Capacity Problems
  • Impala Web User Interface for Debugging

 

 

Testimonials

★★★★★
★★★★★

Related Categories

Related Courses

Alluxio: Unifying Disparate Storage SystemsAdministrator Training for Apache HadoopApache Hadoop: Manipulation and Transformation of Data PerformanceHadoop AdministrationHadoop For AdministratorsHadoop for Business AnalystsHadoop for Developers (4 days)Advanced Hadoop for DevelopersHadoop for Developers and AdministratorsHadoop for Project ManagersHadoop Administration on MapRHBase for DevelopersApache Avro: Data Serialization for Distributed ApplicationsSamza for Stream ProcessingTigon: Real-time Streaming for the Real World

Course Discounts

Robotics in business - AI/Robotics

10/23/2019 - 09:30
Riga, Old Town
Remote
3500EUR
3150EUR
 Classroom
4100EUR
3750EUR
Read more

Drools 6 and DSL for Business Analysts

12/17/2019 - 09:30
Riga, Old Town
Remote
5250EUR
4725EUR
 Classroom
6050EUR
5525EUR
Read more

Marketing Analytics using R

12/18/2019 - 09:30
Riga, Old Town
Remote
5250EUR
4725EUR
 Classroom
6050EUR
5525EUR
Read more

Visual Analytics – Data science

03/26/2020 - 09:30
Riga, Old Town
Remote
3500EUR
3150EUR
 Classroom
4100EUR
3750EUR
Read more

Blockchain: Hyperledger Fabric

05/05/2020 - 09:30
Riga, Old Town
Remote
3500EUR
3150EUR
 Classroom
4100EUR
3750EUR
Read more

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Latvia!

As a Business Development Manager you will:

  • expand business in Latvia
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!