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 (10)\n \nduration: 0 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 1,500<br>spill size: 0.0 B"];
}
subgraph cluster5 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 0 ms";
6 [labelType="html" label="<b>Sort</b><br><br>sort time: 2 ms<br>peak memory: 64.1 MiB<br>spill size: 0.0 B"];
}
7 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 281.4 KiB<br>number of coalesced partitions: 1"];
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>3 ms (1 ms, 1 ms, 1 ms (stage 1729.0: task 1518))<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: 268.1 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>735.4 KiB (367.7 KiB, 367.7 KiB, 367.7 KiB (stage 1729.0: task 1518))<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>268.1 KiB (133.5 KiB, 134.6 KiB, 134.6 KiB (stage 1729.0: task 1519))"];
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n55 ms (27 ms, 28 ms, 28 ms (stage 1729.0: task 1518))";
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 \"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: 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 \"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: 1,500"];
}
subgraph cluster20 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 0 ms";
21 [labelType="html" label="<b>Sort</b><br><br>sort time: 31 ms<br>peak memory: 66.0 MiB<br>spill size: 0.0 B"];
}
22 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 680.2 KiB<br>number of coalesced partitions: 1"];
23 [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: 654.8 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<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 cluster24 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 106 ms";
25 [labelType="html" label="<br><b>Project</b><br><br>"];
26 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 47,008"];
}
27 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster28 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 38 ms";
29 [labelType="html" label="<b>Sort</b><br><br>sort time: 1 ms<br>peak memory: 66.0 MiB<br>spill size: 0.0 B"];
}
30 [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"];
31 [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>1 ms (0 ms, 0 ms, 0 ms (stage 1730.0: task 1521))<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 1730.0: task 1520))<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 1730.0: task 1521))"];
32 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster33 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 11 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 \"xplore\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster36 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 14 ms";
37 [labelType="html" label="<br><b>Project</b><br><br>"];
38 [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;
23->22;
25->23;
26->25;
27->26;
29->27;
30->29;
31->30;
32->31;
34->32;
35->34;
37->32;
38->37;
}
39
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Project [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#534861], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981], LeftOuter
WholeStageCodegen (10)
Sort [COL_499EB20D_E124_400E_A51E_F020884D243F#534861 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#534861, 10), ENSURE_REQUIREMENTS, [plan_id=29948]
LocalLimit 1500
WholeStageCodegen (3)
Union
LocalLimit 1500
Project [at_numdos#529773 AS COL_499EB20D_E124_400E_A51E_F020884D243F#534861, at_stapat#529774 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, at_prefix#529775 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, at_nompat#529776 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, str_replace_extend(str_replace_extend(at_nompat#529776, [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#534946, at_pnopat#529777 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, str_replace_extend(str_replace_extend(at_pnopat#529777, [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#534948, at_njfpat#529778 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, at_datnai#529779 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, at_datnaiss#529780 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, at_sexe#529781 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, at_codpos#529791 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, at_ville#529792 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
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#529773,at_stapat#529774,at_prefix#529775,at_nompat#529776,at_pnopat#529777,at_njfpat#529778,at_datnai#529779,at_datnaiss#529780,at_sexe#529781,at_codpos#529791,at_ville#529792] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (1)
LocalLimit 1500
Project [at_numdos#531000 AS COL_499EB20D_E124_400E_A51E_F020884D243F#535645, at_stapat#531001 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#535646, at_prefix#531002 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#535647, at_nompat#531003 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#535648, str_replace_extend(str_replace_extend(at_nompat#531003, [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#535659, at_pnopat#531004 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#535649, str_replace_extend(str_replace_extend(at_pnopat#531004, [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#535660, at_njfpat#531005 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#535650, at_datnai#531006 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#535651, at_datnaiss#531007 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#535652, at_sexe#531008 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#535653, at_codpos#531018 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#535654, at_ville#531019 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#535655, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#535656]
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#531000,at_stapat#531001,at_prefix#531002,at_nompat#531003,at_pnopat#531004,at_njfpat#531005,at_datnai#531006,at_datnaiss#531007,at_sexe#531008,at_codpos#531018,at_ville#531019] 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#534981 ASC NULLS FIRST], false, 0
WholeStageCodegen (9)
AQEShuffleRead coalesced
Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, 10), ENSURE_REQUIREMENTS, [plan_id=30081]
Project [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Filter isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615)
WholeStageCodegen (7)
Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645], [1], [1 DESC NULLS LAST]
Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (6)
AQEShuffleRead coalesced
Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29979]
Union
Project [at_numdos#535003 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
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#535003] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (4)
Project [at_numdos#535139 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#535657]
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#535139] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (5)
== Physical Plan ==
AdaptiveSparkPlan (47)
+- == Final Plan ==
CollectLimit (31)
+- * Project (30)
+- * SortMergeJoin LeftOuter (29)
:- * Sort (12)
: +- AQEShuffleRead (11)
: +- ShuffleQueryStage (10), Statistics(sizeInBytes=735.4 KiB, rowCount=3.00E+3)
: +- Exchange (9)
: +- * LocalLimit (8)
: +- Union (7)
: :- * LocalLimit (3)
: : +- * 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)
: +- * LocalLimit (6)
: +- * Project (5)
: +- * 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] (4)
+- * Sort (28)
+- AQEShuffleRead (27)
+- ShuffleQueryStage (26), Statistics(sizeInBytes=2.4 MiB, rowCount=4.70E+4)
+- Exchange (25)
+- * Project (24)
+- * Filter (23)
+- Window (22)
+- * Sort (21)
+- AQEShuffleRead (20)
+- ShuffleQueryStage (19), Statistics(sizeInBytes=1403.6 KiB, 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)
+- == Initial Plan ==
CollectLimit (46)
+- Project (45)
+- SortMergeJoin LeftOuter (44)
:- Sort (35)
: +- Exchange (34)
: +- LocalLimit (33)
: +- Union (32)
: :- LocalLimit (3)
: : +- 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)
: +- LocalLimit (6)
: +- Project (5)
: +- 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] (4)
+- Sort (43)
+- Exchange (42)
+- Project (41)
+- Filter (40)
+- Window (39)
+- Sort (38)
+- Exchange (37)
+- Union (36)
:- 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)
(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#529773, at_stapat#529774, at_prefix#529775, at_nompat#529776, at_pnopat#529777, at_njfpat#529778, at_datnai#529779, at_datnaiss#529780, at_sexe#529781, at_codpos#529791, at_ville#529792]
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#529773 AS COL_499EB20D_E124_400E_A51E_F020884D243F#534861, at_stapat#529774 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, at_prefix#529775 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, at_nompat#529776 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, str_replace_extend(str_replace_extend(at_nompat#529776, [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#534946, at_pnopat#529777 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, str_replace_extend(str_replace_extend(at_pnopat#529777, [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#534948, at_njfpat#529778 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, at_datnai#529779 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, at_datnaiss#529780 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, at_sexe#529781 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, at_codpos#529791 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, at_ville#529792 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Input [11]: [at_numdos#529773, at_stapat#529774, at_prefix#529775, at_nompat#529776, at_pnopat#529777, at_njfpat#529778, at_datnai#529779, at_datnaiss#529780, at_sexe#529781, at_codpos#529791, at_ville#529792]
(3) LocalLimit [codegen id : 1]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: 1500
(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] [codegen id : 2]
Output [11]: [at_numdos#531000, at_stapat#531001, at_prefix#531002, at_nompat#531003, at_pnopat#531004, at_njfpat#531005, at_datnai#531006, at_datnaiss#531007, at_sexe#531008, at_codpos#531018, at_ville#531019]
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>
(5) Project [codegen id : 2]
Output [14]: [at_numdos#531000 AS COL_499EB20D_E124_400E_A51E_F020884D243F#535645, at_stapat#531001 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#535646, at_prefix#531002 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#535647, at_nompat#531003 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#535648, str_replace_extend(str_replace_extend(at_nompat#531003, [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#535659, at_pnopat#531004 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#535649, str_replace_extend(str_replace_extend(at_pnopat#531004, [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#535660, at_njfpat#531005 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#535650, at_datnai#531006 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#535651, at_datnaiss#531007 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#535652, at_sexe#531008 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#535653, at_codpos#531018 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#535654, at_ville#531019 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#535655, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#535656]
Input [11]: [at_numdos#531000, at_stapat#531001, at_prefix#531002, at_nompat#531003, at_pnopat#531004, at_njfpat#531005, at_datnai#531006, at_datnaiss#531007, at_sexe#531008, at_codpos#531018, at_ville#531019]
(6) LocalLimit [codegen id : 2]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#535645, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#535646, COL_2B7D9197_D824_41CE_9E49_C420C3822425#535647, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#535648, COL_D741682E_18A7_4E09_96D0_47ED855868ED#535659, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#535649, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#535660, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#535650, COL_CB4739E1_E2F6_48D7_9602_079F56460634#535651, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#535652, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#535653, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#535654, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#535655, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#535656]
Arguments: 1500
(7) Union
(8) LocalLimit [codegen id : 3]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: 1500
(9) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#534861, 10), ENSURE_REQUIREMENTS, [plan_id=29948]
(10) ShuffleQueryStage
Output [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: 0
(11) AQEShuffleRead
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: coalesced
(12) Sort [codegen id : 8]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861 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 [1]: [at_numdos#535003]
ReadSchema: struct<at_numdos:string>
(14) Project [codegen id : 4]
Output [1]: [at_numdos#535003 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Input [1]: [at_numdos#535003]
(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 [1]: [at_numdos#535139]
ReadSchema: struct<at_numdos:string>
(16) Project [codegen id : 5]
Output [1]: [at_numdos#535139 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#535657]
Input [1]: [at_numdos#535139]
(17) Union
(18) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29979]
(19) ShuffleQueryStage
Output [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: 1
(20) AQEShuffleRead
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: coalesced
(21) Sort [codegen id : 6]
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(22) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645], [1], [1 DESC NULLS LAST]
(23) Filter [codegen id : 7]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615)
(24) Project [codegen id : 7]
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645]
(25) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, 10), ENSURE_REQUIREMENTS, [plan_id=30081]
(26) ShuffleQueryStage
Output [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: 2
(27) AQEShuffleRead
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: coalesced
(28) Sort [codegen id : 9]
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981 ASC NULLS FIRST], false, 0
(29) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981]
Join type: LeftOuter
Join condition: None
(30) Project [codegen id : 10]
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
(31) CollectLimit
Input [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
Arguments: 1500
(32) Union
(33) LocalLimit
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: 1500
(34) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#534861, 10), ENSURE_REQUIREMENTS, [plan_id=29923]
(35) Sort
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861 ASC NULLS FIRST], false, 0
(36) Union
(37) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29914]
(38) Sort
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(39) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645], [1], [1 DESC NULLS LAST]
(40) Filter
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615)
(41) Project
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#533615, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#533645]
(42) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, 10), ENSURE_REQUIREMENTS, [plan_id=29924]
(43) Sort
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981 ASC NULLS FIRST], false, 0
(44) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981]
Join type: LeftOuter
Join condition: None
(45) Project
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991 AS COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#534981, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#534991]
(46) CollectLimit
Input [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
Arguments: 1500
(47) AdaptiveSparkPlan
Output [15]: [COL_499EB20D_E124_400E_A51E_F020884D243F#534861, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#534862, COL_2B7D9197_D824_41CE_9E49_C420C3822425#534863, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#534864, COL_D741682E_18A7_4E09_96D0_47ED855868ED#534946, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#534865, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#534948, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#534866, COL_CB4739E1_E2F6_48D7_9602_079F56460634#534867, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#534868, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#534869, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#534870, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#534871, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#534872, COL_E55852F9_036F_45C1_862C_C2DC4F3BEE9D#535355]
Arguments: isFinalPlan=true