Practical Hive: A Guide to Hadoop's Data Warehouse System

Practical Hive is your go-to resource for moving traditional relational databases into Hive, a Hadoop-based data warehousing product.

Author Scott Shaw, an eminent big data expert, takes you through learning HiveQL, the SQL-like language specific to Hive, to analyze, export, and massage the data stored across your Hadoop environment. From deploying Hive on your hardware or virtual machine and setting up its initial configuration to learning how Hive interacts with Hadoop, MapReduce, and other big data technologies, Practical Hive gives you a detailed treatment of the software.

In addition, the latter portion of the book includes detailed, real-world case studies grounded in everyday Hive deployments that will show you how others have coaxed the most out of their Hive data warehouses.

Inside the book, author Scott Shaw provides:

• instructions for installation and configuration of Hive for new and existing datasets
• a step-by-step walkthrough of how to perform DDL Operations
• guidance on efficiently executing DML Operations
• Detailed descriptions of uses for and instruction on tables, particians, buckets, user-defined functions
• a comprehensive study of QL and SQL operations with Hive
• case studies of successful Hive implementations

Practical Hive is intended for developers, companies and professionals who deal with large amounts of data and could use software that can efficiently manage large volumes of input. It showcases how to effectively use Hive, so that it will be practical even to readers with high levels of experience using the software. It is assumed that readers have the ability to work with SQL.