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/07/05 13:15:11 UTC
[jira] [Commented] (KYLIN-1833) union operation will cause error
result
[ 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)