Apache Hive Cookbook
eBook - ePub

Apache Hive Cookbook

  1. 268 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub
Book details
Book preview
Table of contents
Citations

About This Book

Easy, hands-on recipes to help you understand Hive and its integration with frameworks that are used widely in today's big data world

About This Book

  • Grasp a complete reference of different Hive topics.
  • Get to know the latest recipes in development in Hive including CRUD operations
  • Understand Hive internals and integration of Hive with different frameworks used in today's world.

Who This Book Is For

The book is intended for those who want to start in Hive or who have basic understanding of Hive framework. Prior knowledge of basic SQL command is also required

What You Will Learn

  • Learn different features and offering on the latest Hive
  • Understand the working and structure of the Hive internals
  • Get an insight on the latest development in Hive framework
  • Grasp the concepts of Hive Data Model
  • Master the key concepts like Partition, Buckets and Statistics
  • Know how to integrate Hive with other frameworks such as Spark, Accumulo, etc

In Detail

Hive was developed by Facebook and later open sourced in Apache community. Hive provides SQL like interface to run queries on Big Data frameworks. Hive provides SQL like syntax also called as HiveQL that includes all SQL capabilities like analytical functions which are the need of the hour in today's Big Data world.

This book provides you easy installation steps with different types of metastores supported by Hive. This book has simple and easy to learn recipes for configuring Hive clients and services. You would also learn different Hive optimizations including Partitions and Bucketing. The book also covers the source code explanation of latest Hive version.

Hive Query Language is being used by other frameworks including spark. Towards the end you will cover integration of Hive with these frameworks.

Style and approach

Starting with the basics and covering the core concepts with the practical usage, this book is a complete guide to learn and explore Hive offerings.

Frequently asked questions

Simply head over to the account section in settings and click on ā€œCancel Subscriptionā€ - itā€™s as simple as that. After you cancel, your membership will stay active for the remainder of the time youā€™ve paid for. Learn more here.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlegoā€™s features. The only differences are the price and subscription period: With the annual plan youā€™ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, weā€™ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Apache Hive Cookbook by Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Mining. We have over one million books available in our catalogue for you to explore.

Information

Year
2016
ISBN
9781782161080
Edition
1

Apache Hive Cookbook


Table of Contents

Apache Hive Cookbook
Credits
About the Authors
About the Reviewer
www.PacktPub.com
eBooks, discount offers, and more
Why Subscribe?
Preface
What this book covers
What you need for this book
Who this book is for
Sections
Getting ready
How to do itā€¦
How it worksā€¦
There's moreā€¦
See also
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
1. Developing Hive
Introduction
Deploying Hive on a Hadoop cluster
Getting ready
How to do it...
How it worksā€¦
Deploying Hive Metastore
Getting ready
How to do itā€¦
Installing Hive
Getting ready
How to do itā€¦
Hive with an embedded metastore
Hive with a local metastore
Hive with a remote metastore
Configuring HCatalog
Getting ready
How to do it...
Understanding different components of Hive
HiveServer
Hive metastore
How to do it...
HiveServer2
How to do it...
Hive clients
Hive CLI
Getting ready
How to do it...
Beeline
Getting ready
How to do it...
Compiling Hive from source
Getting ready
How to do it...
Hive packages
Getting ready
How to do it...
Debugging Hive
Getting ready
How to do it...
Running Hive
Getting ready
How to do it...
Changing configurations at runtime
How to do it...
2. Services in Hive
Introducing HiveServer2
How to do itā€¦
How it worksā€¦
See also
Understanding HiveServer2 properties
How to do itā€¦
How it worksā€¦
See also
Configuring HiveServer2 high availability
Getting ready
How to do itā€¦
How it worksā€¦
See also
Using HiveServer2 clients
Getting ready
How to do itā€¦
Beeline
Beeline command options
JDBC
JDBC client sample code using Eclipse
Running the JDBC sample code from the command-line
JDBC datatypes
Other clients
Introducing the Hive metastore service
How to do itā€¦
How it worksā€¦
Configuring high availability of metastore service
How to do itā€¦
Introducing Hue
Getting ready
How to do itā€¦
Prepare dependencies
Downloading and installing Hue
Configuring Hive with Hue
Starting Hue
Accessing Hive with Hue
3. Understanding the Hive Data Model
Introduction
Introducing data types
Primitive data types
Complex data types
Using numeric data types
How to do itā€¦
Using string data types
How to do itā€¦
How it worksā€¦
Using Date/Time data types
How to do itā€¦
Using miscellaneous data types
How to do itā€¦
Using complex data types
How to do itā€¦
Using operators
Using relational operators
How to do itā€¦
Using arithmetic operators
How to do itā€¦
Using logical operators
How to do itā€¦
Using complex operators
How to do itā€¦
Partitioning
Getting ready
How to do itā€¦
Partitioning a managed table
How to do itā€¦
Adding new partitions
Renaming partitions
Exchanging partitions
Dropping the partitions
Loading data in a managed partitioned table
Partitioning an external table
How to do itā€¦
Bucketing
Getting ready
How to do itā€¦
How it worksā€¦
4. Hive Data Definition Language
Introduction
Creating a database schema
Getting ready
How to do itā€¦
Dropping a database schema
Getting ready
How to do itā€¦
Altering a database schema
Getting ready
How to do itā€¦
Using a database schema
Getting ready
How to do itā€¦
Showing database schemas
Getting ready
How to do itā€¦
Describing a database schema
Getting ready
How to do itā€¦
Creating tables
How to do itā€¦
Create table LIKE
How it works
Dropping tables
Getting ...

Table of contents

  1. Apache Hive Cookbook