digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: 119 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 2,769<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1756.0: task 1537))"];
}
subgraph cluster5 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 187 ms";
6 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>2 ms (1 ms, 1 ms, 1 ms (stage 1756.0: task 1537))<br>peak memory total (min, med, max (stageId: taskId))<br>128.1 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 1756.0: task 1537))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1756.0: task 1537))"];
}
7 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>1102.3 KiB (462.0 KiB, 640.3 KiB, 640.3 KiB (driver))<br>number of coalesced partitions: 2"];
8 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 3,000<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>4 ms (2 ms, 2 ms, 2 ms (stage 1746.0: task 1531))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 3,000<br>local bytes read total (min, med, max (stageId: taskId))<br>1048.3 KiB (442.2 KiB, 606.2 KiB, 606.2 KiB (stage 1756.0: task 1537))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1756.0: task 1537))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 4<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>2.3 MiB (1162.6 KiB, 1162.6 KiB, 1162.6 KiB (stage 1746.0: task 1531))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>1048.3 KiB (523.3 KiB, 525.0 KiB, 525.0 KiB (stage 1746.0: task 1530))"];
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n42 ms (18 ms, 24 ms, 24 ms (stage 1746.0: task 1531))";
10 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
}
11 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster12 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 0 ms";
13 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
14 [labelType="html" label="<br><b>Project</b><br><br>"];
15 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore\".\"h_cr\") as x) [numPartitions=1] </b><br><br>number of output rows: 1,500"];
}
subgraph cluster16 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 0 ms";
17 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
18 [labelType="html" label="<br><b>Project</b><br><br>"];
19 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"cr_numcr\", \"cr_numdos\", \"cr_nomdic\", \"cr_numdem\", \"cr_numexa\", \"cr_typdoc\", \"cr_prior\", \"cr_nomdcr\", \"cr_taidcr\", \"cr_durdcr\", \"cr_posdcr\", \"cr_nomdos\", \"cr_for_cr\", \"cr_cr\", \"cr_statdic\", \"cr_statsm\", \"cr_statcr\", \"cr_coddic\", \"cr_context\", \"cr_datdic\", \"cr_heudic\", \"cr_heui_d\", \"cr_heui_f\", \"cr_codsec\", \"cr_datsec\", \"cr_heusec\", \"cr_codvcr\", \"cr_datvcr\", \"cr_heuvcr\", \"cr_coddcr\", \"cr_datdcr\", \"cr_heudcr\", \"cr_dat_eff_d\", \"cr_dat_eff_w\", \"cr_coduti\", \"cr_datmaj\", \"cr_codsit\", \"cr_sectra\", \"cr_typcr\", \"cr_codsup\", \"cr_nivvcr\", \"cr_numvcr\", \"cr_nb_cor\", \"cr_datsup\", \"cr_heusup\", \"cr_flarch\", \"cr_staext\", \"cr_flimpr\", \"cr_lockcr\", \"cr_codmcr\", \"cr_datmcr\", \"cr_heumcr\", \"cr_codacc\", \"cr_motpas\", \"cr_libco\", \"cr_subdic\", \"cr_subdir\", \"cr_numprt\", \"cr_sta_env_prt\", \"cr_sta_ret_pro\", \"cr_sta_env_fra\", \"cr_sta_ret_fra\", \"cr_codcli\", \"cr_pri_dic\", \"cr_dat_dic_tra\", \"cr_heu_dic_tra\", \"cr_codfra\", \"cr_secext\", \"cr_statut_ext\", \"cr_simp_job_id\", \"cr_dat_cr_int\", \"cr_heu_cr_int\", \"cr_delai_total\", \"cr_nb_ligne_ext\", \"cr_nb_car_ext\", \"cr_nomext\", \"cr_subext\", \"cr_fltbdi\", \"cr_typdic\", \"cr_sta_env_ack\", \"cr_sta_ret_ack\", \"cr_taille_dic\", \"cr_chksum_dic\", \"cr_datmail\", \"cr_heumail\", \"cr_codmail\", \"cr_stadmp\", \"cr_coddmp\", \"cr_datdmp\", \"cr_heudmp\", \"cr_oiddmp\", \"cr_visdmp\", \"cr_scnpat\", \"cr_datscn\", \"cr_nummcr\", \"cr_numcr_cloud\", \"cr_numdrv\", \"cr_flarch_d\", \"cr_refext\", \"cr_annonce\", \"cr_periph\", \"cr_datcre\", \"cr_heucre\", \"cr_origine\", \"cr_oid\", \"cr_flordo\", \"cr_idcda\", \"cr_fltr\" FROM \"xplore2\".\"h_cr\") as x) [numPartitions=1] </b><br><br>number of output rows: 1,500"];
}
subgraph cluster20 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 0 ms";
21 [labelType="html" label="<br><b>Project</b><br><br>"];
22 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 48,715<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1756.0: task 1537))"];
}
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 0 ms";
24 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>38 ms (15 ms, 23 ms, 23 ms (stage 1756.0: task 1537))<br>peak memory total (min, med, max (stageId: taskId))<br>129.5 MiB (64.5 MiB, 65.0 MiB, 65.0 MiB (stage 1756.0: task 1537))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1756.0: task 1537))"];
}
25 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>2.6 MiB (1086.9 KiB, 1603.9 KiB, 1603.9 KiB (driver))<br>number of coalesced partitions: 2"];
26 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 47,008<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>10 ms (4 ms, 5 ms, 5 ms (stage 1747.0: task 1532))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 47,008<br>local bytes read total (min, med, max (stageId: taskId))<br>2.5 MiB (1051.9 KiB, 1552.4 KiB, 1552.4 KiB (stage 1756.0: task 1537))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1756.0: task 1537))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 4<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>4.5 MiB (2.3 MiB, 2.3 MiB, 2.3 MiB (stage 1747.0: task 1532))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>2.5 MiB (1301.3 KiB, 1303.0 KiB, 1303.0 KiB (stage 1747.0: task 1533))"];
27 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster28 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 285 ms";
29 [labelType="html" label="<br><b>Project</b><br><br>"];
30 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster31 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 285 ms";
32 [labelType="html" label="<br><b>Project</b><br><br>"];
33 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster34 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 0 ms";
35 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>33 ms (14 ms, 19 ms, 19 ms (stage 1756.0: task 1537))<br>peak memory total (min, med, max (stageId: taskId))<br>129.5 MiB (64.5 MiB, 65.0 MiB, 65.0 MiB (stage 1756.0: task 1537))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1756.0: task 1537))"];
}
36 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>376.1 KiB (154.0 KiB, 222.1 KiB, 222.1 KiB (driver))<br>number of coalesced partitions: 2"];
37 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 47,008<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>3 ms (1 ms, 2 ms, 2 ms (stage 1748.0: task 1534))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 47,008<br>local bytes read total (min, med, max (stageId: taskId))<br>359.0 KiB (145.0 KiB, 214.0 KiB, 214.0 KiB (stage 1756.0: task 1537))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1756.0: task 1537))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 4<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>1403.6 KiB (701.8 KiB, 701.8 KiB, 701.8 KiB (stage 1748.0: task 1534))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>359.0 KiB (179.4 KiB, 179.6 KiB, 179.6 KiB (stage 1748.0: task 1534))"];
38 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster39 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 20 ms";
40 [labelType="html" label="<br><b>Project</b><br><br>"];
41 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster42 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 19 ms";
43 [labelType="html" label="<br><b>Project</b><br><br>"];
44 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
1->0;
3->1;
4->3;
6->4;
7->6;
8->7;
10->8;
11->10;
13->11;
14->13;
15->14;
17->11;
18->17;
19->18;
21->4;
22->21;
24->22;
25->24;
26->25;
27->26;
29->27;
30->29;
32->27;
33->32;
35->22;
36->35;
37->36;
38->37;
40->38;
41->40;
43->38;
44->43;
}
45
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Project [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639)) AS COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
SortMergeJoin [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595], [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633], LeftOuter
WholeStageCodegen (12)
Sort [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, 10), ENSURE_REQUIREMENTS, [plan_id=30608]
LocalLimit 1500
WholeStageCodegen (3)
Union
LocalLimit 1500
Project [cr_numcr#550535 AS COL_29272194_C362_4B1A_871B_827530BCD34B#553594, cr_numdos#550536 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, cr_nomdic#550537 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, cr_numdem#550538 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, cr_numexa#550539 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, cr_typdoc#550540 AS COL_B9580440_50FB_4495_B82E_8046068EB218#553599, cr_prior#550541 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, cr_nomdcr#550542 AS COL_087DC335_6719_4B78_B354_10A3D546B347#553601, cr_taidcr#550543 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, cr_nomdos#550546 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, cr_for_cr#550547 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, cr_cr#550548 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] [cr_numcr#550535,cr_numdos#550536,cr_nomdic#550537,cr_numdem#550538,cr_numexa#550539,cr_typdoc#550540,cr_prior#550541,cr_nomdcr#550542,cr_taidcr#550543,cr_nomdos#550546,cr_for_cr#550547,cr_cr#550548] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...
WholeStageCodegen (1)
LocalLimit 1500
Project [cr_numcr#551510 AS COL_29272194_C362_4B1A_871B_827530BCD34B#554172, cr_numdos#551511 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#554173, cr_nomdic#551512 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#554174, cr_numdem#551513 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#554175, cr_numexa#551514 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#554176, cr_typdoc#551515 AS COL_B9580440_50FB_4495_B82E_8046068EB218#554177, cr_prior#551516 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#554178, cr_nomdcr#551517 AS COL_087DC335_6719_4B78_B354_10A3D546B347#554179, cr_taidcr#551518 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#554180, cr_nomdos#551521 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#554181, cr_for_cr#551522 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#554182, cr_cr#551523 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#554183]
Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] [cr_numcr#551510,cr_numdos#551511,cr_nomdic#551512,cr_numdem#551513,cr_numexa#551514,cr_typdoc#551515,cr_prior#551516,cr_nomdcr#551517,cr_taidcr#551518,cr_nomdos#551521,cr_for_cr#551522,cr_cr#551523] PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))], ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typ...
WholeStageCodegen (2)
Project [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639]
SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#550025], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145], LeftOuter
WholeStageCodegen (11)
Sort [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 ASC NULLS FIRST], false, 0
WholeStageCodegen (9)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#550025, 10), ENSURE_REQUIREMENTS, [plan_id=30631]
Union
Project [at_numdos#544937 AS COL_499EB20D_E124_400E_A51E_F020884D243F#550025, at_nompat#544940 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, str_replace_extend(str_replace_extend(at_nompat#544940, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, at_pnopat#544941 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, str_replace_extend(str_replace_extend(at_pnopat#544941, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#544937,at_nompat#544940,at_pnopat#544941] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>
WholeStageCodegen (4)
Project [at_numdos#546164 AS COL_499EB20D_E124_400E_A51E_F020884D243F#554184, at_nompat#546167 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#554185, str_replace_extend(str_replace_extend(at_nompat#546167, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#554188, at_pnopat#546168 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#554186, str_replace_extend(str_replace_extend(at_pnopat#546168, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#554189]
Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#546164,at_nompat#546167,at_pnopat#546168] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>
WholeStageCodegen (5)
Sort [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145 ASC NULLS FIRST], false, 0
WholeStageCodegen (10)
AQEShuffleRead coalesced
Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145, 10), ENSURE_REQUIREMENTS, [plan_id=30651]
Union
Project [at_numdos#550167 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [at_numdos#550167] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (6)
Project [at_numdos#550303 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#554187]
Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [at_numdos#550303] PushedFilters: [*IsNotNull(at_numdos)], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (7)
== Physical Plan ==
AdaptiveSparkPlan (51)
+- == Final Plan ==
CollectLimit (35)
+- * Project (34)
+- * SortMergeJoin LeftOuter (33)
:- * Sort (12)
: +- AQEShuffleRead (11)
: +- ShuffleQueryStage (10), Statistics(sizeInBytes=2.3 MiB, rowCount=3.00E+3)
: +- Exchange (9)
: +- * LocalLimit (8)
: +- Union (7)
: :- * LocalLimit (3)
: : +- * Project (2)
: : +- * Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] (1)
: +- * LocalLimit (6)
: +- * Project (5)
: +- * Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] (4)
+- * Project (32)
+- * SortMergeJoin LeftOuter (31)
:- * Sort (21)
: +- AQEShuffleRead (20)
: +- ShuffleQueryStage (19), Statistics(sizeInBytes=4.5 MiB, rowCount=4.70E+4)
: +- Exchange (18)
: +- Union (17)
: :- * Project (14)
: : +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] (13)
: +- * Project (16)
: +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] (15)
+- * Sort (30)
+- AQEShuffleRead (29)
+- ShuffleQueryStage (28), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
+- Exchange (27)
+- Union (26)
:- * Project (23)
: +- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] (22)
+- * Project (25)
+- * Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] (24)
+- == Initial Plan ==
CollectLimit (50)
+- Project (49)
+- SortMergeJoin LeftOuter (48)
:- Sort (39)
: +- Exchange (38)
: +- LocalLimit (37)
: +- Union (36)
: :- LocalLimit (3)
: : +- Project (2)
: : +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] (1)
: +- LocalLimit (6)
: +- Project (5)
: +- Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] (4)
+- Project (47)
+- SortMergeJoin LeftOuter (46)
:- Sort (42)
: +- Exchange (41)
: +- Union (40)
: :- Project (14)
: : +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] (13)
: +- Project (16)
: +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] (15)
+- Sort (45)
+- Exchange (44)
+- Union (43)
:- Project (23)
: +- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] (22)
+- Project (25)
+- Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] (24)
(1) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore"."h_cr") as x) [numPartitions=1] [codegen id : 1]
Output [12]: [cr_numcr#550535, cr_numdos#550536, cr_nomdic#550537, cr_numdem#550538, cr_numexa#550539, cr_typdoc#550540, cr_prior#550541, cr_nomdcr#550542, cr_taidcr#550543, cr_nomdos#550546, cr_for_cr#550547, cr_cr#550548]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string>
(2) Project [codegen id : 1]
Output [12]: [cr_numcr#550535 AS COL_29272194_C362_4B1A_871B_827530BCD34B#553594, cr_numdos#550536 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, cr_nomdic#550537 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, cr_numdem#550538 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, cr_numexa#550539 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, cr_typdoc#550540 AS COL_B9580440_50FB_4495_B82E_8046068EB218#553599, cr_prior#550541 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, cr_nomdcr#550542 AS COL_087DC335_6719_4B78_B354_10A3D546B347#553601, cr_taidcr#550543 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, cr_nomdos#550546 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, cr_for_cr#550547 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, cr_cr#550548 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Input [12]: [cr_numcr#550535, cr_numdos#550536, cr_nomdic#550537, cr_numdem#550538, cr_numexa#550539, cr_typdoc#550540, cr_prior#550541, cr_nomdcr#550542, cr_taidcr#550543, cr_nomdos#550546, cr_for_cr#550547, cr_cr#550548]
(3) LocalLimit [codegen id : 1]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: 1500
(4) Scan JDBCRelation((SELECT "cr_numcr", "cr_numdos", "cr_nomdic", "cr_numdem", "cr_numexa", "cr_typdoc", "cr_prior", "cr_nomdcr", "cr_taidcr", "cr_durdcr", "cr_posdcr", "cr_nomdos", "cr_for_cr", "cr_cr", "cr_statdic", "cr_statsm", "cr_statcr", "cr_coddic", "cr_context", "cr_datdic", "cr_heudic", "cr_heui_d", "cr_heui_f", "cr_codsec", "cr_datsec", "cr_heusec", "cr_codvcr", "cr_datvcr", "cr_heuvcr", "cr_coddcr", "cr_datdcr", "cr_heudcr", "cr_dat_eff_d", "cr_dat_eff_w", "cr_coduti", "cr_datmaj", "cr_codsit", "cr_sectra", "cr_typcr", "cr_codsup", "cr_nivvcr", "cr_numvcr", "cr_nb_cor", "cr_datsup", "cr_heusup", "cr_flarch", "cr_staext", "cr_flimpr", "cr_lockcr", "cr_codmcr", "cr_datmcr", "cr_heumcr", "cr_codacc", "cr_motpas", "cr_libco", "cr_subdic", "cr_subdir", "cr_numprt", "cr_sta_env_prt", "cr_sta_ret_pro", "cr_sta_env_fra", "cr_sta_ret_fra", "cr_codcli", "cr_pri_dic", "cr_dat_dic_tra", "cr_heu_dic_tra", "cr_codfra", "cr_secext", "cr_statut_ext", "cr_simp_job_id", "cr_dat_cr_int", "cr_heu_cr_int", "cr_delai_total", "cr_nb_ligne_ext", "cr_nb_car_ext", "cr_nomext", "cr_subext", "cr_fltbdi", "cr_typdic", "cr_sta_env_ack", "cr_sta_ret_ack", "cr_taille_dic", "cr_chksum_dic", "cr_datmail", "cr_heumail", "cr_codmail", "cr_stadmp", "cr_coddmp", "cr_datdmp", "cr_heudmp", "cr_oiddmp", "cr_visdmp", "cr_scnpat", "cr_datscn", "cr_nummcr", "cr_numcr_cloud", "cr_numdrv", "cr_flarch_d", "cr_refext", "cr_annonce", "cr_periph", "cr_datcre", "cr_heucre", "cr_origine", "cr_oid", "cr_flordo", "cr_idcda", "cr_fltr" FROM "xplore2"."h_cr") as x) [numPartitions=1] [codegen id : 2]
Output [12]: [cr_numcr#551510, cr_numdos#551511, cr_nomdic#551512, cr_numdem#551513, cr_numexa#551514, cr_typdoc#551515, cr_prior#551516, cr_nomdcr#551517, cr_taidcr#551518, cr_nomdos#551521, cr_for_cr#551522, cr_cr#551523]
PushedFilters: [*Not(EqualNullSafe(cr_cr,[NULL]))]
ReadSchema: struct<cr_numcr:string,cr_numdos:string,cr_nomdic:string,cr_numdem:string,cr_numexa:string,cr_typdoc:string,cr_prior:string,cr_nomdcr:string,cr_taidcr:string,cr_nomdos:string,cr_for_cr:string,cr_cr:string>
(5) Project [codegen id : 2]
Output [12]: [cr_numcr#551510 AS COL_29272194_C362_4B1A_871B_827530BCD34B#554172, cr_numdos#551511 AS COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#554173, cr_nomdic#551512 AS COL_426404CB_5141_4F89_A6D8_45BDAAD29767#554174, cr_numdem#551513 AS COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#554175, cr_numexa#551514 AS COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#554176, cr_typdoc#551515 AS COL_B9580440_50FB_4495_B82E_8046068EB218#554177, cr_prior#551516 AS COL_4906EFC1_6283_4227_936D_FFA86F51D118#554178, cr_nomdcr#551517 AS COL_087DC335_6719_4B78_B354_10A3D546B347#554179, cr_taidcr#551518 AS COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#554180, cr_nomdos#551521 AS COL_FA993954_05FA_428A_9A75_26EE63771B33#554181, cr_for_cr#551522 AS COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#554182, cr_cr#551523 AS COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#554183]
Input [12]: [cr_numcr#551510, cr_numdos#551511, cr_nomdic#551512, cr_numdem#551513, cr_numexa#551514, cr_typdoc#551515, cr_prior#551516, cr_nomdcr#551517, cr_taidcr#551518, cr_nomdos#551521, cr_for_cr#551522, cr_cr#551523]
(6) LocalLimit [codegen id : 2]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#554172, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#554173, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#554174, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#554175, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#554176, COL_B9580440_50FB_4495_B82E_8046068EB218#554177, COL_4906EFC1_6283_4227_936D_FFA86F51D118#554178, COL_087DC335_6719_4B78_B354_10A3D546B347#554179, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#554180, COL_FA993954_05FA_428A_9A75_26EE63771B33#554181, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#554182, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#554183]
Arguments: 1500
(7) Union
(8) LocalLimit [codegen id : 3]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: 1500
(9) Exchange
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, 10), ENSURE_REQUIREMENTS, [plan_id=30608]
(10) ShuffleQueryStage
Output [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: 0
(11) AQEShuffleRead
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: coalesced
(12) Sort [codegen id : 8]
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595 ASC NULLS FIRST], false, 0
(13) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [codegen id : 4]
Output [3]: [at_numdos#544937, at_nompat#544940, at_pnopat#544941]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>
(14) Project [codegen id : 4]
Output [5]: [at_numdos#544937 AS COL_499EB20D_E124_400E_A51E_F020884D243F#550025, at_nompat#544940 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, str_replace_extend(str_replace_extend(at_nompat#544940, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, at_pnopat#544941 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, str_replace_extend(str_replace_extend(at_pnopat#544941, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Input [3]: [at_numdos#544937, at_nompat#544940, at_pnopat#544941]
(15) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [codegen id : 5]
Output [3]: [at_numdos#546164, at_nompat#546167, at_pnopat#546168]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string,at_nompat:string,at_pnopat:string>
(16) Project [codegen id : 5]
Output [5]: [at_numdos#546164 AS COL_499EB20D_E124_400E_A51E_F020884D243F#554184, at_nompat#546167 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#554185, str_replace_extend(str_replace_extend(at_nompat#546167, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_D741682E_18A7_4E09_96D0_47ED855868ED#554188, at_pnopat#546168 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#554186, str_replace_extend(str_replace_extend(at_pnopat#546168, [A,E,I,O,U,Y], [P,S,B,G,H,J]), [D,L,M,S,C,V,R,G], [U,E,U,K,J,O,Y,Z]) AS COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#554189]
Input [3]: [at_numdos#546164, at_nompat#546167, at_pnopat#546168]
(17) Union
(18) Exchange
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#550025, 10), ENSURE_REQUIREMENTS, [plan_id=30631]
(19) ShuffleQueryStage
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: 1
(20) AQEShuffleRead
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: coalesced
(21) Sort [codegen id : 9]
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 ASC NULLS FIRST], false, 0
(22) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore"."h_patien") as x) [numPartitions=1] [codegen id : 6]
Output [1]: [at_numdos#550167]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>
(23) Project [codegen id : 6]
Output [1]: [at_numdos#550167 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Input [1]: [at_numdos#550167]
(24) Scan JDBCRelation((SELECT "at_numdos", "at_stapat", "at_prefix", "at_nompat", "at_pnopat", "at_njfpat", "at_datnai", "at_datnaiss", "at_sexe", "at_numper", "at_sigma", "at_verrou", "at_poids", "at_indcen", "at_numss", "at_antece", "at_adr_1", "at_adr_2", "at_codpos", "at_ville", "at_pays", "at_numcai", "at_nummut", "at_numcha", "at_telpri", "at_telbur", "at_telpor", "at_fax", "at_prefi2", "at_nomass", "at_pnoass", "at_njfass", "at_datass", "at_adr_1a", "at_adr_2a", "at_codpoa", "at_villea", "at_codmed", "at_datcss", "at_datf_d", "at_dat100", "at_numsir", "at_numssa", "at_codser", "at_rngnai", "at_natass", "at_numacc", "at_datacc", "at_typexo", "at_datmaj", "at_coduti", "at_flcmu", "at_qualss", "at_codref", "at_codregat", "at_codcaiat", "at_indvital", "at_conmut", "at_adhmut", "at_garmut", "at_numper_ori", "at_codrout", "at_domaine", "at_indtrai", "at_idhote", "at_codsts", "at_nirind", "at_fldcd", "at_flphoto", "at_codmtr", "at_adr_3", "at_pays_iso", "at_adr_3a", "at_poids_maj", "at_codgestion", "at_art115", "at_taille", "at_taille_maj", "at_codetab_prod", "at_codsit_prod", "at_numdos_prod", "at_numper_prod", "at_numper_ori_prod", "at_ins", "at_ins_type", "at_ins_date", "at_ins_source", "at_stadmp", "at_datdmp", "at_alarmes", "at_email", "at_consent_sms", "at_dat_consent_sms", "at_datdcd", "at_flhlim", "at_dathlim", "at_codpershlim", "at_fldiff", "at_lisdest", "at_langue", "at_numcai_ft", "at_codtarifamc", "at_flgrve", "at_fladri", "at_datadri", "at_datf_mut", "at_comfac", "at_numdos_cloud", "at_nation", "at_titre", "at_titre_ass", "at_tiq_histoxml", "at_tiq_pnoliste", "at_codposnai", "at_insi", "at_insi_oid", "at_typconv", "at_crisec", "at_opereg", "at_flannuamc", "at_staipp", "at_pnonai", "at_codinseenai", "at_villenai", "at_piece_ident_pres", "at_dat_staipp", "at_datapcv", "at_num_apcv", "at_heuapcv", "at_numper_sec", "at_ins_heure", "at_persaprev", "at_tarif", "at_nomhl7", "at_numper_ori_oid", "at_comment" FROM "xplore2"."h_patien") as x) [numPartitions=1] [codegen id : 7]
Output [1]: [at_numdos#550303]
PushedFilters: [*IsNotNull(at_numdos)]
ReadSchema: struct<at_numdos:string>
(25) Project [codegen id : 7]
Output [1]: [at_numdos#550303 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#554187]
Input [1]: [at_numdos#550303]
(26) Union
(27) Exchange
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145, 10), ENSURE_REQUIREMENTS, [plan_id=30651]
(28) ShuffleQueryStage
Output [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: 2
(29) AQEShuffleRead
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: coalesced
(30) Sort [codegen id : 10]
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145 ASC NULLS FIRST], false, 0
(31) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Join type: LeftOuter
Join condition: None
(32) Project [codegen id : 11]
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639]
Input [6]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
(33) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633]
Join type: LeftOuter
Join condition: None
(34) Project [codegen id : 12]
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639)) AS COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639]
(35) CollectLimit
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
Arguments: 1500
(36) Union
(37) LocalLimit
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: 1500
(38) Exchange
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: hashpartitioning(COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, 10), ENSURE_REQUIREMENTS, [plan_id=30585]
(39) Sort
Input [12]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605]
Arguments: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595 ASC NULLS FIRST], false, 0
(40) Union
(41) Exchange
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#550025, 10), ENSURE_REQUIREMENTS, [plan_id=30577]
(42) Sort
Input [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 ASC NULLS FIRST], false, 0
(43) Union
(44) Exchange
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145, 10), ENSURE_REQUIREMENTS, [plan_id=30578]
(45) Sort
Input [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145 ASC NULLS FIRST], false, 0
(46) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
Join type: LeftOuter
Join condition: None
(47) Project
Output [5]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025 AS H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028 AS H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110 AS H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029 AS H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112 AS H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639]
Input [6]: [COL_499EB20D_E124_400E_A51E_F020884D243F#550025, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#550028, COL_D741682E_18A7_4E09_96D0_47ED855868ED#550110, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#550029, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#550112, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#550145]
(48) SortMergeJoin
Left keys [1]: [COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595]
Right keys [1]: [H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633]
Join type: LeftOuter
Join condition: None
(49) Project
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636 AS COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637 AS COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638 AS COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639 AS COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, str_replace_extend(COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, array(H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638), array(H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639)) AS COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, H_PATIEN_438514_COL_499EB20D_E124_400E_A51E_F020884D243F#553633, H_PATIEN_438514_COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#553636, H_PATIEN_438514_COL_D741682E_18A7_4E09_96D0_47ED855868ED#553637, H_PATIEN_438514_COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#553638, H_PATIEN_438514_COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#553639]
(50) CollectLimit
Input [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
Arguments: 1500
(51) AdaptiveSparkPlan
Output [17]: [COL_29272194_C362_4B1A_871B_827530BCD34B#553594, COL_91CF17C4_5CDC_4008_8AD7_F1285B607EDB#553595, COL_426404CB_5141_4F89_A6D8_45BDAAD29767#553596, COL_D8FF4CB2_B7F6_4CE2_AEC7_ABE589BDBED1#553597, COL_E60F0325_9D51_4908_9ED8_6F9DD6D3CC07#553598, COL_B9580440_50FB_4495_B82E_8046068EB218#553599, COL_4906EFC1_6283_4227_936D_FFA86F51D118#553600, COL_087DC335_6719_4B78_B354_10A3D546B347#553601, COL_BC8C700A_A442_4CE4_B18E_8E926223C43D#553602, COL_FA993954_05FA_428A_9A75_26EE63771B33#553603, COL_E6A34AED_4DA5_46FF_9366_A11147AB9841#553604, COL_7CF26F14_9183_4CD5_A49C_F43999A51D88#553605, COL_11A13087_17FF_425D_98AA_BB90471CEB71#553767, COL_237D5897_AB7D_4A38_A638_7CB5E3C21711#553768, COL_79D841FD_CF84_4B15_AF81_4EA228006C1A#553769, COL_B0A974FF_C195_4FB8_BF35_301119518B73#553770, COL_0E5B5E23_1957_4250_99D8_1503849C4E1C#553771]
Arguments: isFinalPlan=true