EVAL1_SPC1 - Details for Query 190

Submitted Time: 2026/06/09 13:27:48
Duration: 4 s
Succeeded Jobs: 372 373 376 377

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 3 ms peak memory: 64.5 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="Exchange shuffle records written: 138,151 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 56 ms (10 ms, 11 ms, 11 ms (stage 726.0: task 1552)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 13,617 local bytes read: 1698.6 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 55.3 MiB (10.8 MiB, 11.1 MiB, 11.2 MiB (stage 726.0: task 1553)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 16.9 MiB (3.3 MiB, 3.4 MiB, 3.4 MiB (stage 726.0: task 1553))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (364 ms, 398 ms, 453 ms (stage 726.0: task 1555))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="SortMergeJoin number of output rows: 138,151 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 726.0: task 1554))"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (366 ms, 400 ms, 455 ms (stage 726.0: task 1555))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 1 ms (stage 726.0: task 1554)) peak memory total (min, med, max (stageId: taskId)) 321.2 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 726.0: task 1554)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 726.0: task 1554))"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 3.5 MiB (713.8 KiB, 713.8 KiB, 722.7 KiB (driver)) number of coalesced partitions: 5"]; 14 [labelType="html" label="Exchange shuffle records written: 51,055 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 12 ms (3 ms, 8 ms, 8 ms (stage 715.0: task 1548)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 51,055 local bytes read total (min, med, max (stageId: taskId)) 3.3 MiB (664.7 KiB, 685.5 KiB, 691.9 KiB (stage 726.0: task 1553)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 726.0: task 1554)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 11.9 MiB (1439.5 KiB, 10.5 MiB, 10.5 MiB (stage 715.0: task 1548)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 3.3 MiB (436.2 KiB, 2.9 MiB, 2.9 MiB (stage 715.0: task 1548))"]; 15 [labelType="html" label=" Union "]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 44 ms"; 17 [labelType="html" label=" Project "]; } 18 [labelType="html" label="Scan csv number of output rows: 6,031 number of files read: 1 metadata time: 0 ms size of files read: 514.2 KiB"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 1.2 s"; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label="Scan JDBCRelation((SELECT \"IPP\", \"NOM_FAM\", \"PRENOM\", \"NOM_NAISSANCE\", \"NATIONALITE\", \"SEXE\", \"CIVILITE\", \"DATE_NAIS\", \"FINESS_ETAB\", \"INSC\", \"CODE ETAB\", \"NOM ETAB\" FROM \"formation\".\"patient_etab_sta\") as x) [numPartitions=1] number of output rows: 45,024"]; } subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n2.3 s (399 ms, 730 ms, 800 ms (stage 726.0: task 1556))"; 23 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 8 ms (1 ms, 2 ms, 2 ms (stage 726.0: task 1554)) peak memory total (min, med, max (stageId: taskId)) 322.5 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 726.0: task 1554)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 726.0: task 1554))"]; } 24 [labelType="html" label="AQEShuffleRead number of partitions: 5 partition data size total (min, med, max (stageId: taskId)) 5.9 MiB (1218.2 KiB, 1218.2 KiB, 1218.2 KiB (driver)) number of coalesced partitions: 5"]; 25 [labelType="html" label="Exchange shuffle records written: 95,000 local merged chunks fetched: 0 shuffle write time: 16 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 95,000 local bytes read total (min, med, max (stageId: taskId)) 5.5 MiB (1120.6 KiB, 1142.8 KiB, 1145.2 KiB (stage 726.0: task 1553)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 726.0: task 1554)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size: 10.9 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 5.5 MiB"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 2.4 s"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="Scan JDBCRelation((SELECT \"IPP\", \"Code-etablissement\", \"rue\", \"code-postal\", \"commune\", \"Latitude-Adresse\", \"Longitude-Adresse\" FROM \"formation\".\"adresse_patient\") as x) [numPartitions=1] number of output rows: 95,000"]; } 1->0; 3->1; 4->3; 6->4; 7->6; 9->7; 10->9; 12->10; 13->12; 14->13; 15->14; 17->15; 18->17; 20->15; 21->20; 23->10; 24->23; 25->24; 27->25; 28->27; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]

WholeStageCodegen (8)

Window [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653], [1 DESC NULLS LAST]

Sort [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (7)

Exchange hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 10), ENSURE_REQUIREMENTS, [plan_id=28808]

Project [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, ADRESSE_PATIENT_23201_RUE_23204#87410 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, ADRESSE_PATIENT_23201_COMMUNE_23206#87406 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, str_extract(ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]

SortMergeJoin [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371], [ADRESSE_PATIENT_23201_IPP_23202#87407], LeftOuter

WholeStageCodegen (6)

Sort [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, 10), ENSURE_REQUIREMENTS, [plan_id=28630]

Union

Project [N°Patient #87044 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, Nom de Famille#87045 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, Prénom#87046 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, Nom de naissance#87047 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, Nationalité#87048 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, Sexe#87049 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, Civilité#87050 AS COL_1856A62C_995E_4541_9113_FCAF59469832#87377, Date naissance#87051 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, Date naissance#87051 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, INSC#87053 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, CODE ETABLISSEMENT#87054 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, LABEL ETABLISSEMENT#87055 AS COL_48938166_DC92_438A_BDE1_798596353709#87382, str_extract(Date naissance#87051, LEFT, 4) AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]

WholeStageCodegen (1)

FileScan csv [N°Patient #87044,Nom de Famille#87045,Prénom#87046,Nom de naissance#87047,Nationalité#87048,Sexe#87049,Civilité#87050,Date naissance#87051,INSC#87053,CODE ETABLISSEMENT#87054,LABEL ETABLISSEMENT#87055] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/DEPOT_CONNECTEU_23174/PATIENT_ETAB_VAL-..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<N°Patient :string,Nom de Famille:string,Prénom:string,Nom de naissance:string,Nationalité:...

Project [IPP#87145 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87860, NOM_FAM#87146 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87861, PRENOM#87147 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87862, NOM_NAISSANCE#87148 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87863, NATIONALITE#87149 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87864, SEXE#87150 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87865, CIVILITE#87151 AS COL_1856A62C_995E_4541_9113_FCAF59469832#87866, DATE_NAIS#87152 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87867, FINESS_ETAB#87153 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87868, INSC#87154 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87869, CODE ETAB#87155 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87870, NOM ETAB#87156 AS COL_48938166_DC92_438A_BDE1_798596353709#87871, str_extract(DATE_NAIS#87152, LEFT, 4) AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87872]

Scan JDBCRelation((SELECT "IPP", "NOM_FAM", "PRENOM", "NOM_NAISSANCE", "NATIONALITE", "SEXE", "CIVILITE", "DATE_NAIS", "FINESS_ETAB", "INSC", "CODE ETAB", "NOM ETAB" FROM "formation"."patient_etab_sta") as x) [numPartitions=1] [IPP#87145,NOM_FAM#87146,PRENOM#87147,NOM_NAISSANCE#87148,NATIONALITE#87149,SEXE#87150,CIVILITE#87151,DATE_NAIS#87152,FINESS_ETAB#87153,INSC#87154,CODE ETAB#87155,NOM ETAB#87156] PushedFilters: [], ReadSchema: struct<IPP:string,NOM_FAM:string,PRENOM:string,NOM_NAISSANCE:string,NATIONALITE:string,SEXE:strin...

WholeStageCodegen (2)

Sort [ADRESSE_PATIENT_23201_IPP_23202#87407 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(ADRESSE_PATIENT_23201_IPP_23202#87407, 10), ENSURE_REQUIREMENTS, [plan_id=28642]

Project [code-postal#86086 AS ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, commune#86087 AS ADRESSE_PATIENT_23201_COMMUNE_23206#87406, IPP#86083 AS ADRESSE_PATIENT_23201_IPP_23202#87407, Latitude-Adresse#86088 AS ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, Longitude-Adresse#86089 AS ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, rue#86085 AS ADRESSE_PATIENT_23201_RUE_23204#87410]

Scan JDBCRelation((SELECT "IPP", "Code-etablissement", "rue", "code-postal", "commune", "Latitude-Adresse", "Longitude-Adresse" FROM "formation"."adresse_patient") as x) [numPartitions=1] [code-postal#86086,commune#86087,IPP#86083,Latitude-Adresse#86088,Longitude-Adresse#86089,rue#86085] PushedFilters: [*IsNotNull(IPP)], ReadSchema: struct<code-postal:string,commune:string,IPP:string,Latitude-Adresse:double,Longitude-Adresse:dou...

WholeStageCodegen (3)

Details

== Physical Plan ==
AdaptiveSparkPlan (37)
+- == Final Plan ==
   CollectLimit (23)
   +- * Project (22)
      +- Window (21)
         +- * Sort (20)
            +- ShuffleQueryStage (19), Statistics(sizeInBytes=55.3 MiB, rowCount=1.38E+5)
               +- Exchange (18)
                  +- * Project (17)
                     +- * SortMergeJoin LeftOuter (16)
                        :- * Sort (9)
                        :  +- AQEShuffleRead (8)
                        :     +- ShuffleQueryStage (7), Statistics(sizeInBytes=11.9 MiB, rowCount=5.11E+4)
                        :        +- Exchange (6)
                        :           +- Union (5)
                        :              :- * Project (2)
                        :              :  +- Scan csv  (1)
                        :              +- * Project (4)
                        :                 +- * Scan JDBCRelation((SELECT "IPP", "NOM_FAM", "PRENOM", "NOM_NAISSANCE", "NATIONALITE", "SEXE", "CIVILITE", "DATE_NAIS", "FINESS_ETAB", "INSC", "CODE ETAB", "NOM ETAB" FROM "formation"."patient_etab_sta") as x) [numPartitions=1]  (3)
                        +- * Sort (15)
                           +- AQEShuffleRead (14)
                              +- ShuffleQueryStage (13), Statistics(sizeInBytes=10.9 MiB, rowCount=9.50E+4)
                                 +- Exchange (12)
                                    +- * Project (11)
                                       +- * Scan JDBCRelation((SELECT "IPP", "Code-etablissement", "rue", "code-postal", "commune", "Latitude-Adresse", "Longitude-Adresse" FROM "formation"."adresse_patient") as x) [numPartitions=1]  (10)
+- == Initial Plan ==
   CollectLimit (36)
   +- Project (35)
      +- Window (34)
         +- Sort (33)
            +- Exchange (32)
               +- Project (31)
                  +- SortMergeJoin LeftOuter (30)
                     :- Sort (27)
                     :  +- Exchange (26)
                     :     +- Union (25)
                     :        :- Project (24)
                     :        :  +- Scan csv  (1)
                     :        +- Project (4)
                     :           +- Scan JDBCRelation((SELECT "IPP", "NOM_FAM", "PRENOM", "NOM_NAISSANCE", "NATIONALITE", "SEXE", "CIVILITE", "DATE_NAIS", "FINESS_ETAB", "INSC", "CODE ETAB", "NOM ETAB" FROM "formation"."patient_etab_sta") as x) [numPartitions=1]  (3)
                     +- Sort (29)
                        +- Exchange (28)
                           +- Project (11)
                              +- Scan JDBCRelation((SELECT "IPP", "Code-etablissement", "rue", "code-postal", "commune", "Latitude-Adresse", "Longitude-Adresse" FROM "formation"."adresse_patient") as x) [numPartitions=1]  (10)


(1) Scan csv 
Output [11]: [N°Patient #87044, Nom de Famille#87045, Prénom#87046, Nom de naissance#87047, Nationalité#87048, Sexe#87049, Civilité#87050, Date naissance#87051, INSC#87053, CODE ETABLISSEMENT#87054, LABEL ETABLISSEMENT#87055]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/DEPOT_CONNECTEU_23174/PATIENT_ETAB_VAL-BUT.csv]
ReadSchema: struct<N°Patient :string,Nom de Famille:string,Prénom:string,Nom de naissance:string,Nationalité:string,Sexe:string,Civilité:string,Date naissance:string,INSC:string,CODE ETABLISSEMENT:string,LABEL ETABLISSEMENT:string>

(2) Project [codegen id : 1]
Output [13]: [N°Patient #87044 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, Nom de Famille#87045 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, Prénom#87046 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, Nom de naissance#87047 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, Nationalité#87048 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, Sexe#87049 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, Civilité#87050 AS COL_1856A62C_995E_4541_9113_FCAF59469832#87377, Date naissance#87051 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, Date naissance#87051 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, INSC#87053 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, CODE ETABLISSEMENT#87054 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, LABEL ETABLISSEMENT#87055 AS COL_48938166_DC92_438A_BDE1_798596353709#87382, str_extract(Date naissance#87051, LEFT, 4) AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Input [11]: [N°Patient #87044, Nom de Famille#87045, Prénom#87046, Nom de naissance#87047, Nationalité#87048, Sexe#87049, Civilité#87050, Date naissance#87051, INSC#87053, CODE ETABLISSEMENT#87054, LABEL ETABLISSEMENT#87055]

(3) Scan JDBCRelation((SELECT "IPP", "NOM_FAM", "PRENOM", "NOM_NAISSANCE", "NATIONALITE", "SEXE", "CIVILITE", "DATE_NAIS", "FINESS_ETAB", "INSC", "CODE ETAB", "NOM ETAB" FROM "formation"."patient_etab_sta") as x) [numPartitions=1]  [codegen id : 2]
Output [12]: [IPP#87145, NOM_FAM#87146, PRENOM#87147, NOM_NAISSANCE#87148, NATIONALITE#87149, SEXE#87150, CIVILITE#87151, DATE_NAIS#87152, FINESS_ETAB#87153, INSC#87154, CODE ETAB#87155, NOM ETAB#87156]
ReadSchema: struct<IPP:string,NOM_FAM:string,PRENOM:string,NOM_NAISSANCE:string,NATIONALITE:string,SEXE:string,CIVILITE:string,DATE_NAIS:string,FINESS_ETAB:string,INSC:string,CODE ETAB:string,NOM ETAB:string>

(4) Project [codegen id : 2]
Output [13]: [IPP#87145 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87860, NOM_FAM#87146 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87861, PRENOM#87147 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87862, NOM_NAISSANCE#87148 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87863, NATIONALITE#87149 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87864, SEXE#87150 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87865, CIVILITE#87151 AS COL_1856A62C_995E_4541_9113_FCAF59469832#87866, DATE_NAIS#87152 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87867, FINESS_ETAB#87153 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87868, INSC#87154 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87869, CODE ETAB#87155 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87870, NOM ETAB#87156 AS COL_48938166_DC92_438A_BDE1_798596353709#87871, str_extract(DATE_NAIS#87152, LEFT, 4) AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87872]
Input [12]: [IPP#87145, NOM_FAM#87146, PRENOM#87147, NOM_NAISSANCE#87148, NATIONALITE#87149, SEXE#87150, CIVILITE#87151, DATE_NAIS#87152, FINESS_ETAB#87153, INSC#87154, CODE ETAB#87155, NOM ETAB#87156]

(5) Union

(6) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, 10), ENSURE_REQUIREMENTS, [plan_id=28630]

(7) ShuffleQueryStage
Output [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: 0

(8) AQEShuffleRead
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: coalesced

(9) Sort [codegen id : 4]
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371 ASC NULLS FIRST], false, 0

(10) Scan JDBCRelation((SELECT "IPP", "Code-etablissement", "rue", "code-postal", "commune", "Latitude-Adresse", "Longitude-Adresse" FROM "formation"."adresse_patient") as x) [numPartitions=1]  [codegen id : 3]
Output [6]: [code-postal#86086, commune#86087, IPP#86083, Latitude-Adresse#86088, Longitude-Adresse#86089, rue#86085]
PushedFilters: [*IsNotNull(IPP)]
ReadSchema: struct<code-postal:string,commune:string,IPP:string,Latitude-Adresse:double,Longitude-Adresse:double,rue:string>

(11) Project [codegen id : 3]
Output [6]: [code-postal#86086 AS ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, commune#86087 AS ADRESSE_PATIENT_23201_COMMUNE_23206#87406, IPP#86083 AS ADRESSE_PATIENT_23201_IPP_23202#87407, Latitude-Adresse#86088 AS ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, Longitude-Adresse#86089 AS ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, rue#86085 AS ADRESSE_PATIENT_23201_RUE_23204#87410]
Input [6]: [code-postal#86086, commune#86087, IPP#86083, Latitude-Adresse#86088, Longitude-Adresse#86089, rue#86085]

(12) Exchange
Input [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: hashpartitioning(ADRESSE_PATIENT_23201_IPP_23202#87407, 10), ENSURE_REQUIREMENTS, [plan_id=28642]

(13) ShuffleQueryStage
Output [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: 1

(14) AQEShuffleRead
Input [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: [ADRESSE_PATIENT_23201_IPP_23202#87407 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371]
Right keys [1]: [ADRESSE_PATIENT_23201_IPP_23202#87407]
Join type: LeftOuter
Join condition: None

(17) Project [codegen id : 6]
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, ADRESSE_PATIENT_23201_RUE_23204#87410 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, ADRESSE_PATIENT_23201_COMMUNE_23206#87406 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, str_extract(ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]

(18) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 10), ENSURE_REQUIREMENTS, [plan_id=28808]

(19) ShuffleQueryStage
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: 2

(20) Sort [codegen id : 7]
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(21) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653], [1 DESC NULLS LAST]

(22) Project [codegen id : 8]
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]

(23) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]
Arguments: 1500

(24) Project
Output [13]: [N°Patient #87044 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, Nom de Famille#87045 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, Prénom#87046 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, Nom de naissance#87047 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, Nationalité#87048 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, Sexe#87049 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, Civilité#87050 AS COL_1856A62C_995E_4541_9113_FCAF59469832#87377, Date naissance#87051 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, Date naissance#87051 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, INSC#87053 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, CODE ETABLISSEMENT#87054 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, LABEL ETABLISSEMENT#87055 AS COL_48938166_DC92_438A_BDE1_798596353709#87382, str_extract(Date naissance#87051, LEFT, 4) AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Input [11]: [N°Patient #87044, Nom de Famille#87045, Prénom#87046, Nom de naissance#87047, Nationalité#87048, Sexe#87049, Civilité#87050, Date naissance#87051, INSC#87053, CODE ETABLISSEMENT#87054, LABEL ETABLISSEMENT#87055]

(25) Union

(26) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, 10), ENSURE_REQUIREMENTS, [plan_id=28589]

(27) Sort
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371 ASC NULLS FIRST], false, 0

(28) Exchange
Input [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: hashpartitioning(ADRESSE_PATIENT_23201_IPP_23202#87407, 10), ENSURE_REQUIREMENTS, [plan_id=28590]

(29) Sort
Input [6]: [ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]
Arguments: [ADRESSE_PATIENT_23201_IPP_23202#87407 ASC NULLS FIRST], false, 0

(30) SortMergeJoin
Left keys [1]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371]
Right keys [1]: [ADRESSE_PATIENT_23201_IPP_23202#87407]
Join type: LeftOuter
Join condition: None

(31) Project
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, ADRESSE_PATIENT_23201_RUE_23204#87410 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, ADRESSE_PATIENT_23201_COMMUNE_23206#87406 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, str_extract(ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, ADRESSE_PATIENT_23201_CODE_POSTAL_23205#87405, ADRESSE_PATIENT_23201_COMMUNE_23206#87406, ADRESSE_PATIENT_23201_IPP_23202#87407, ADRESSE_PATIENT_23201_LATITUDE_ADRESS_23207#87408, ADRESSE_PATIENT_23201_LONGITUDE_ADRES_23208#87409, ADRESSE_PATIENT_23201_RUE_23204#87410]

(32) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 10), ENSURE_REQUIREMENTS, [plan_id=28596]

(33) Sort
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(34) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653], [1 DESC NULLS LAST]

(35) Project
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]

(36) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]
Arguments: 1500

(37) AdaptiveSparkPlan
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#87371, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#87372, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#87373, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#87374, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#87375, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#87376, COL_1856A62C_995E_4541_9113_FCAF59469832#87377, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#87378, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#87379, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#87380, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#87381, COL_48938166_DC92_438A_BDE1_798596353709#87382, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#87383, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#87647, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#87648, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#87649, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#87650, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#87651, COL_F7FAE232_C978_4109_9201_2885C404DE4D#87652, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#87698, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#87653, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#87768L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet