--sum_userselect record_date, sum(power_consumption) as power_consumptionfrom ${t1} Group by record_date ;--day_month_yearselect concat(split_part(record_date,'/',1),'-',if(length(split_part(record_date,'/',2)) ==1,concat('0',split_part(record_date,'/',2)),split_part(record_date,'/',2)),'-',if(length(split_part(record_date,'/',3)) ==1,concat('0',split_part(record_date,'/',3)),split_part(record_date,'/',3))) as record_date, power_consumption, cast(split_part(record_date,'/',1) as bigint ) as year, cast (split_part(record_date,'/',2) as bigint) as month, cast(split_part(record_date,'/',3)as bigint ) as dayfrom ${t1} where record_date >= '2015/1/1';--month_featureselect distinct month_str,mean,d_max,d_min,d_median from (select substr(record_date,1,7)as month_str,--骞存湀 avg(power_consumption) over ( partition by year,month ) as mean,--骞冲潎鐢ㄧ數閲� max(power_consumption) over ( partition by year,month ) as d_max,--褰撴湀鏈�楂樼敤鐢甸噺 min(power_consumption) over ( partition by year,m
