BigData SQL Impala

This is a training about Impala for developers covering the full stack of technical features, architecture and performance tuning. Impala supports analysis of large datasets stored in HDFS and compatible file systems, providing an SQL-like language.

8 hours
English
Online

duration: 8 hours
location: Online
Language: English
Code: EAS-019
price: € 250 *

Available sessions

To be determined

Training for 7-8 or more people?
Customize trainings for your specific needs

Description

This is a training about Impala for developers covering the full stack of technical features, architecture and performance tuning. Impala supports analysis of large datasets stored in HDFS and compatible file systems, providing an SQL-like language. Other features of Impala include:

Indexing to provide acceleration
Different storage types such as plain text, RCFile, HBase, ORC, and others.
Metadata storage in an RDBMS
Operating on compressed data stored into the Hadoop ecosystem
SQL-like queries

Objectives

Developing expertise in the area of Big Data
Data modal design in Impala
Developing SQL scripts
Practical experience in queries and performance tuning

Target Audience

Developers
QA
Analysts

Prerequisites

Hadoop fundamentals
ANSI SQL 92

Roadmap

What is Impala
Architecture
Impala services
Impala DDL
Data Types
“Select” Queries
DML / Load data
Hive UDFs types
Indexes
Performance tuning
Hive vs Impala