【 TiDB 使用环境】生产环境 /测试/ Poc
【 TiDB 版本】v6.5.0
【复现路径】做过哪些操作出现的问题
用户上面编辑条件，后台拼接sql查询
SELECT
count(t.oneid)
FROM
(
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
B.ONEID
FROM
(
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
B.ONEID
FROM
(
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
ONEID,
count(DISTINCT event_id)
FROM
ads_nuza_event_detl_df
WHERE
1 = 1
AND (
attr_time1 BETWEEN ‘2021-01-01 00:00:00’
AND ‘2021-12-31 23:59:59’
)
AND event_type = “order”
AND obj_attr13 = “301”
GROUP BY
ONEID
HAVING
count(DISTINCT event_id) >= 1
) A
) A
UNION
ALL
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
ONEID,
count(DISTINCT event_id)
FROM
ads_nuza_event_detl_df
WHERE
1 = 1
AND (
attr_time1 BETWEEN ‘2022-01-01 00:00:00’
AND ‘2022-12-31 23:59:59’
)
AND event_type = “order”
AND obj_attr13 = “301”
GROUP BY
ONEID
HAVING
count(DISTINCT event_id) >= 1
) A
) B
GROUP BY
B.ONEID
HAVING
COUNT() > 1
) A
) A
UNION
ALL
SELECT
DISTINCT A.ONEID
FROM
(
SELECT
ONEID,
count(DISTINCT event_id)
FROM
ads_nuza_event_detl_df
WHERE
1 = 1
AND (
attr_time1 BETWEEN ‘2023-01-01 00:00:00’
AND ‘2023-04-30 23:59:59’
)
AND event_type = “order”
AND obj_attr13 = “301”
GROUP BY
ONEID
HAVING
count(DISTINCT event_id) >= 1
) A
) B
GROUP BY
B.ONEID
HAVING
COUNT() > 1
) A
) t;
【遇到的问题：问题现象及影响】
查询报错，查询性能慢
【资源配置】
这是我们的集群配置
【附件：截图/日志/监控】
以下是查询计划
执行计划.txt (31.2 KB)
