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 Essentials
  • Table Of Contents Toc
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
chevron up
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
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

ORDER and SORT

Another aspect to manipulate data in Hive is to properly order or sort the data or result sets to clearly identify the important facts, such as top N values, maximum, minimum, and so on.

There are the following keywords used in Hive to order and sort data:

  • ORDER BY (ASC|DESC): This is similar to the RDBMS ORDER BY statement. A sorted order is maintained across all of the output from every reducer. It performs the global sort using only one reducer, so it takes a longer time to return the result. Usage with LIMIT is strongly recommended for ORDER BY. When hive.mapred.mode = strict (by default, hive.mapred.mode = nonstrict) is set and we do not specify LIMIT, there are exceptions. This can be used as follows:

    jdbc:hive2://> SELECT name FROM employee ORDER BY NAME DESC;
+----------+
|   name   |
+----------+
| Will     |
| Shelley  |
| Michael  |
| Lucy     |
+----------+
4 rows selected (57.057 seconds)

  • SORT BY (ASC|DESC): This indicates which columns to sort when ordering...

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 Chapter 5
Next Chapter
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