Programming Hive: Data Warehouse and Query Language for Hadoop - Softcover

Edward Capriolo; Dean Wampler

Softcover

ISBN 10: 9350239140 ISBN 13: 9789350239148

Publisher: Shroff - O'Reilly, 2012

Synopsis

About the Book: Programming Hive: Data Warehouse and QueryLanguage for Hadoop Need to move a relational database application to Hadoop?Thiscomprehensive guide introduces you to Apache Hive, Hadoopsdatawarehouse infrastructure. Youll quickly learn how to use HivesSQLdialect-HiveQL-to summarize, query, and analyze largedatasetsstored in Hadoops distributed filesystem. This example-driven guide shows you how to set up andconfigureHive in your environment, provides a detailed overview ofHadoopand MapReduce, and demonstrates how Hive works within theHadoopecosystem. Youll also find real-world case studies thatdescribehow companies have used Hive to solve unique problemsinvolvingpetabytes of data. Use Hive to create, alter, and drop databases, tables,views,functions, and indexes Customize data formats and storage options, from filestoexternal databases Load and extract data from tables-and use queries,grouping,filtering, joining, and other conventional querymethods Gain best practices for creating user definedfunctions(UDFs) Learn Hive patterns you should use and anti-patterns youshouldavoid Integrate Hive with other data processing programs Use storage handlers for NoSQL databases and otherdatastores Learn the pros and cons of running Hive on AmazonsElasticMapReduce Contents 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 Appendix References Colop

Edition details

• Publisher: Shroff - O'Reilly
• Publication date: 2012
• ISBN 10: 9350239140
• ISBN 13: 9789350239148
• Binding: Paperback
• Language: English
• Edition number: 1
• Number of pages: 368