fly_skydfdf的博客

--非分区表USE ODS;DROP TABLE IF EXISTS s01_t_sys_file;CREATE TABLE s01_t_sys_file ( id STRING COMMENT '自增长列id', biz_name STRING COMMENT '业务名称', biz_id ...

1、sum()over(partition by ...)   (累加求和)     select cookieid,create_time,pv,                sum(pv) over(partition by cookieid order by createtime) as pv1,                   -- 默认为从起点到当前行           ...