[ 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)