[IMPALA-1379] LIMIT should apply to the total result set after UNION

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.0
• Component/s: Frontend
• Labels: incompatibility ramp-up
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: casey
• Created: 10/Oct/14 01:59
• Updated: 18/Jun/17 00:40
• Resolved: 18/Jun/17 00:40

Description

The query below produces only 1 row in both Postgresql and Mysql

Query: select int_col from alltypestiny union all select int_col from alltypestiny limit 1
+---------+
| int_col |
+---------+
| 0       |
| 1       |
| 0       |
| 1       |
| 0       |
| 0       |
| 1       |
| 0       |
| 1       |
+---------+
Fetched 9 row(s) in 0.46s

Impala applies the LIMIT to the bottom query in the UNION instead of the overall query result.

Issue Links

• is duplicated by: IMPALA-4741 ORDER BY behavior with UNION is incorrect