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.
Code: EAS-019
Duration: 8 hours

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

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

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


Trainer in Krakow
Vladimir Slobodyanyuk Data Warehouses and Integration Projects Consultant
Has professional experience in practical using of case and ETL tools, as well as experience in deployment and adaptation of industrial models. Has cumulative experience in architecture and design of more than 7 years.
Course is scheduled in: Krakow
25.06.2019 - 25.06.2019
Time: 09:00-17:00
City: Krakow
Duration: 8 hours
Language: English
Trainer
Vladimir Slobodyanyuk
Data Warehouses and Integration Projects Consultant
€220
25.06.2019
Time: 09:00-17:00
City: Krakow
Duration: 16 hours
Language: English
Trainer
Vladimir Slobodyanyuk
Data Warehouses and Integration Projects Consultant
€0
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Register for the next course
+
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
Bucharest €220
Krakow €220
Wroclaw €220

Invoices for the course will be issued in local currency. All fees above can change according to training location and delivery mode and are subject to change while scheduling. For individual participants the price is as displayed. For legal entities VAT is added to the displayed price.

Courses you may be interested in:

Sign up

Choose dates
First Name*
Last Name*
Company
Email*
Phone
Your Comment
Luxoft Warsaw - Warsaw Spire, plac Europejski 1, 00-844 Warszawa
Dimitrie Pompeiu nr 5-7 , building C, Et. 5, sect 2, Bucharest, 014459

Contact phone:

021 371 4858
Luxoft Poland Wroclaw - Silver Tower pl. Konstytucji 3-go Maja 3 50-048 Wroclaw
Aleja Generała Tadeusza Bora-Komorowskiego 25, Quattro Business Park Five, 31-476 Kraków, Poland

Contact phone:

+48 122110650
Success
Thank you.
Your request has been received.