doris版本：2.0.4
doris select查出来是有数据，insert into 汇入到dwd后，需要等几分钟数据才会更新进去，
有时候，作业在线上跑数据的时候，明明ods有数据，但是就没汇聚出来到dwd去，
dwd表结构
CREATE TABLE dwd_lcyl_outp_medical_record_merge (
clinic_reg_no varchar(60) NOT NULL COMMENT '患者门诊流水号',
visit_no varchar(60) NOT NULL COMMENT '看诊流水号',
hos_code varchar(30) NOT NULL COMMENT '院区编码',
id varchar(150) NOT NULL COMMENT 'id',
patient_name varchar(150) NOT NULL COMMENT '患者姓名',
clinic_id varchar(30) NOT NULL COMMENT '患者就诊号',
empi_no varchar(150) NULL COMMENT '患者主索引号',
gender_code varchar(6) NULL COMMENT '性别编码',
gender varchar(6) NULL COMMENT '性别',
id_no varchar(60) NULL COMMENT '身份证号',
age varchar(15) NULL COMMENT '年龄',
birthday date NULL COMMENT '出生年月',
tel varchar(60) NULL COMMENT '联系电话',
address varchar(300) NULL COMMENT '地址',
visit_dept_code varchar(30) NULL COMMENT '看诊科室代码',
visit_dept_name varchar(150) NULL COMMENT '看诊科室名称',
visit_doc_code varchar(30) NULL COMMENT '看诊医生代码',
visit_doc_name varchar(150) NULL COMMENT '看诊医生名称',
chief_complaint varchar(48000) NULL COMMENT '主诉',
current_illness text NULL COMMENT '现病史',
anamnesis varchar(6000) NULL COMMENT '既往史',
allergy varchar(6000) NULL COMMENT '过敏史'
INDEX tenant_code (tenant_code) USING BITMAP COMMENT '',
INDEX visit_no (visit_no) USING BITMAP COMMENT '',
INDEX hos_code_suoyin (hos_code) USING INVERTED COMMENT '',
INDEX tenant_code_suoyin (tenant_code) USING INVERTED COMMENT '',
INDEX GENDER_CODE_suoyin (gender_code) USING INVERTED COMMENT '',
INDEX empi_no (empi_no) USING INVERTED COMMENT ''
) ENGINE=OLAP
UNIQUE KEY(clinic_reg_no, visit_no, hos_code)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(clinic_reg_no, visit_no, hos_code) BUCKETS 20
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"store_row_column" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);
