Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search 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 Essentials
  • Table Of Contents Toc
  • Feedback & Rating feedback
Apache Hive Essentials

Apache Hive Essentials

By : Dayong Du
4 (2)
Buy this Book
close
close
Apache Hive Essentials

Apache Hive Essentials

4 (2)
By: Dayong Du
Buy this Book

Overview of this book

If you are a data analyst, developer, or simply someone who wants to use Hive to explore and analyze data in Hadoop, this is the book for you. Whether you are new to big data or an expert, with this book, you will be able to master both the basic and the advanced features of Hive. Since Hive is an SQL-like language, some previous experience with the SQL language and databases is useful to have a better understanding of this book.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
Who this book is for
Icon
What this book covers
Icon
To get the most out of this book
Icon
Get in touch
Lock Free Chapter
1
Overview of Big Data and Hive
Icon
Overview of Big Data and Hive
Icon
A short history
Icon
Introducing big data
Icon
The relational and NoSQL databases versus Hadoop
Icon
Batch, real-time, and stream processing
Icon
Overview of the Hadoop ecosystem
Icon
Hive overview
Icon
Summary
2
Setting Up the Hive Environment
Icon
Setting Up the Hive Environment
Icon
Installing Hive from Apache
Icon
Installing Hive from vendors
Icon
Using Hive in the cloud
Icon
Using the Hive command
Icon
Using the Hive IDE
Icon
Summary
3
Data Definition and Description
Icon
Data Definition and Description
Icon
Understanding data types
Icon
Data type conversions
Icon
Data Definition Language
Icon
Database
Icon
Tables
Icon
Partitions
Icon
Buckets
Icon
Views
Icon
Summary
4
Data Correlation and Scope
Icon
Data Correlation and Scope
Icon
Project data with SELECT
Icon
Filtering data with conditions
Icon
Linking data with JOIN
Icon
Combining data with UNION
Icon
Summary
5
Data Manipulation
Icon
Data Manipulation
Icon
Data exchanging with LOAD
Icon
Data exchange with INSERT
Icon
Data exchange with [EX|IM]PORT
Icon
Data sorting
Icon
Functions
Icon
Transactions and locks
Icon
Summary
6
Data Aggregation and Sampling
Icon
Data Aggregation and Sampling
Icon
Basic aggregation
Icon
Enhanced aggregation
Icon
Aggregation condition
Icon
Window functions
Icon
Sampling
Icon
Summary
7
Performance Considerations
chevron up
Icon
Performance Considerations
Icon
Performance utilities
Icon
Design optimization
Icon
Data optimization
Icon
Job optimization
Icon
Summary
8
Extensibility Considerations
Icon
Extensibility Considerations
Icon
User-defined functions
Icon
HPL/SQL
Icon
Streaming
Icon
SerDe
Icon
Summary
9
Security Considerations
Icon
Security Considerations
Icon
Authentication
Icon
Authorization
Icon
Mask and encryption
Icon
Summary
10
Working with Other Tools
Icon
Working with Other Tools
Icon
The JDBC/ODBC connector
Icon
NoSQL
Icon
The Hue/Ambari Hive view
Icon
HCatalog
Icon
Oozie
Icon
Spark
Icon
Hivemall
Icon
Summary
11
Other Books You May Enjoy
Icon
Other Books You May Enjoy
Icon
Leave a review - let other readers know what you think

Performance utilities

Hive provides the EXPLAIN and ANALYZE statements that can be used as utilities to check and identify the performance of queries.

The EXPLAIN statement

Hive provides an EXPLAIN command to return a query execution plan without running the query. We can use an EXPLAIN command for queries if we have a doubt or a concern about performance. The EXPLAIN command will help to see the difference between two or more queries for the same purpose. The syntax for EXPLAIN is as follows:

EXPLAIN [EXTENDED|DEPENDENCY|AUTHORIZATION] hive_query

The following keywords can be used:

  • EXTENDED: This provides additional information for the operators in the plan, such as file pathname and abstract syntax tree.

  • DEPENDENCY: This provides a JSON format output that contains a list of tables and partitions that the query depends on. It is available since HIVE 0.10.0.

  • AUTHORIZATION: This lists all entities needed to be authorized including input and output to run the Hive query and authorization failures...

Visually different images
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 Essentials
End of Section 7
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options
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