[jira] [Commented] (KYLIN-1833) union operation will cause error result

["Wang Ken (JIRA)" <ji...@apache.org>]

    [ 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)