You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "fengYu (JIRA)" <ji...@apache.org> on 2016/09/21 11:50:20 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=15509668#comment-15509668 ]
fengYu commented on KYLIN-1833:
-------------------------------
I am working for this problem currently for kylin-2.x
> 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)