Set operation – UNION ALL
To operate the result set vertically, Hive only supports UNION ALL
right now. And, the result set of UNION ALL
keeps duplicates if any. Before Hive 0.13.0, UNION ALL
can only be used in the subquery. Since Hive 0.13.0, UNION ALL
can also be used in top-level queries. The following are examples of the UNION ALL
statements:
- Check the
name
column in theemployee_hr
andemployee
table:jdbc:hive2://> SELECT name FROM employee_hr; +----------+ | name | +----------+ | Michael | | Will | | Steven | | Lucy | +----------+ 4 rows selected (0.116 seconds) jdbc:hive2://> SELECT name FROM employee; +----------+ | name | +----------+ | Michael | | Will | | Shelley | | Lucy | +----------+ 4 rows selected (0.049 seconds)
- Use
UNION
on the ...
Get Apache Hive Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.