Cargando…
Learning Cloudera Impala : perform interactive, real-time in-memory analytics on large amounts of data using the massive parallel processing engine Cloudera Impala /
This book is an easy-to-follow, step-by-step tutorial where each chapter takes your knowledge to the next level. The book covers practical knowledge with tips to implement this knowledge in real-world scenarios. A chapter with a real-life example is included to help you understand the concepts in fu...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing,
2013.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Getting Started with Impala; Impala requirements; Dependency on Hive for Impala; Dependency on Java for Impala; Hardware dependency; Networking requirements; User account requirements; Installing Impala; Installing Impala with Cloudera Manager; Installing Impala without Cloudera Manager; Configuring Impala after installation; Starting Impala; Stopping Impala; Restarting Impala; Upgrading Impala; Upgrading Impala using parcels with Cloudera Manager.
- Upgrading Impala using packages with Cloudera ManagerUpgrading Impala without Cloudera Manager; Impala core components; Impala daemon; Impala statestore; Impala metadata and metastore; The Impala programming interface; The Impala execution architecture; Working with Apache Hive; Working with HDFS; Working with HBase; Impala security; Authorization; The SELECT privilege; The INSERT privilege; The ALL privilege; Authentication through Kerberos; Auditing; Impala security guidelines for a higher level of protection; Summary; Chapter 2:The Impala Shell Commands and Interface.
- Using Cloudera Manager for ImpalaLaunching Impala shell; Connecting impala-shell to the remotely located impalad daemon; Impala-shell command-line options with brief explanations; General command-line options; Connection-specific options; Query-specific options; Secure connectivity-specific options; Impala-shell command reference; General commands; Query-specific commands; Table- and database-specific commands; Summary; Chapter 3:The Impala Query Language and Built-in Functions; Impala SQL language statements; Database-specific statements; The CREATE DATABASE statement.
- The DROP DATABASE statementThe SHOW DATABASES statement; Using database-specific query sentence in an example; Table-specific statements; The CREATE TABLE statement; The CREATE EXTERNAL TABLE statement; The ALTER TABLE statement; The DROP TABLE statement; The SHOW TABLES statement; The DESCRIBE statement; The INSERT statement; The SELECT statement; Internal and external tables; 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 ImpalaThe type conversion function; Unsupported SQL statements in Impala; Summary; Chapter 4:Impala Walkthrough with an Example; Creating an example scenario; Example dataset one
- automobiles (automobiles.txt); Example dataset two
- motorcycles (motorcycles.txt); Data and schema considerations; Commands for loading data into Impala tables; HDFS specific commands; Loading data into the Impala table from HDFS; Launching the Impala shell; Database and table specific commands; SQL queries against the example database; SQL join operation with the example database.