[
https://issues.apache.org/jira/browse/KYLIN-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15353823#comment-15353823
]
Wang Ken commented on KYLIN-1833:
---------------------------------
What's the error? Do you mean the first parts of the union is not included in
the result?
> union operation will cause error result
> ---------------------------------------
>
> Key: KYLIN-1833
> URL: https://issues.apache.org/jira/browse/KYLIN-1833
> Project: Kylin
> Issue Type: Improvement
> Components: Query Engine
> Affects Versions: v1.3.0, v1.5.2
> Reporter: fengYu
> Assignee: fengYu
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)