[ https://issues.apache.org/jira/browse/KYLIN-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15362468#comment-15362468 ]
liyang commented on KYLIN-1833: ------------------------------- Does 1.5 has the same problem? > 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 > 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)