数据准备
create table whh.com_mony(
entid string comment '企业ID',
month string comment '月份',
val string comment '市值'
) comment '企业每月市值标' stored as orc;
insert into whh.com_mony values
('zhangsan','2020-01',12),
('zhangsan','2020-02',null),
('zhangsan','2020-03',23),
('zhangsan','2020-04',null),
('zhangsan','2020-05',null),
('zhangsan','2020-06',30),
('zhangsan','2020-07',48),
('zhangsan','2020-08',null),
('zhangsan','2020-09',null),
('zhangsan','2020-10',n