Programming Hive

Need to move a relational database application to Hadoop? This comprehensive guide introduces you to Apache Hive, Hadoop's data warehouse infrastructure. You'll quickly learn how to use Hive's SQL dialect-HiveQL-to summarize, query, and analyze large datasets stored in Hadoop's 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.
You'll 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 indexes - Customize data formats and storage options, from files to external databases - Load and extract data from tables-and use queries, grouping, filtering, joining, and other conventional query methods - Gain best practices for creating user defined functions (UDFs) - Learn Hive patterns you should use and anti-patterns you should avoid - Integrate Hive with other data processing programs - Use storage handlers for NoSQL databases and other datastores - Learn the pros and cons of running Hive on Amazon's Elastic MapReduce