Edward Capriolo

Programming Hive (eBook, ePUB)

Data Warehouse and Query Language for Hadoop

• Format: ePub

Produktbeschreibung

Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoops data warehouse infrastructure. Youll quickly learn how to use Hives SQL dialectHiveQLto summarize, query, and analyze large datasets stored in Hadoops distributed filesystem.This example-driven guide shows you how to set up and configure Hive in your environment, provides a detailed overview of Hadoop and MapReduce, and demonstrates how Hive works within the Hadoop ecosystem. Youll also find real-world case studies that describe how companies have used Hive to solve unique problems involving petabytes of data.Use Hive to create, alter, and drop databases, tables, views, functions, and indexesCustomize data formats and storage options, from files to external databasesLoad and extract data from tablesand use queries, grouping, filtering, joining, and other conventional query methodsGain best practices for creating user defined functions (UDFs)Learn Hive patterns you should use and anti-patterns you should avoidIntegrate Hive with other data processing programsUse storage handlers for NoSQL databases and other datastoresLearn the pros and cons of running Hive on Amazons Elastic MapReduce

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 350
• Erscheinungstermin: 19. September 2012
• Englisch
• ISBN-13: 9781449326975
• Artikelnr.: 38311486

Autorenporträt

Edward Capriolo is currently System Administrator at Media6degrees where he helps design and maintain distributed data storage systems for the internet advertising industry. Edward is a member of the Apache Software Foundation and a committer for the Hadoop-Hive project. He has experience as a developer as well Linux and network administrator and enjoys the rich world of open source software.

Inhaltsangabe

Preface
Chapter 1: Introduction
Chapter 2: Getting Started
Chapter 3: Data Types and File Formats
Chapter 4: HiveQL: Data Definition
Chapter 5: HiveQL: Data Manipulation
Chapter 6: HiveQL: Queries
Chapter 7: HiveQL: Views
Chapter 8: HiveQL: Indexes
Chapter 9: Schema Design
Chapter 10: Tuning
Chapter 11: Other File Formats and Compression
Chapter 12: Developing
Chapter 13: Functions
Chapter 14: Streaming
Chapter 15: Customizing Hive File and Record Formats
Chapter 16: Hive Thrift Service
Chapter 17: Storage Handlers and NoSQL
Chapter 18: Security
Chapter 19: Locking
Chapter 20: Hive Integration with Oozie
Chapter 21: Hive and Amazon Web Services (AWS)
Chapter 22: HCatalog
Chapter 23: Case Studies
Glossary
References
Colophon