clickhouse不支持事务
begin end这种没法用
<update id="updateEndTime" parameterType="java.util.Map">
BEGIN
<foreach collection="mergeMap.entrySet()" item="value" index="key" separator="">
UPDATE T_ALARM_INFO
SET
<if test="value!=null">
END_TIME = #{value}
</if>
WHERE ID = #{key};
</foreach>
END
</update>
改成
注意clickhouse中药换成小写
alter TABLE CLOUD_NETWORK_VISUAL.T_ALARM_INFO
update
end_time = '2025-07-31 09:37:00.000'
WHERE id = '123';
浙公网安备 33010602011771号