kylin-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (KYLIN-3359) Support sum(expression) if possible
Date Sat, 26 May 2018 13:03:00 GMT

    [ https://issues.apache.org/jira/browse/KYLIN-3359?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16491648#comment-16491648
] 

ASF subversion and git services commented on KYLIN-3359:
--------------------------------------------------------

Commit 28df046a00b7bad9fc71fdb2642d811ba94de237 in kylin's branch refs/heads/KYLIN-3359 from
Zhong
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=28df046 ]

APACHE-KYLIN-3359 minor fix

Signed-off-by: shaofengshi <shaofengshi@apache.org>


> Support sum(expression) if possible
> -----------------------------------
>
>                 Key: KYLIN-3359
>                 URL: https://issues.apache.org/jira/browse/KYLIN-3359
>             Project: Kylin
>          Issue Type: Sub-task
>            Reporter: Zhong Yanghong
>            Assignee: Zhong Yanghong
>            Priority: Major
>         Attachments: KYLIN-3359-Hive-query.png, KYLIN-3359-Kylin-query.png
>
>
> The expression can be as follows:
>  # a ~1~*col ~1~ + a ~2~*col ~2~ + ... + a ~n~*col ~n~ + b, if sum(col ~1~),sum(col ~2~),...sum(col
~n~) are defined
>  # case when {{filter}} ~1~ then expr ~1~
>  when {{filter}} ~2~ then expr ~2~
>  ...
>  else expr ~N~
>  end, if {{filter}} ~1~,{{filter}} ~2~, ... {{filter}} ~N-1~, and expr ~1~,expr ~2~,...expr
~N~ are supported 
> There's a constraint for the filter. That is it's able to push down the related filters
in case when.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message