insert into table vin_geo_summary
select vin,province,city from
(select vin,province,cityname as city,sub.c,rank() over (partition by vin order by sub.c desc) as r
from
(select vin,province,cityname,count(*) as c from vin_geo group by vin,cityname,province) as sub) as mid
where mid.r=1
;
top N hive sql
最新推荐文章于 2022-03-26 14:23:02 发布