[KYLIN-1833] union operation will cause error result

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v1.3.0, v1.5.2
• Fix Version/s: v1.5.4
• Component/s: Query Engine
• Assignee: fengYu
• Reporter: fengYu
• Created: 28/Jun/16 08:24
• Updated: 23/Sep/16 10:13
• Resolved: 23/Sep/16 10:13

Description

query like this will get error result :

select * from (
select 'b', count(1) from kylin_sales where lstg_format_name >= 'Auction'
union all
select 'a', count(1) from kylin_sales where lstg_format_name >= 'Others'
union all
select 'c', count(1) from kylin_sales where lstg_format_name >= 'FP-GTC'
) order by 1

Issue Links

• is duplicated by: KYLIN-1206 Support "UNION" in query