You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2016/09/23 10:14:20 UTC

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

     [ https://issues.apache.org/jira/browse/KYLIN-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

liyang resolved KYLIN-1833.
---------------------------
       Resolution: Fixed
    Fix Version/s: v1.5.4

> 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
>             Fix For: v1.5.4
>
>         Attachments: 0001-KYLIN-1833-union-query-get-error-result.patch
>
>
> 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)