ORACLE的直连数据在数据里分组汇总使用去重计数是正常的，使用字符串拼接会报错缺失右括号RuntimeException: java.util.concurrent.ExecutionException: com.finebi.common.exception.conf.table.FineSqlErrorException: 错误代码:62400001The SQL : { -- USER_ID: f4218552-0777-4415-89d2-ff5bfe60bbd6
-- TABLE_NAMES: 613c8212118e4c88952d01d11f57a5ee
-- CATEGORY_ID: 613c8212118e4c88952d01d11f57a5ee
-- SUB_CATEGORY_ID: GROUP_1
select
"v0" "__fcol_4",
"v1" "__fcol_5",
"v2" "__fcol_6",
"v3" "__fcol_7"
from (
select
"x"."v0",
"x"."v1",
"x"."v2",
"x"."v3",
rownum "rn"
from (
select
"t0"."__fcol_0" "v0",
"t0"."__fcol_1" "v1",
"t0"."__fcol_2" "v2",
"t0"."__fcol_3" "v3"
from (
select
"T_59D2558E8C3E4337AE999"."EQUIPMENT_SUBTYPE_DESC" "__fcol_0",
"T_59D2558E8C3E4337AE999"."EQUIPMENT_ID" "__fcol_1",
count(distinct "T_59D2558E8C3E4337AE999"."TRANS_RRN") "__fcol_2",
substr(
listagg(distinct
"T_59D2558E8C3E4337AE999"."COMMENTS",
'/' on overflow truncate '' without count
),
1,
1000
) "__fcol_3"
from (select t.*,em.equipment_subtype_desc from EQUIPMENT_EVENT_HISTORY t
left join EQUIPMENT_MASTER em on em.equipment_rrn = t.equipment_rrn
where t.EQUIPMENT_STATUS1 = 'DOWN'
and t.STATUS_START_TIMESTAMP>=to_date('2024-10-21 15:33:11','yyyy-mm-dd hh24:mi:ss')
and t.STATUS_START_TIMESTAMP<=to_date('2025-01-22 15:33:11','yyyy-mm-dd hh24:mi:ss')
order by t.EQUIPMENT_ID DESC
) "T_59D2558E8C3E4337AE999"
group by
"T_59D2558E8C3E4337AE999"."EQUIPMENT_SUBTYPE_DESC",
"T_59D2558E8C3E4337AE999"."EQUIPMENT_ID"
) "t0"
) "x"
where rownum <= (0 + 5000)
)
where "rn" > 0
order by "rn" } is wrong, please check!ORA-00907: 缺失右括号
