ส่งข้อมูลเข้า datacenter ไม่ได้ครับ ค้างครับ
18:28:10.703 Waiting data ... select count(*) as cc from death
18:28:10.703 Waiting data ... select count(*) as cc from death
18:28:11.125 Waiting data ... select count(*) as cc from death
18:28:11.125 Waiting data ... select count(*) as cc from death
.................................................................................................
drop table if exists tmp_dw_guid_clinicmember
create table tmp_dw_guid_clinicmember (hos_guid varchar(38) not null,md1 char(1),md2 char(2),md3 char(3),md4 char(4))
insert ignore into tmp_dw_guid_clinicmember (hos_guid) select hos_guid from clinicmember
update tmp_dw_guid_clinicmember set md1 = substring(md5(hos_guid),1,1),md2 = substring(md5(hos_guid),1,2), md3 = substring(md5(hos_guid),1,3),md4 = substring(md5(hos_guid),1,4)
alter table tmp_dw_guid_clinicmember add index ix_md1 (md1)
alter table tmp_dw_guid_clinicmember add index ix_md2 (md2)
alter table tmp_dw_guid_clinicmember add index ix_md3 (md3)
alter table tmp_dw_guid_clinicmember add index ix_md4 (md4)
select md1,count(md1) as cc from tmp_dw_guid_clinicmember group by md1
drop table if exists tmp_dw_guid_clinicmember
describe death
select count(*) as cc from death where hos_guid is null or hos_guid = ''
select count(*) as cc from death