Getting Started with Impala - John Russell

Getting Started with Impala

Interactive SQL for Apache Hadoop

(Autor)

Buch | Softcover
110 Seiten
2014
O'Reilly Media (Verlag)
978-1-4919-0577-7 (ISBN)
26,90 inkl. MwSt
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
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich
Der schnelle Einstieg

von Klemens Konopasek

Buch (2018)
Carl Hanser (Verlag)
40,00
Das umfassende Handbuch. Inkl. Analysis und Reporting Services

von Daniel Caesar; Michael R. Friebel; Hans Georg Selent-Knips

Buch | Hardcover (2020)
Rheinwerk (Verlag)
49,90