流计算,在开源版本里可以运行,云服务上就不行了

create stream jiayao_energy_2025.sm_meter_10m_history interval(10m) sliding (10m)
from
jiayao_energy_2025.super_meter_data partition by tbname,
meter_code,
project_code stream_options(fill_history(‘2025-12-15 00:00:00’))
into
jiayao_energy_2025.jiayao_meter_stat_10m output_subtable(concat(‘jiayao_meter_stat_10m_’, cast(meter_code as binary))) as
select
_twstart as ts,
_twstart as window_start,
_twend as window_end,
count(*) as ts_count,
avg(power_total) as avg_power,
max(power_total) as max_power,
min(power_total) as min_power,
max (energy_total) as max_energy,
min (energy_total) as min_energy,
(max (energy_total) - min (energy_total)) as used_energy
from
%%tbname
where
_c0 >= _twstart
and _c0 <= _twend

云服务优先在云服务界面右上角提工单,会有专人支持。

此话题已在最后回复的 10 天后被自动关闭。不再允许新回复。