Programming Hive: Data Warehouse and Query Language for Hadoop

Programming Hive: Data Warehouse and Query Language for Hadoop"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."margin top: 4px; margin bottom: 14px; padding: 0px; font family: Arial, sans serif; line height: 22. 4px; text align: justify; background color: rgb(255,

"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."margin-top: -4px; margin-bottom: 14px; padding: 0px; font-family: Arial, sans-serif; line-height: 22.4px; text-align: justify; background-color: rgb(255, 255, 255);"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 petates 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 tablesand 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 Amazons Elastic MapReduce