Liu Zhao created KYLIN-5472: ------------------------------- Summary: 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.3, v4.0.2, v4.0.1 Reporter: Liu Zhao 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)