digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
2 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 165 ms";
4 [labelType="html" label="<b>Sort</b><br><br>sort time: 4 ms<br>peak memory: 66.0 MiB<br>spill size: 0.0 B"];
}
5 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 2.6 MiB<br>number of coalesced partitions: 1"];
6 [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>6 ms (3 ms, 3 ms, 3 ms (stage 1703.0: task 1495))<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: 2.4 MiB<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>7.0 MiB (3.5 MiB, 3.5 MiB, 3.5 MiB (stage 1703.0: task 1496))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>2.4 MiB (1223.1 KiB, 1223.2 KiB, 1223.2 KiB (stage 1703.0: task 1495))"];
7 [labelType="html" label="<br><b>Union</b><br><br>"];
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 60 ms";
9 [labelType="html" label="<br><b>Project</b><br><br>"];
10 [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 cluster11 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 64 ms";
12 [labelType="html" label="<br><b>Project</b><br><br>"];
13 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"at_numdos\", \"at_stapat\", \"at_prefix\", \"at_nompat\", \"at_pnopat\", \"at_njfpat\", \"at_datnai\", \"at_datnaiss\", \"at_sexe\", \"at_numper\", \"at_sigma\", \"at_verrou\", \"at_poids\", \"at_indcen\", \"at_numss\", \"at_antece\", \"at_adr_1\", \"at_adr_2\", \"at_codpos\", \"at_ville\", \"at_pays\", \"at_numcai\", \"at_nummut\", \"at_numcha\", \"at_telpri\", \"at_telbur\", \"at_telpor\", \"at_fax\", \"at_prefi2\", \"at_nomass\", \"at_pnoass\", \"at_njfass\", \"at_datass\", \"at_adr_1a\", \"at_adr_2a\", \"at_codpoa\", \"at_villea\", \"at_codmed\", \"at_datcss\", \"at_datf_d\", \"at_dat100\", \"at_numsir\", \"at_numssa\", \"at_codser\", \"at_rngnai\", \"at_natass\", \"at_numacc\", \"at_datacc\", \"at_typexo\", \"at_datmaj\", \"at_coduti\", \"at_flcmu\", \"at_qualss\", \"at_codref\", \"at_codregat\", \"at_codcaiat\", \"at_indvital\", \"at_conmut\", \"at_adhmut\", \"at_garmut\", \"at_numper_ori\", \"at_codrout\", \"at_domaine\", \"at_indtrai\", \"at_idhote\", \"at_codsts\", \"at_nirind\", \"at_fldcd\", \"at_flphoto\", \"at_codmtr\", \"at_adr_3\", \"at_pays_iso\", \"at_adr_3a\", \"at_poids_maj\", \"at_codgestion\", \"at_art115\", \"at_taille\", \"at_taille_maj\", \"at_codetab_prod\", \"at_codsit_prod\", \"at_numdos_prod\", \"at_numper_prod\", \"at_numper_ori_prod\", \"at_ins\", \"at_ins_type\", \"at_ins_date\", \"at_ins_source\", \"at_stadmp\", \"at_datdmp\", \"at_alarmes\", \"at_email\", \"at_consent_sms\", \"at_dat_consent_sms\", \"at_datdcd\", \"at_flhlim\", \"at_dathlim\", \"at_codpershlim\", \"at_fldiff\", \"at_lisdest\", \"at_langue\", \"at_numcai_ft\", \"at_codtarifamc\", \"at_flgrve\", \"at_fladri\", \"at_datadri\", \"at_datf_mut\", \"at_comfac\", \"at_numdos_cloud\", \"at_nation\", \"at_titre\", \"at_titre_ass\", \"at_tiq_histoxml\", \"at_tiq_pnoliste\", \"at_codposnai\", \"at_insi\", \"at_insi_oid\", \"at_typconv\", \"at_crisec\", \"at_opereg\", \"at_flannuamc\", \"at_staipp\", \"at_pnonai\", \"at_codinseenai\", \"at_villenai\", \"at_piece_ident_pres\", \"at_dat_staipp\", \"at_datapcv\", \"at_num_apcv\", \"at_heuapcv\", \"at_numper_sec\", \"at_ins_heure\", \"at_persaprev\", \"at_tarif\", \"at_nomhl7\", \"at_numper_ori_oid\", \"at_comment\" FROM \"xplore2\".\"h_patien\") as x) [numPartitions=1] </b><br><br>number of output rows: 23,504"];
}
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
9->7;
10->9;
12->7;
13->12;
}
14
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Window [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460], [1], [1 DESC NULLS LAST]
Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (3)
AQEShuffleRead coalesced
Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29294]
Union
Project [at_numdos#495588 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, at_stapat#495589 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, at_prefix#495590 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, at_nompat#495591 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, at_pnopat#495592 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, at_njfpat#495593 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, at_datnai#495594 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, at_datnaiss#495595 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, at_sexe#495596 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
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#495588,at_stapat#495589,at_prefix#495590,at_nompat#495591,at_pnopat#495592,at_njfpat#495593,at_datnai#495594,at_datnaiss#495595,at_sexe#495596] 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#496815 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499639, at_stapat#496816 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499640, at_prefix#496817 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499641, at_nompat#496818 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#499642, at_pnopat#496819 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499643, at_njfpat#496820 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499644, at_datnai#496821 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#499645, at_datnaiss#496822 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499646, at_sexe#496823 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499647]
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#496815,at_stapat#496816,at_prefix#496817,at_nompat#496818,at_pnopat#496819,at_njfpat#496820,at_datnai#496821,at_datnaiss#496822,at_sexe#496823] PushedFilters: [], ReadSchema: struct<at_numdos:string,at_stapat:string,at_prefix:string,at_nompat:string,at_pnopat:string,at_nj...
WholeStageCodegen (2)
== Physical Plan ==
AdaptiveSparkPlan (17)
+- == Final Plan ==
CollectLimit (11)
+- Window (10)
+- * Sort (9)
+- AQEShuffleRead (8)
+- ShuffleQueryStage (7), Statistics(sizeInBytes=7.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)
+- == Initial Plan ==
CollectLimit (16)
+- Window (15)
+- Sort (14)
+- Exchange (13)
+- Union (12)
:- 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)
(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 [9]: [at_numdos#495588, at_stapat#495589, at_prefix#495590, at_nompat#495591, at_pnopat#495592, at_njfpat#495593, at_datnai#495594, at_datnaiss#495595, at_sexe#495596]
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>
(2) Project [codegen id : 1]
Output [9]: [at_numdos#495588 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, at_stapat#495589 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, at_prefix#495590 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, at_nompat#495591 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, at_pnopat#495592 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, at_njfpat#495593 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, at_datnai#495594 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, at_datnaiss#495595 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, at_sexe#495596 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Input [9]: [at_numdos#495588, at_stapat#495589, at_prefix#495590, at_nompat#495591, at_pnopat#495592, at_njfpat#495593, at_datnai#495594, at_datnaiss#495595, at_sexe#495596]
(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 [9]: [at_numdos#496815, at_stapat#496816, at_prefix#496817, at_nompat#496818, at_pnopat#496819, at_njfpat#496820, at_datnai#496821, at_datnaiss#496822, at_sexe#496823]
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>
(4) Project [codegen id : 2]
Output [9]: [at_numdos#496815 AS COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499639, at_stapat#496816 AS COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499640, at_prefix#496817 AS COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499641, at_nompat#496818 AS COL_1903FED0_88C4_4416_9E39_453E598975A3#499642, at_pnopat#496819 AS COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499643, at_njfpat#496820 AS COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499644, at_datnai#496821 AS COL_B39F2F25_9917_471C_9C72_927B15008A79#499645, at_datnaiss#496822 AS COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499646, at_sexe#496823 AS COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499647]
Input [9]: [at_numdos#496815, at_stapat#496816, at_prefix#496817, at_nompat#496818, at_pnopat#496819, at_njfpat#496820, at_datnai#496821, at_datnaiss#496822, at_sexe#496823]
(5) Union
(6) Exchange
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29294]
(7) ShuffleQueryStage
Output [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: 0
(8) AQEShuffleRead
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: coalesced
(9) Sort [codegen id : 3]
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(10) Window
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460], [1], [1 DESC NULLS LAST]
(11) CollectLimit
Input [10]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460]
Arguments: 1500
(12) Union
(13) Exchange
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=29279]
(14) Sort
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(15) Window
Input [9]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438]
Arguments: [row_number() windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460], [1], [1 DESC NULLS LAST]
(16) CollectLimit
Input [10]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460]
Arguments: 1500
(17) AdaptiveSparkPlan
Output [10]: [COL_82A081FF_66A7_4F4D_81C2_AE1F8E32863B#499430, COL_B42FDEFA_8CD8_4845_A225_07920E109AE2#499431, COL_A08BD11B_2A35_4C12_A43D_FD62E19A8255#499432, COL_1903FED0_88C4_4416_9E39_453E598975A3#499433, COL_7AB9FE42_3CB0_46DC_BF4A_1098E30C5F7A#499434, COL_1173BDDB_4834_434B_B562_ADD54184DF6C#499435, COL_B39F2F25_9917_471C_9C72_927B15008A79#499436, COL_001FD63A_E498_406F_9C26_CF9B54A0EB15#499437, COL_909AFACE_1CD5_4582_B369_4DE55E19FA42#499438, COL_32DB2537_C581_41C7_BD88_8AA9F64BF755#499460]
Arguments: isFinalPlan=true