BigData SQL Impala
Duration
8
hours
Location
Online
Language
English
Code
EAS-019
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
After completing the course, a certificate
is issued on the Luxoft Training form
is issued on the Luxoft Training form
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