Getting Started with Impala

Interactive SQL for Apache Hadoop

John Russell (Autor)

Buch | Softcover

110 Seiten

2014
O'Reilly Media (Verlag)
978-1-4919-0577-7 (ISBN)

Artikel merken

Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala—the massively parallel processing SQL query engine for Apache Hadoop. The best practices in this practical guide help you design database schemas that not only interoperate with other Hadoop components, and are convenient for administers to manage and monitor, but also accommodate future expansion in data size and evolution of software capabilities.

Ideal for database developers and business analysts, Getting Started with Impala includes advice from Cloudera’s development team, as well as insights from its consulting engagements with customers.

Learn how Impala integrates with a wide range of Hadoop components
Attain high performance and scalability for huge data sets on production clusters
Explore common developer tasks, such as porting code to Impala and optimizing performance
Use tutorials for working with billion-row tables, date- and time-based values, and other techniques
Learn how to transition from rigid schemas to a flexible model that evolves as needs change
Take a deep dive into joins and the roles of statistics

John Russell is a software developer and technical writer, and he's currently the documentation lead for the Cloudera Impala project. He has a broad range of database and SQL experience from previous roles on industry-leading teams. For DB2, he designed and coded the very first Information Center. For Oracle Database, he documented application development subjects and designed and coded the Project Tahiti doc search engine. For MySQL, he documented the InnoDB storage engine. Originally from Newfoundland, Canada, John now resides in Berkeley, California.

Chapter 1Why Impala?
Impala’s Place in the Big Data Ecosystem
Flexibility for Your Big Data Workflow
High-Performance Analytics
Exploratory Business Intelligence
Chapter 2Getting Up and Running with Impala
Installation
Connecting to Impala
Your First Impala Queries
Chapter 3Impala for the Database Developer
The SQL Language
Big Data Considerations
How Impala Is Like a Data Warehouse
Physical and Logical Data Layouts
Distributed Queries
Normalized and Denormalized Data
File Formats
Aggregation
Chapter 4Common Developer Tasks for Impala
Getting Data into an Impala Table
Porting SQL Code to Impala
Using Impala from a JDBC or ODBC Application
Using Impala with a Scripting Language
Optimizing Impala Performance
Writing User-Defined Functions
Collaborating with Your Administrators
Chapter 5Tutorials and Deep Dives
Tutorial: From Unix Data File to Impala Table
Tutorial: Queries Without a Table
Tutorial: The Journey of a Billion Rows
Deep Dive: Joins and the Role of Statistics
Anti-Pattern: A Million Little Pieces
Tutorial: Across the Fourth Dimension
Tutorial: Verbose and Quiet impala-shell Output
Tutorial: When Schemas Evolve
Tutorial: Levels of Abstraction

Erscheint lt. Verlag	4.11.2014
Zusatzinfo	black & white illustrations
Verlagsort	Sebastopol
Sprache	englisch
Maße	183 x 233 mm
Gewicht	198 g
Einbandart	kartoniert
Themenwelt	Informatik ► Datenbanken ► SQL Server
Schlagworte	Big Data • Hadoop • SQL
ISBN-10	1-4919-0577-8 / 1491905778
ISBN-13	978-1-4919-0577-7 / 9781491905777
Zustand	Neuware