简单测试了下你指定的sql块 ，并没有报错，你可以提供表结构和sql，我们验证下

/+GROUP_OPT_FLAG(1)/ sql前加这个hint试试，如果有效，可以修改对应的dm.ini中的值
SP_SET_PARA_VALUE(1,‘GROUP_OPT_FLAG’,1);

select * from (
select WATER_CONSUMER_ID,
       sum(use_amount) as sum_use_amount
from b_water_consumer_usage_record
where "MONTH" between '202105' and '202106'
and use_amount > 0
group by WATER_CONSUMER_ID
) where sum_use_amount >=5000

可以试试去掉having，将条件放在外层