[
https://issues.apache.org/jira/browse/KYLIN-3359?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-3359:
----------------------------------
Description:
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.
was:
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
> 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
>
> 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)
