Chapter 4. Data Selection and Scope
This chapter is about how to discover the data by querying the data, linking the data, and limiting the data ranges or scopes. The chapter mainly covers the syntax and usage of Hive SELECT
, WHERE
, LIMIT
, JOIN
, and UNION ALL
to operate datasets.
In this chapter we will cover the following topics:
- The
SELECT
statement - The common
JOIN
statement - The special
JOIN
(MAPJOIN
) statement - The set operation statement (
UNION ALL
)