获取年初到每天的累计值

INSERT INTO mscm_gg_prd.STF_ZN_PRD_LJJQ (
  value,
  ymd
)
SELECT 
  (SELECT sum(t2.measure_value) FROM value_everyday as t2 where t2.ymd <= t1.ymd and left(t2.ymd, 4) = left(t1.ymd, 4) ),
  ymd
FROM (
  SELECT DISTINCT ymd FROM value_everyday 
) as t1

月累计值

SELECT 
sum(measure_value) over(PARTITION BY year order by ym), 
ym 
FROM t