Dive into the world of SQL on Hadoop and get the most out of your Hive data warehouses. This book is your go-to resource for using Hive: authors Scott Shaw, Ankur Gupta, David Kjerrumgaard, and Andreas Francois Vermeulen take 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, Tez and other big data technologies, Practical Hive gives you a detailed treatment of the software.In addition, this book discusses the value of open source software, Hive performance tuning, and how to leverage semi-structured and unstructured data. What You Will LearnInstall and configure Hive for new and existing datasetsPerform DDL operationsExecute efficient DML operationsUse tables, partitions, buckets, and user-defined functionsDiscover performance tuning tips and Hive best practicesWho This Book Is ForDevelopers, companies, and professionals who deal with large amounts of data and could use software that can efficiently manage large volumes of input. It is assumed that readers have the ability to work with SQL.
Erscheinungsdatum: 28.08.2016

Shaw, Scott, author; Vermeulen, Andreas François, author; Gupta, Ankur, 1978- author; Kjerrumgaard, David, author

Scott Shaw; Cindy Gross; Ankur Gupta

New York, NY: Apress

Apress, Incorporated

United States, United States of America

Berkeley, CA, 2016

1st ed., FR, 2016

Aug 28, 2016

Dive into the world of SQL on Hadoop and get the most out of your Hive data warehouses. This book is your go-to resource for using Hive: authors Scott Shaw, Ankur Gupta, David Kjerrumgaard, and Andreas Francois Vermeulen take 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, Tez and other big data technologies, Practical Hive gives you a detailed treatment of the software. In addition, this book discusses the value of open source software, Hive performance tuning, and how to leverage semi-structured and unstructured data. What You Will Learn Install and configure Hive for new and existing datasets Perform DDL operations Execute efficient DML operations Use tables, partitions, buckets, and user-defined functions Discover performance tuning tips and Hive best practices Who This Book Is 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 is assumed that readers have the ability to work with SQL.

"Authors take 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."-- Provided by publisher

Scott Shaw, Andreas Franc�ʹois Vermeulen, Ankur Gupta, David Kjerrumgaard.

xxi, 265 pages : 26 cm
Includes index

2024-11-05