PacktLib: Learning Cloudera Impala

Learning Cloudera Impala

Credits

About the Author

About the Reviewer

www.PacktPub.com

Preface

Getting Started with Impala

Impala requirements

Installing Impala

Configuring Impala after installation

Starting Impala

Stopping Impala

Restarting Impala

Upgrading Impala

Impala core components

The Impala execution architecture

Impala security

Impala security guidelines for a higher level of protection

Summary

The Impala Shell Commands and Interface

Using Cloudera Manager for Impala

Launching Impala shell

Connecting impala-shell to the remotely located impalad daemon

Impala-shell command-line options with brief explanations

Impala-shell command reference

Summary

The Impala Query Language and Built-in Functions

Impala SQL language statements

Data types

Operators

Functions

Clauses

Query-specific SQL statements in Impala

Defining VIEWS in Impala

Loading data from HDFS using the LOAD DATA statement

Comments in Impala SQL statements

Built-in function support in Impala

Unsupported SQL statements in Impala

Summary

Impala Walkthrough with an Example

Creating an example scenario

Commands for loading data into Impala tables

Launching the Impala shell

SQL queries against the example database

SQL join operation with the example database

Summary

Impala Administration and Performance Improvements

Impala administration

Impala High Availability

Single point of failure in Impala

Improving performance

Testing query performance

Choosing an appropriate file format and compression type for better performance

Fine-tuning Impala performance

Summary

Troubleshooting Impala

Troubleshooting various problems

Using Cloudera Manager to troubleshoot problems

Summary

Advanced Impala Concepts

Impala and MapReduce

Impala and Hive

Impala and Extract, Transform, Load (ETL)

Why Impala is faster than Hive in query processing

Impala processing strategy

Impala and HBase

File formats and compression types supported in Impala

Processing different file and compression types in Impala

The unsupported features in Impala

Impala resources

Summary

Technology Behind Impala and Integration with Third-party Applications

Technology Behind Impala and Integration with Third-party Applications

Technology Behind Impala and Integration with Third-party Applications

Technology Behind Impala and Integration with Third-party Applications

Technology Behind Impala and Integration with Third-party Applications

Index