Getting Started with Impala

Getting Started with Impala

4.11 - 1251 ratings - Source

Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impalaa€”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 Clouderaa€™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 statisticsImpala INSERT syntax lets you work with one partition at a time: CREATE TABLE raw_data (year SMALLINT, month TINYINT, ... INSERT INTO partitioned_table PARTITION (year=2000, month=1) SELECT c1, c2, c3 FROM raw_data WHEREanbsp;...

Title:Getting Started with Impala
Author:John Russell
Publisher:"O'Reilly Media, Inc." - 2014-09-25


You Must CONTINUE and create a free account to access unlimited downloads & streaming