You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Zhong Yanghong (Jira)" <ji...@apache.org> on 2020/07/03 10:25:00 UTC
[jira] [Updated] (KYLIN-4620) sum(expression) support should be
limited since it's not conform the associative law of addition in standard
sql
[ https://issues.apache.org/jira/browse/KYLIN-4620?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zhong Yanghong updated KYLIN-4620:
----------------------------------
Description:
In standard sql, there's an edge case for the calculation of expression for a single row. For example,
{code}
${col1} + ${col2}
{code}
if ${col1} or ${col2} is null, the result of this expression should be null. Therefore, the sum aggregation function does not conform the
> sum(expression) support should be limited since it's not conform the associative law of addition in standard sql
> ----------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-4620
> URL: https://issues.apache.org/jira/browse/KYLIN-4620
> Project: Kylin
> Issue Type: Improvement
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
> Priority: Major
>
> In standard sql, there's an edge case for the calculation of expression for a single row. For example,
> {code}
> ${col1} + ${col2}
> {code}
> if ${col1} or ${col2} is null, the result of this expression should be null. Therefore, the sum aggregation function does not conform the
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)