- 268 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Apache Hive Cookbook
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.
Tools to learn more effectively
Saving Books
Keyword Search
Annotating Text
Listen to it instead
Information
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
- Apache Hive Cookbook
Frequently asked questions
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
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 990+ topics, weāve got you covered! Learn about our mission
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 about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere ā even offline. Perfect for commutes or when youāre on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
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.