You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Liu Zhao (Jira)" <ji...@apache.org> on 2023/03/02 12:32:00 UTC
[jira] [Assigned] (KYLIN-5472) Prompt CUBE when performing sum or count aggregation operations on the derived column_ UNMATCHED_ AGGREGATION[FunctionDesc [expression=SUM, parameter=2_2231359f:xxx, returnType=null]]
[ https://issues.apache.org/jira/browse/KYLIN-5472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Liu Zhao reassigned KYLIN-5472:
-------------------------------
Assignee: Liu Zhao
> Prompt CUBE when performing sum or count aggregation operations on the derived column_ UNMATCHED_ AGGREGATION[FunctionDesc [expression=SUM, parameter=2_2231359f:xxx, returnType=null]]
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: KYLIN-5472
> URL: https://issues.apache.org/jira/browse/KYLIN-5472
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v4.0.1, v4.0.2, v4.0.3
> Reporter: Liu Zhao
> Assignee: Liu Zhao
> Priority: Major
> Attachments: image-2023-03-02-20-31-06-702.png
>
>
> kylin4.x 在derived列上做sum、count聚合运算时提示 CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM, parameter=2_2231359f:xxx, returnType=null]]，在kylin2上可以。
> 见：
> org.apache.kylin.cube.CubeCapabilityChecker#tryDimensionAsMeasures方法
> root cause：
> FunctionDesc.BUILT_IN_AGGREGATIONS 中缺失SUM, COUNT，在低版本kylin2上是有的。初步在4上把SUM, COUNT 添加到 FunctionDesc.BUILT_IN_AGGREGATIONS 查询成功结果符合预期。
> 为什么在kylin4上FunctionDesc.BUILT_IN_AGGREGATIONS中没有这两个函数？是升级时弄丢了还是有什么其它原因考虑？
> !image-2023-03-02-20-31-06-702.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)