[HIVE-8385] UNION Operator in Hive - ASF JIRA

Log work

Agile Board

Rank to Top

Rank to Bottom

Bulk Copy Attachments

Bulk Move Attachments

Voters

Watch issue

Watchers

Create sub-task

Convert to sub-task

Move

Link

Clone

Labels

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Improvement
Status: Closed
Priority: Major
Resolution: Duplicate
Affects Version/s: None
Fix Version/s: 1.2.0
Component/s: SQL
Labels:
None

Description

While Hive has UNION ALL feature, it results in duplicate records and customers have to write another complex query or MapReduce job to Dedup the duplicate records. UNION feature is must have in Hive as it is in all SQL RDBMS as well as in Apache Impala.

Not sure how much effort will it take given the fact that UNION ALL is already available.