上周有新需求把face++识别的身份证信息存到会员中。存量数据还有1300万数据,也就是要刷1300万的数据。
想过跑批查询封装多线程调用dubbo接口,怕dubbo服务提供者扛不住。
考虑走脚本刷,一条脚本如下:
update mem.mem_base_info i
set i.nation = decode(i.nation,
null,
(select nation
from risk.loan_identity_personinfo p
where i.cust_id = p.mid),
i.nation),
i.police_station = decode(i.police_station,
null,
(select id_org
from risk.loan_identity_personinfo p
where i.cust_id = p.mid),
i.police_station),
i.id_validity_date = decode(i.id_validity_date,
null,
(select case length(p.id_effect_date)
when 21 then