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
Requirements
- knowledge of SQL
Getuigenissen (5)
Trainer's preparation & organization, and quality of materials provided on github.
Mateusz Rek - MicroStrategy Poland Sp. z o.o.
Cursus - Impala for Business Intelligence
Many hands-on sessions.
Jacek Pieczątka
Cursus - Administrator Training for Apache Hadoop
The VM I liked very much The Teacher was very knowledgeable regarding the topic as well as other topics, he was very nice and friendly I liked the facility in Dubai.
Safar Alqahtani - Elm Information Security
Cursus - Big Data Analytics in Health
The fact that all the data and software was ready to use on an already prepared VM, provided by the trainer in external disks.
vyzVoice
Cursus - Hadoop for Developers and Administrators
practical things of doing, also theory was served good by Ajay