Apache Doris 中文技术论坛
Questions Tags Users Badges

Doris 2.1.9 count(DISTINCT IF(sum(ActualPrice)>0,PatientId,null)) 无法执行

Asked Apr 24 Modified Jan 1, 0001
Viewed 48
2.1 demand

edited Jan 1, 0001
Zack1
asked Apr 24
1 Answers

一般情况下,不能直接把聚合函数嵌套在条件函数里当作条件判断使用,因为聚合函数要在分组操作之后才能计算出结果,而条件判断是在分组操作之前进行的。

edited Jan 1, 1970
徐振超@SelectDB7976
answered Apr 25
Related Questions
Doris 2.1.7-rc03 BE 扩容
1 answers
doris2.1.4 8030端口异常退出
1 answers
information_schema中的表比官网很少
1 answers
Doris 2.1.11版本 自增列插入问题
1 answers
MOW主键表查询DeleteBitmapGetAggTime耗时高
1 answers
Doris 2.1.5 process memory used 38.63 GB exceed limit 452.92 GB or sys available memory 389.51 GB less than low water mark 6.40 GB.
1 answers

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.