digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 0 ms";
2 [labelType="html" label="<b>HashAggregate</b><br><br>time in aggregation build: 0 ms<br>number of output rows: 1"];
}
3 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 2<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1543.0: task 1384))<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: 2<br>local bytes read: 118.0 B<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>32.0 B (16.0 B, 16.0 B, 16.0 B (stage 1543.0: task 1385))<br>local merged bytes read: 0.0 B<br>number of partitions: 1<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>118.0 B (59.0 B, 59.0 B, 59.0 B (stage 1543.0: task 1385))"];
subgraph cluster4 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (769 ms, 824 ms, 824 ms (stage 1543.0: task 1384))";
5 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build total (min, med, max (stageId: taskId))<br>1.6 s (769 ms, 824 ms, 824 ms (stage 1543.0: task 1384))<br>peak memory: 0.0 B<br>number of output rows: 2<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 7"];
8 [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 1543.0: task 1385))"];
}
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (797 ms, 852 ms, 852 ms (stage 1543.0: task 1384))";
10 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>46 ms (14 ms, 32 ms, 32 ms (stage 1543.0: task 1384))<br>peak memory total (min, med, max (stageId: taskId))<br>130.0 MiB (65.0 MiB, 65.0 MiB, 65.0 MiB (stage 1543.0: task 1385))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1543.0: task 1385))"];
}
11 [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"];
12 [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>15 ms (7 ms, 7 ms, 7 ms (stage 1536.0: task 1379))<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 1543.0: task 1384))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1543.0: task 1385))<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 1536.0: task 1379))<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 1536.0: task 1380))"];
13 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 335 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 \"xplore\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster17 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 336 ms";
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: 23,504"];
}
subgraph cluster20 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n1.6 s (796 ms, 850 ms, 850 ms (stage 1543.0: task 1384))";
21 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>28 ms (14 ms, 14 ms, 14 ms (stage 1543.0: task 1385))<br>peak memory total (min, med, max (stageId: taskId))<br>130.0 MiB (65.0 MiB, 65.0 MiB, 65.0 MiB (stage 1543.0: task 1385))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 1543.0: task 1385))"];
}
22 [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"];
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 total (min, med, max (stageId: taskId))<br>654.8 KiB (325.4 KiB, 329.5 KiB, 329.5 KiB (stage 1543.0: task 1384))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 1543.0: task 1385))<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 cluster24 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 117 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 (5)\n \nduration: 43 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>3 ms (1 ms, 2 ms, 2 ms (stage 1537.0: task 1381))<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 1537.0: task 1381))<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 1537.0: task 1382))"];
32 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster33 {
isCluster="true";
label="WholeStageCodegen (3)\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 \"xplore\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
subgraph cluster36 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 12 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"];
}
2->0;
3->2;
5->3;
6->5;
7->6;
8->7;
10->8;
11->10;
12->11;
13->12;
15->13;
16->15;
18->13;
19->18;
21->8;
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
HashAggregate(keys=[], functions=[count(1)])
WholeStageCodegen (10)
Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=25287]
HashAggregate(keys=[], functions=[partial_count(1)])
Project
Filter ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010) END)
SortMergeJoin [COL_499EB20D_E124_400E_A51E_F020884D243F#394371], [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491], LeftOuter
WholeStageCodegen (9)
Sort [COL_499EB20D_E124_400E_A51E_F020884D243F#394371 ASC NULLS FIRST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#394371, 10), ENSURE_REQUIREMENTS, [plan_id=25057]
Union
Project [at_numdos#389283 AS COL_499EB20D_E124_400E_A51E_F020884D243F#394371, at_stapat#389284 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, at_prefix#389285 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, at_nompat#389286 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, str_replace_extend(str_replace_extend(at_nompat#389286, [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#394456, at_pnopat#389287 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, str_replace_extend(str_replace_extend(at_pnopat#389287, [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#394458, at_njfpat#389288 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, at_datnai#389289 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, at_datnaiss#389290 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, at_sexe#389291 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, at_codpos#389301 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, at_ville#389302 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
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#389283,at_stapat#389284,at_prefix#389285,at_nompat#389286,at_pnopat#389287,at_njfpat#389288,at_datnai#389289,at_datnaiss#389290,at_sexe#389291,at_codpos#389301,at_ville#389302] 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#390510 AS COL_499EB20D_E124_400E_A51E_F020884D243F#395173, at_stapat#390511 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#395174, at_prefix#390512 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#395175, at_nompat#390513 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#395176, str_replace_extend(str_replace_extend(at_nompat#390513, [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#395187, at_pnopat#390514 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#395177, str_replace_extend(str_replace_extend(at_pnopat#390514, [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#395188, at_njfpat#390515 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#395178, at_datnai#390516 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#395179, at_datnaiss#390517 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#395180, at_sexe#390518 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#395181, at_codpos#390528 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#395182, at_ville#390529 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#395183, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#395184]
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#390510,at_stapat#390511,at_prefix#390512,at_nompat#390513,at_pnopat#390514,at_njfpat#390515,at_datnai#390516,at_datnaiss#390517,at_sexe#390518,at_codpos#390528,at_ville#390529] 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#394491 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, 10), ENSURE_REQUIREMENTS, [plan_id=25205]
Project [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Filter isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125)
WholeStageCodegen (6)
Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155], [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=25068]
Union
Project [at_numdos#394513 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
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#394513] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (3)
Project [at_numdos#394649 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#395185]
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#394649] PushedFilters: [], ReadSchema: struct<at_numdos:string>
WholeStageCodegen (4)
== Physical Plan ==
AdaptiveSparkPlan (50)
+- == Final Plan ==
* HashAggregate (32)
+- ShuffleQueryStage (31), Statistics(sizeInBytes=32.0 B, rowCount=2)
+- Exchange (30)
+- * HashAggregate (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 ==
HashAggregate (49)
+- Exchange (48)
+- HashAggregate (47)
+- Project (46)
+- Filter (45)
+- SortMergeJoin LeftOuter (44)
:- Sort (35)
: +- Exchange (34)
: +- Union (33)
: :- 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 (43)
+- Exchange (42)
+- Project (41)
+- Filter (40)
+- Window (39)
+- Sort (38)
+- Exchange (37)
+- Union (36)
:- 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#389283, at_stapat#389284, at_prefix#389285, at_nompat#389286, at_pnopat#389287, at_njfpat#389288, at_datnai#389289, at_datnaiss#389290, at_sexe#389291, at_codpos#389301, at_ville#389302]
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#389283 AS COL_499EB20D_E124_400E_A51E_F020884D243F#394371, at_stapat#389284 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, at_prefix#389285 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, at_nompat#389286 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, str_replace_extend(str_replace_extend(at_nompat#389286, [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#394456, at_pnopat#389287 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, str_replace_extend(str_replace_extend(at_pnopat#389287, [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#394458, at_njfpat#389288 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, at_datnai#389289 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, at_datnaiss#389290 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, at_sexe#389291 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, at_codpos#389301 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, at_ville#389302 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, str_create(Cab_A) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Input [11]: [at_numdos#389283, at_stapat#389284, at_prefix#389285, at_nompat#389286, at_pnopat#389287, at_njfpat#389288, at_datnai#389289, at_datnaiss#389290, at_sexe#389291, at_codpos#389301, at_ville#389302]
(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#390510, at_stapat#390511, at_prefix#390512, at_nompat#390513, at_pnopat#390514, at_njfpat#390515, at_datnai#390516, at_datnaiss#390517, at_sexe#390518, at_codpos#390528, at_ville#390529]
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#390510 AS COL_499EB20D_E124_400E_A51E_F020884D243F#395173, at_stapat#390511 AS COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#395174, at_prefix#390512 AS COL_2B7D9197_D824_41CE_9E49_C420C3822425#395175, at_nompat#390513 AS COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#395176, str_replace_extend(str_replace_extend(at_nompat#390513, [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#395187, at_pnopat#390514 AS COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#395177, str_replace_extend(str_replace_extend(at_pnopat#390514, [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#395188, at_njfpat#390515 AS COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#395178, at_datnai#390516 AS COL_CB4739E1_E2F6_48D7_9602_079F56460634#395179, at_datnaiss#390517 AS COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#395180, at_sexe#390518 AS COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#395181, at_codpos#390528 AS COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#395182, at_ville#390529 AS COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#395183, str_create(Cab_B) AS COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#395184]
Input [11]: [at_numdos#390510, at_stapat#390511, at_prefix#390512, at_nompat#390513, at_pnopat#390514, at_njfpat#390515, at_datnai#390516, at_datnaiss#390517, at_sexe#390518, at_codpos#390528, at_ville#390529]
(5) Union
(6) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#394371, 10), ENSURE_REQUIREMENTS, [plan_id=25057]
(7) ShuffleQueryStage
Output [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: 0
(8) AQEShuffleRead
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: coalesced
(9) Sort [codegen id : 7]
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371 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#394513]
ReadSchema: struct<at_numdos:string>
(11) Project [codegen id : 3]
Output [1]: [at_numdos#394513 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Input [1]: [at_numdos#394513]
(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#394649]
ReadSchema: struct<at_numdos:string>
(13) Project [codegen id : 4]
Output [1]: [at_numdos#394649 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#395185]
Input [1]: [at_numdos#394649]
(14) Union
(15) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=25068]
(16) ShuffleQueryStage
Output [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: 1
(17) AQEShuffleRead
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: coalesced
(18) Sort [codegen id : 5]
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(19) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155], [1], [1 DESC NULLS LAST]
(20) Filter [codegen id : 6]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125)
(21) Project [codegen id : 6]
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155]
(22) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, 10), ENSURE_REQUIREMENTS, [plan_id=25205]
(23) ShuffleQueryStage
Output [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: 2
(24) AQEShuffleRead
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: coalesced
(25) Sort [codegen id : 8]
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491 ASC NULLS FIRST], false, 0
(26) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491]
Join type: LeftOuter
Join condition: None
(27) Filter [codegen id : 9]
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Condition : ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010) END)
(28) Project [codegen id : 9]
Output: []
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
(29) HashAggregate [codegen id : 9]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#395189L]
Results [1]: [count#395190L]
(30) Exchange
Input [1]: [count#395190L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=25287]
(31) ShuffleQueryStage
Output [1]: [count#395190L]
Arguments: 3
(32) HashAggregate [codegen id : 10]
Input [1]: [count#395190L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#394896L]
Results [1]: [count(1)#394896L AS count#394897L]
(33) Union
(34) Exchange
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: hashpartitioning(COL_499EB20D_E124_400E_A51E_F020884D243F#394371, 10), ENSURE_REQUIREMENTS, [plan_id=25005]
(35) Sort
Input [14]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382]
Arguments: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371 ASC NULLS FIRST], false, 0
(36) Union
(37) Exchange
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=24996]
(38) Sort
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(39) Window
Input [1]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155], [1], [1 DESC NULLS LAST]
(40) Filter
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155]
Condition : isnotnull(COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125)
(41) Project
Output [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125 AS H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, str_concat(array(U1, str_complete(bigint_to_str(COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155), 0, 10, LEFT))) AS H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Input [2]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#393125, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#393155]
(42) Exchange
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: hashpartitioning(H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, 10), ENSURE_REQUIREMENTS, [plan_id=25006]
(43) Sort
Input [2]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Arguments: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491 ASC NULLS FIRST], false, 0
(44) SortMergeJoin
Left keys [1]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371]
Right keys [1]: [H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491]
Join type: LeftOuter
Join condition: None
(45) Filter
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
Condition : ((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_499EB20D_E124_400E_A51E_F020884D243F#394371)), 10000000010) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382)), 10000000010) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010)) THEN false ELSE Contains(str_remove_accent(upper(H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501)), 10000000010) END)
(46) Project
Output: []
Input [16]: [COL_499EB20D_E124_400E_A51E_F020884D243F#394371, COL_A9D76CF5_2B72_4797_8162_50D3EC4025F5#394372, COL_2B7D9197_D824_41CE_9E49_C420C3822425#394373, COL_AA64E8D3_7ED0_414B_866A_8621D0D7CAAF#394374, COL_D741682E_18A7_4E09_96D0_47ED855868ED#394456, COL_7FAA4F01_934E_4C63_AFB7_19B1EC986E3E#394375, COL_A172DAB9_DF0B_4747_83A1_22D06801DFF7#394458, COL_E0620654_CC4B_4BA2_B4D0_92A6E070406C#394376, COL_CB4739E1_E2F6_48D7_9602_079F56460634#394377, COL_FBA511B8_2EA0_43D6_A93A_34E57C0BCFE9#394378, COL_8AAB4531_E92B_4285_8733_BB3FCA8B2F33#394379, COL_9C4B35A3_D42F_438A_9AA2_60B2260EE33B#394380, COL_63F964BD_E655_4F23_9E40_0A336B9ABF65#394381, COL_73FF62BD_ACEB_460F_A240_DD5A76AEE0B1#394382, H_PATIEN_440160_COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#394491, H_PATIEN_440160_COL_98153E3F_DC33_426E_BFAF_B0A130FCDDC3#394501]
(47) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#395189L]
Results [1]: [count#395190L]
(48) Exchange
Input [1]: [count#395190L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=25014]
(49) HashAggregate
Input [1]: [count#395190L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#394896L]
Results [1]: [count(1)#394896L AS count#394897L]
(50) AdaptiveSparkPlan
Output [1]: [count#394897L]
Arguments: isFinalPlan=true