[jira] [Created] (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]]

["Liu Zhao (Jira)" <ji...@apache.org>]

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)