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 (9)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (589 ms, 670 ms, 670 ms (stage 1556.0: task 1392))";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 7"];
5 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 57,890<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1560.0: task 1393))"];
}
subgraph cluster6 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (591 ms, 698 ms, 698 ms (stage 1556.0: task 1392))";
7 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>27 ms (13 ms, 14 ms, 14 ms (stage 1556.0: task 1392))<br>peak memory total (min, med, max (stageId: taskId))<br>130.0 MiB (65.0 MiB, 65.0 MiB, 65.0 MiB (stage 1560.0: task 1393))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1560.0: task 1393))"];
}
8 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>4.2 MiB (2.1 MiB, 2.1 MiB, 2.1 MiB (driver))<br>number of coalesced partitions: 2"];
9 [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>14 ms (6 ms, 7 ms, 7 ms (stage 1549.0: task 1387))<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>3.9 MiB (1990.8 KiB, 2010.5 KiB, 2010.5 KiB (stage 1556.0: task 1392))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1560.0: task 1393))<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>11.0 MiB (5.5 MiB, 5.5 MiB, 5.5 MiB (stage 1549.0: task 1388))<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>3.9 MiB (1999.2 KiB, 2002.1 KiB, 2002.1 KiB (stage 1549.0: task 1388))"];
10 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 296 ms";
12 [labelType="html" label="<br><b>Project</b><br><br>"];
13 [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 cluster14 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 293 ms";
15 [labelType="html" label="<br><b>Project</b><br><br>"];
16 [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 cluster17 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (590 ms, 696 ms, 696 ms (stage 1556.0: task 1392))";
18 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>23 ms (11 ms, 12 ms, 12 ms (stage 1556.0: task 1392))<br>peak memory total (min, med, max (stageId: taskId))<br>130.0 MiB (65.0 MiB, 65.0 MiB, 65.0 MiB (stage 1560.0: task 1393))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1560.0: task 1393))"];
}
19 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 2<br>partition data size total (min, med, max (stageId: taskId))<br>680.2 KiB (340.1 KiB, 340.1 KiB, 340.1 KiB (driver))<br>number of coalesced partitions: 2"];
20 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 47,008<br>local merged chunks fetched: 0<br>shuffle write time: 3 ms<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>654.8 KiB (325.4 KiB, 329.5 KiB, 329.5 KiB (stage 1556.0: task 1392))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1560.0: task 1393))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 2.4 MiB<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: 654.8 KiB"];
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 175 ms";
22 [labelType="html" label="<br><b>Project</b><br><br>"];
23 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 47,008"];
}
24 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster25 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 30 ms";
26 [labelType="html" label="<b>Sort</b><br><br>sort time: 2 ms<br>peak memory: 66.0 MiB<br>spill size: 0.0 B"];
}
27 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 352.9 KiB<br>number of coalesced partitions: 1"];
28 [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>2 ms (1 ms, 1 ms, 1 ms (stage 1550.0: task 1389))<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: 326.6 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<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 1550.0: task 1389))<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>326.6 KiB (163.3 KiB, 163.3 KiB, 163.3 KiB (stage 1550.0: task 1390))"];
29 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster30 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 12 ms";
31 [labelType="html" label="<br><b>Project</b><br><br>"];
32 [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 cluster33 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 12 ms";
34 [labelType="html" label="<br><b>Project</b><br><br>"];
35 [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;
5->4;
7->5;
8->7;
9->8;
10->9;
12->10;
13->12;
15->10;
16->15;
18->5;
19->18;
20->19;
22->20;
23->22;
24->23;
26->24;
27->26;
28->27;
29->28;
31->29;
32->31;
34->29;
35->34;
}
36
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Project [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Filter ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010) END)
SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#400279], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399], LeftOuter
WholeStageCodegen (9)
Sort [COL_499EB20D_E124_400E_A51E_F020884D243F#400279 ASC NULLS FIRST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#400279, 10), ENSURE_REQUIREMENTS, [plan_id=25409]
Union
Project [at_numdos#395191 AS COL_499EB20D_E124_400E_A51E_F020884D243F#400279, at_stapat#395192 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, at_prefix#395193 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, at_nompat#395194 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, str_replace_extend(str_replace_extend(at_nompat#395194, [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#400364, at_pnopat#395195 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, str_replace_extend(str_replace_extend(at_pnopat#395195, [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#400366, at_njfpat#395196 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, at_datnai#395197 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, at_datnaiss#395198 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, at_sexe#395199 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, at_codpos#395209 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, at_ville#395210 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
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#395191,at_stapat#395192,at_prefix#395193,at_nompat#395194,at_pnopat#395195,at_njfpat#395196,at_datnai#395197,at_datnaiss#395198,at_sexe#395199,at_codpos#395209,at_ville#395210] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (1)
Project [at_numdos#396418 AS COL_499EB20D_E124_400E_A51E_F020884D243F#401063, at_stapat#396419 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#401064, at_prefix#396420 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#401065, at_nompat#396421 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#401066, str_replace_extend(str_replace_extend(at_nompat#396421, [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#401077, at_pnopat#396422 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#401067, str_replace_extend(str_replace_extend(at_pnopat#396422, [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#401078, at_njfpat#396423 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#401068, at_datnai#396424 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#401069, at_datnaiss#396425 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#401070, at_sexe#396426 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#401071, at_codpos#396436 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#401072, at_ville#396437 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#401073, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#401074]
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#396418,at_stapat#396419,at_prefix#396420,at_nompat#396421,at_pnopat#396422,at_njfpat#396423,at_datnai#396424,at_datnaiss#396425,at_sexe#396426,at_codpos#396436,at_ville#396437] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (2)
Sort [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, 10), ENSURE_REQUIREMENTS, [plan_id=25548]
Project [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Filter isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063], [1], [1 DESC NULLS LAST]
Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (5)
AQEShuffleRead coalesced
Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=25437]
Union
Project [at_numdos#400421 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
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#400421] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (3)
Project [at_numdos#400557 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#401075]
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#400557] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (4)
== Physical Plan ==
AdaptiveSparkPlan (45)
+- == Final Plan ==
CollectLimit (29)
+- * Project (28)
+- * Filter (27)
+- * SortMergeJoin LeftOuter (26)
:- * Sort (9)
: +- AQEShuffleRead (8)
: +- ShuffleQueryStage (7), Statistics(sizeInBytes=11.0 MiB, rowCount=4.70E+4)
: +- Exchange (6)
: +- Union (5)
: :- * Project (2)
: : +- * 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] (1)
: +- * Project (4)
: +- * 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] (3)
+- * Sort (25)
+- AQEShuffleRead (24)
+- ShuffleQueryStage (23), Statistics(sizeInBytes=2.4 MiB, rowCount=4.70E+4)
+- Exchange (22)
+- * Project (21)
+- * Filter (20)
+- Window (19)
+- * Sort (18)
+- AQEShuffleRead (17)
+- ShuffleQueryStage (16), Statistics(sizeInBytes=1403.6 KiB, rowCount=4.70E+4)
+- Exchange (15)
+- Union (14)
:- * Project (11)
: +- * 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] (10)
+- * Project (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 "xplore2"."h_patien") as x) [numPartitions=1] (12)
+- == Initial Plan ==
CollectLimit (44)
+- Project (43)
+- Filter (42)
+- SortMergeJoin LeftOuter (41)
:- Sort (32)
: +- Exchange (31)
: +- Union (30)
: :- Project (2)
: : +- 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] (1)
: +- Project (4)
: +- 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] (3)
+- Sort (40)
+- Exchange (39)
+- Project (38)
+- Filter (37)
+- Window (36)
+- Sort (35)
+- Exchange (34)
+- Union (33)
:- Project (11)
: +- 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] (10)
+- Project (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 "xplore2"."h_patien") as x) [numPartitions=1] (12)
(1) 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 : 1]
Output [11]: [at_numdos#395191, at_stapat#395192, at_prefix#395193, at_nompat#395194, at_pnopat#395195, at_njfpat#395196, at_datnai#395197, at_datnaiss#395198, at_sexe#395199, at_codpos#395209, at_ville#395210]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_codpos:string,at_ville:string>
(2) Project [codegen id : 1]
Output [14]: [at_numdos#395191 AS COL_499EB20D_E124_400E_A51E_F020884D243F#400279, at_stapat#395192 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, at_prefix#395193 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, at_nompat#395194 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, str_replace_extend(str_replace_extend(at_nompat#395194, [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#400364, at_pnopat#395195 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, str_replace_extend(str_replace_extend(at_pnopat#395195, [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#400366, at_njfpat#395196 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, at_datnai#395197 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, at_datnaiss#395198 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, at_sexe#395199 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, at_codpos#395209 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, at_ville#395210 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Input [11]: [at_numdos#395191, at_stapat#395192, at_prefix#395193, at_nompat#395194, at_pnopat#395195, at_njfpat#395196, at_datnai#395197, at_datnaiss#395198, at_sexe#395199, at_codpos#395209, at_ville#395210]
(3) 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 : 2]
Output [11]: [at_numdos#396418, at_stapat#396419, at_prefix#396420, at_nompat#396421, at_pnopat#396422, at_njfpat#396423, at_datnai#396424, at_datnaiss#396425, at_sexe#396426, at_codpos#396436, at_ville#396437]
ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_njfpat:string,at_datnai:string,at_datnaiss:string,at_sexe:string,at_codpos:string,at_ville:string>
(4) Project [codegen id : 2]
Output [14]: [at_numdos#396418 AS COL_499EB20D_E124_400E_A51E_F020884D243F#401063, at_stapat#396419 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#401064, at_prefix#396420 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#401065, at_nompat#396421 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#401066, str_replace_extend(str_replace_extend(at_nompat#396421, [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#401077, at_pnopat#396422 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#401067, str_replace_extend(str_replace_extend(at_pnopat#396422, [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#401078, at_njfpat#396423 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#401068, at_datnai#396424 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#401069, at_datnaiss#396425 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#401070, at_sexe#396426 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#401071, at_codpos#396436 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#401072, at_ville#396437 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#401073, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#401074]
Input [11]: [at_numdos#396418, at_stapat#396419, at_prefix#396420, at_nompat#396421, at_pnopat#396422, at_njfpat#396423, at_datnai#396424, at_datnaiss#396425, at_sexe#396426, at_codpos#396436, at_ville#396437]
(5) Union
(6) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#400279, 10), ENSURE_REQUIREMENTS, [plan_id=25409]
(7) ShuffleQueryStage
Output [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: 0
(8) AQEShuffleRead
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: coalesced
(9) Sort [codegen id : 7]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279 ASC NULLS FIRST], false, 0
(10) 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 : 3]
Output [1]: [at_numdos#400421]
ReadSchema: struct<at_numdos:string>
(11) Project [codegen id : 3]
Output [1]: [at_numdos#400421 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Input [1]: [at_numdos#400421]
(12) 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 : 4]
Output [1]: [at_numdos#400557]
ReadSchema: struct<at_numdos:string>
(13) Project [codegen id : 4]
Output [1]: [at_numdos#400557 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#401075]
Input [1]: [at_numdos#400557]
(14) Union
(15) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=25437]
(16) ShuffleQueryStage
Output [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: 1
(17) AQEShuffleRead
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: coalesced
(18) Sort [codegen id : 5]
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(19) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063], [1], [1 DESC NULLS LAST]
(20) Filter [codegen id : 6]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033)
(21) Project [codegen id : 6]
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063]
(22) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, 10), ENSURE_REQUIREMENTS, [plan_id=25548]
(23) ShuffleQueryStage
Output [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: 2
(24) AQEShuffleRead
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: coalesced
(25) Sort [codegen id : 8]
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399 ASC NULLS FIRST], false, 0
(26) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399]
Join type: LeftOuter
Join condition: None
(27) Filter [codegen id : 9]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Condition : ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010) END)
(28) Project [codegen id : 9]
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
(29) CollectLimit
Input [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Arguments: 1500
(30) Union
(31) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#400279, 10), ENSURE_REQUIREMENTS, [plan_id=25389]
(32) Sort
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279 ASC NULLS FIRST], false, 0
(33) Union
(34) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=25380]
(35) Sort
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(36) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063], [1], [1 DESC NULLS LAST]
(37) Filter
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033)
(38) Project
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#399033, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#399063]
(39) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, 10), ENSURE_REQUIREMENTS, [plan_id=25390]
(40) Sort
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399 ASC NULLS FIRST], false, 0
(41) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399]
Join type: LeftOuter
Join condition: None
(42) Filter
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
Condition : ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#400279)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409)), 10000000010) END)
(43) Project
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#400399, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#400409]
(44) CollectLimit
Input [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Arguments: 1500
(45) AdaptiveSparkPlan
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#400279, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#400280, COL_2B7D9197_D824_41CE_9E49_C420C3822425#400281, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#400282, COL_D741682E_18A7_4E09_96D0_47ED855868ED#400364, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#400283, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#400366, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#400284, COL_CB4739E1_E2F6_48D7_9602_079F56460634#400285, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#400286, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#400287, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#400288, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#400289, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#400290, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#400773]
Arguments: isFinalPlan=true