[Bug]透视表总计，使用doris数据源时，后台生成的SQL丢失group by 导致数据加载异常
Author: liuboF2cCreated Sep 10, 2026Updated Sep 15, 2026
Labels类型:bug
DataEase 版本 v2.10.26
运行方式(安装包运行 or 源码运行 ?) 整包安装
浏览器版本 Chrome 最新
Bug 描述 当透视表总计包含窗口函数、使用doris数据源时，后台生成的SQL丢失 group by 导致数据加载异常。 ❗️同样的语法使用mysql没有问题。
Bug 重现步骤(有截图更好) 1.测试数据： 其中， 「占比」为计算字段，表达式：SUM([speach_time]) / SUM(SUM([speach_time])) OVER (PARTITION BY [name_copy]) 「name_copy」为「name」字段复制后转换为指标字段
3.给透视表配置自定义汇总
表达式：SUM([speach_time]) /SUM(SUM([speach_time])) OVER(PARTITION BY [name_copy])
配置后需要点击一次“更新图表数据”
4.点击更新图表数据，出现报错
5.对比后台日志中的SQL，发现doris的SQL丢失了group by doris异常SQL
SELECT
*
FROM
(
SELECT
CAST(
SUM(`t_a_0`.`f_c1f36c244f9efd5a`) / SUM(SUM(`t_a_0`.`f_c1f36c244f9efd5a`)) OVER (PARTITION BY (`t_a_0`.`f_82aa3ffb2f22992b`)) AS DECIMAL (26, 8)
) AS `f_ay_0`
FROM
(
SELECT
t_a_0.`_DE_SYNC_DEFAULT_PRIMARY_ID_` AS `f_70a4f7c3faf968fc`,
t_a_0.`name` AS `f_82aa3ffb2f22992b`,
t_a_0.`category` AS `f_3dd945a78bd6f6b1`,
t_a_0.`order_count` AS `f_b06b94409a5d43bb`,
t_a_0.`amount` AS `f_8b8319a82a24efa6`,
t_a_0.`speach_time` AS `f_c1f36c244f9efd5a`,
t_a_0.`_DE_SYNC_INSERT_TIME_` AS `f_8a15953c68183ce8`
FROM
`excel_Sheet1_0f25bedb56_1` t_a_0
) AS `t_a_0`
) AS `t_a_1`
ORDER BY
`f_ay_0`
LIMIT 1000 OFFSET 0 MySQL正常SQL
SELECT
*
FROM
(
SELECT
`t_a_0`.`f_2b6d6fa32153e61e` AS `f_ax_0`,
`t_a_0`.`f_0fc6060712616d74` AS `f_ax_1`,
CAST(
SUM(`t_a_0`.`f_e791f903fd2416b6`) / SUM(SUM(`t_a_0`.`f_e791f903fd2416b6`)) OVER (PARTITION BY (`t_a_0`.`f_0fc6060712616d74`)) AS DECIMAL (26, 8)
) AS `f_ay_0`
FROM
(
SELECT
t_a_0.`账号名称` AS `f_0fc6060712616d74`,
t_a_0.`类目` AS `f_2b6d6fa32153e61e`,
t_a_0.`单数` AS `f_41d79fcc93198673`,
t_a_0.`金额` AS `f_912da3032173e5eb`,
t_a_0.`时长` AS `f_e791f903fd2416b6`
FROM
`excel_sheet1_0f25bedb56` t_a_0
) AS `t_a_0`
GROUP BY
`t_a_0`.`f_2b6d6fa32153e61e`,
`t_a_0`.`f_0fc6060712616d74`
) AS `t_a_1`
LIMIT 1000 OFFSET 0Source: dataease/dataease