Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Apache Hive Cookbook
  • Table Of Contents Toc
Apache Hive Cookbook

Apache Hive Cookbook

By : Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra
3 (4)
Buy this Book
close
close
Apache Hive Cookbook

Apache Hive Cookbook

3 (4)
By: Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra
Buy this Book

Overview of this book

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.
Table of Contents (14 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Sections
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Developing Hive
Icon
1. Developing Hive
Icon
Introduction
Icon
Deploying Hive on a Hadoop cluster
Icon
Deploying Hive Metastore
Icon
Installing Hive
Icon
Configuring HCatalog
Icon
Understanding different components of Hive
Icon
Compiling Hive from source
Icon
Hive packages
Icon
Debugging Hive
Icon
Running Hive
Icon
Changing configurations at runtime
2
2. Services in Hive
Icon
2. Services in Hive
Icon
Introducing HiveServer2
Icon
Understanding HiveServer2 properties
Icon
Configuring HiveServer2 high availability
Icon
Using HiveServer2 clients
Icon
Introducing the Hive metastore service
Icon
Configuring high availability of metastore service
Icon
Introducing Hue
3
3. Understanding the Hive Data Model
Icon
3. Understanding the Hive Data Model
Icon
Introduction
Icon
Using numeric data types
Icon
Using string data types
Icon
Using Date/Time data types
Icon
Using miscellaneous data types
Icon
Using complex data types
Icon
Using operators
Icon
Partitioning
Icon
Partitioning a managed table
Icon
Partitioning an external table
Icon
Bucketing
4
4. Hive Data Definition Language
Icon
4. Hive Data Definition Language
Icon
Introduction
Icon
Creating a database schema
Icon
Dropping a database schema
Icon
Altering a database schema
Icon
Using a database schema
Icon
Showing database schemas
Icon
Describing a database schema
Icon
Creating tables
Icon
Dropping tables
Icon
Truncating tables
Icon
Renaming tables
Icon
Altering table properties
Icon
Creating views
Icon
Dropping views
Icon
Altering the view properties
Icon
Altering the view as select
Icon
Showing tables
Icon
Showing partitions
Icon
Show the table properties
Icon
Showing create table
Icon
HCatalog
Icon
WebHCat
5
5. Hive Data Manipulation Language
Icon
5. Hive Data Manipulation Language
Icon
Introduction
Icon
Loading files into tables
Icon
Inserting data into Hive tables from queries
Icon
Inserting data into dynamic partitions
Icon
Writing data into files from queries
Icon
Enabling transactions in Hive
Icon
Inserting values into tables from SQL
Icon
Updating data
Icon
Deleting data
6
6. Hive Extensibility Features
Icon
6. Hive Extensibility Features
Icon
Introduction
Icon
Serialization and deserialization formats and data types
Icon
Exploring views
Icon
Exploring indexes
Icon
Hive partitioning
Icon
Creating buckets in Hive
Icon
Analytics functions in Hive
Icon
Windowing in Hive
Icon
File formats
7
7. Joins and Join Optimization
Icon
7. Joins and Join Optimization
Icon
Understanding the joins concept
Icon
Using a left/right/full outer join
Icon
Using a left semi join
Icon
Using a cross join
Icon
Using a map-side join
Icon
Using a bucket map join
Icon
Using a bucket sort merge map join
Icon
Using a skew join
8
8. Statistics in Hive
Icon
8. Statistics in Hive
Icon
Bringing statistics in to Hive
Icon
Table and partition statistics in Hive
Icon
Column statistics in Hive
Icon
Top K statistics in Hive
9
9. Functions in Hive
Icon
9. Functions in Hive
Icon
Using built-in functions
Icon
Using the built-in User-defined Aggregation Function (UDAF)
Icon
Using the built-in User Defined Table Function (UDTF)
Icon
Creating custom User-Defined Functions (UDF)
10
10. Hive Tuning
chevron up
Icon
10. Hive Tuning
Icon
Enabling predicate pushdown optimizations in Hive
Icon
Optimizations to reduce the number of map
Icon
Sampling
11
11. Hive Security
Icon
11. Hive Security
Icon
Securing Hadoop
Icon
Authorizing Hive
Icon
Configuring the SQL standards-based authorization
Icon
Authenticating Hive
12
12. Hive Integration with Other Frameworks
Icon
12. Hive Integration with Other Frameworks
Icon
Working with Apache Spark
Icon
Working with Accumulo
Icon
Working with HBase
Icon
Working with Google Drill
13
Index
Icon
Index

Sampling

In this recipe, you will learn how to sample data in Hive.

Getting ready

Sampling in Hive is a way to write queries on a small chunk of data instead of the entire table. This is required when you have a large dataset and you want to work on a small piece of that dataset. Sampling queries are most efficient when they are performed on bucketed column. Sampling is required when you just need to run queries on a smaller set of data instead of accuracy of the result set of the entire data. That is, it is mostly required for testing purposes. Sampling is most efficient when it is used for auditing purposes. In auditing, sampling can be used to pick a random set of rows or data with respect to the entire data that is huge in number.

Another use case is where you need to perform some aggregation-like average on a sample of data or smaller set of data, keeping aside the accuracy of the data.

To use this sampling feature in Hive, you need to use the TABLESAMPLE clause, which helps in writing...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Apache Hive Cookbook
End of Chapter 10
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon