EVAL1_SPC1 - Details for Query 137

Submitted Time: 2026/06/03 08:02:08
Duration: 1 s
Succeeded Jobs: 306 307 309 310

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 (7)\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 (6)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 6 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)) 148 ms (11 ms, 11 ms, 100 ms (stage 623.0: task 1446)) 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: 1700.1 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 623.0: task 1445)) 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 623.0: task 1445))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n3.3 s (633 ms, 669 ms, 717 ms (stage 623.0: task 1448))"; 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 623.0: task 1447))"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n3.5 s (665 ms, 702 ms, 749 ms (stage 623.0: task 1448))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 1 ms (stage 623.0: task 1447)) peak memory total (min, med, max (stageId: taskId)) 321.2 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 623.0: task 1447)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 623.0: task 1447))"]; } 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 (2 ms, 9 ms, 9 ms (stage 615.0: task 1440)) 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 623.0: task 1445)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 623.0: task 1447)) 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 615.0: task 1440)) 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 615.0: task 1440))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n266 ms (45 ms, 221 ms, 221 ms (stage 615.0: task 1440))"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="ColumnarToRow number of output rows: 51,055 number of input batches: 13"]; } 18 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 21 ms (7 ms, 14 ms, 14 ms (stage 615.0: task 1440)) metadata time: 0 ms size of files read: 4.1 MiB number of output rows: 51,055"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n4.3 s (681 ms, 1.4 s, 1.5 s (stage 623.0: task 1448))"; 20 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 10 ms (1 ms, 2 ms, 4 ms (stage 623.0: task 1447)) peak memory total (min, med, max (stageId: taskId)) 322.5 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 623.0: task 1447)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 623.0: task 1447))"]; } 21 [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"]; 22 [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 623.0: task 1445)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 623.0: task 1447)) 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 cluster23 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 235 ms"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 95,000"]; 26 [labelType="html" label="ColumnarToRow number of output rows: 95,000 number of input batches: 24"]; } 27 [labelType="html" label="Scan parquet number of files read: 1 scan time: 26 ms metadata time: 0 ms size of files read: 3.3 MiB 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; 16->14; 17->16; 18->17; 20->10; 21->20; 22->21; 24->22; 25->24; 26->25; 27->26; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]

WholeStageCodegen (7)

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

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

WholeStageCodegen (6)

Exchange hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 10), ENSURE_REQUIREMENTS, [plan_id=26479]

Project [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, ADRESSE_PATIENT_4467_RUE_4470#79609 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, ADRESSE_PATIENT_4467_COMMUNE_4472#79605 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]

SortMergeJoin [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570], [ADRESSE_PATIENT_4467_IPP_4468#79606], LeftOuter

WholeStageCodegen (5)

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, 10), ENSURE_REQUIREMENTS, [plan_id=26353]

Project [IDENTIFIANT_DU__4454#79445 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, NOM_USUEL_4455#79451 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, PRENOM_4456#79452 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, NOM_NAISSANCE_4457#79450 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, NATIONALITE_4458#79447 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, SEXE_4459#79453 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, CIVILITE_4460#79442 AS COL_1856A62C_995E_4541_9113_FCAF59469832#79576, NE_E_LE_4461#79448 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, FINESS_ETAB_4462#79444 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, INSC_4463#79446 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, CODE_ETAB_4464#79443 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, NOM_ETAB_4465#79449 AS COL_48938166_DC92_438A_BDE1_798596353709#79581, ANNEE_NAISSANCE_4466#79455 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [CIVILITE_4460#79442,CODE_ETAB_4464#79443,FINESS_ETAB_4462#79444,IDENTIFIANT_DU__4454#79445,INSC_4463#79446,NATIONALITE_4458#79447,NE_E_LE_4461#79448,NOM_ETAB_4465#79449,NOM_NAISSANCE_4457#79450,NOM_USUEL_4455#79451,PRENOM_4456#79452,SEXE_4459#79453,ANNEE_NAISSANCE_4466#79455] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/PATRIENT_MULTI__4453], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<CIVILITE_4460:string,CODE_ETAB_4464:string,FINESS_ETAB_4462:string,IDENTIFIANT_DU__4454:st...

Sort [ADRESSE_PATIENT_4467_IPP_4468#79606 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#79606, 10), ENSURE_REQUIREMENTS, [plan_id=26372]

Project [CODE_POSTAL_4471#79473 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, COMMUNE_4472#79474 AS ADRESSE_PATIENT_4467_COMMUNE_4472#79605, IPP_4468#79475 AS ADRESSE_PATIENT_4467_IPP_4468#79606, LATITUDE_ADRESS_4473#79476 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, LONGITUDE_ADRES_4474#79477 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, RUE_4470#79478 AS ADRESSE_PATIENT_4467_RUE_4470#79609]

Filter isnotnull(IPP_4468#79475)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [CODE_POSTAL_4471#79473,COMMUNE_4472#79474,IPP_4468#79475,LATITUDE_ADRESS_4473#79476,LONGITUDE_ADRES_4474#79477,RUE_4470#79478] Batched: true, DataFilters: [isnotnull(IPP_4468#79475)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/ADRESSE_PATIENT_4467], PartitionFilters: [], PushedFilters: [IsNotNull(IPP_4468)], ReadSchema: struct<CODE_POSTAL_4471:string,COMMUNE_4472:string,IPP_4468:string,LATITUDE_ADRESS_4473:double,LO...

Details

== Physical Plan ==
AdaptiveSparkPlan (38)
+- == 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 (7)
                        :  +- AQEShuffleRead (6)
                        :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=11.9 MiB, rowCount=5.11E+4)
                        :        +- Exchange (4)
                        :           +- * Project (3)
                        :              +- * ColumnarToRow (2)
                        :                 +- Scan parquet  (1)
                        +- * Sort (15)
                           +- AQEShuffleRead (14)
                              +- ShuffleQueryStage (13), Statistics(sizeInBytes=10.9 MiB, rowCount=9.50E+4)
                                 +- Exchange (12)
                                    +- * Project (11)
                                       +- * Filter (10)
                                          +- * ColumnarToRow (9)
                                             +- Scan parquet  (8)
+- == Initial Plan ==
   CollectLimit (37)
   +- Project (36)
      +- Window (35)
         +- Sort (34)
            +- Exchange (33)
               +- Project (32)
                  +- SortMergeJoin LeftOuter (31)
                     :- Sort (26)
                     :  +- Exchange (25)
                     :     +- Project (24)
                     :        +- Scan parquet  (1)
                     +- Sort (30)
                        +- Exchange (29)
                           +- Project (28)
                              +- Filter (27)
                                 +- Scan parquet  (8)


(1) Scan parquet 
Output [13]: [CIVILITE_4460#79442, CODE_ETAB_4464#79443, FINESS_ETAB_4462#79444, IDENTIFIANT_DU__4454#79445, INSC_4463#79446, NATIONALITE_4458#79447, NE_E_LE_4461#79448, NOM_ETAB_4465#79449, NOM_NAISSANCE_4457#79450, NOM_USUEL_4455#79451, PRENOM_4456#79452, SEXE_4459#79453, ANNEE_NAISSANCE_4466#79455]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/PATRIENT_MULTI__4453]
ReadSchema: struct<CIVILITE_4460:string,CODE_ETAB_4464:string,FINESS_ETAB_4462:string,IDENTIFIANT_DU__4454:string,INSC_4463:string,NATIONALITE_4458:string,NE_E_LE_4461:string,NOM_ETAB_4465:string,NOM_NAISSANCE_4457:string,NOM_USUEL_4455:string,PRENOM_4456:string,SEXE_4459:string,ANNEE_NAISSANCE_4466:string>

(2) ColumnarToRow [codegen id : 1]
Input [13]: [CIVILITE_4460#79442, CODE_ETAB_4464#79443, FINESS_ETAB_4462#79444, IDENTIFIANT_DU__4454#79445, INSC_4463#79446, NATIONALITE_4458#79447, NE_E_LE_4461#79448, NOM_ETAB_4465#79449, NOM_NAISSANCE_4457#79450, NOM_USUEL_4455#79451, PRENOM_4456#79452, SEXE_4459#79453, ANNEE_NAISSANCE_4466#79455]

(3) Project [codegen id : 1]
Output [13]: [IDENTIFIANT_DU__4454#79445 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, NOM_USUEL_4455#79451 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, PRENOM_4456#79452 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, NOM_NAISSANCE_4457#79450 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, NATIONALITE_4458#79447 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, SEXE_4459#79453 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, CIVILITE_4460#79442 AS COL_1856A62C_995E_4541_9113_FCAF59469832#79576, NE_E_LE_4461#79448 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, FINESS_ETAB_4462#79444 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, INSC_4463#79446 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, CODE_ETAB_4464#79443 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, NOM_ETAB_4465#79449 AS COL_48938166_DC92_438A_BDE1_798596353709#79581, ANNEE_NAISSANCE_4466#79455 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Input [13]: [CIVILITE_4460#79442, CODE_ETAB_4464#79443, FINESS_ETAB_4462#79444, IDENTIFIANT_DU__4454#79445, INSC_4463#79446, NATIONALITE_4458#79447, NE_E_LE_4461#79448, NOM_ETAB_4465#79449, NOM_NAISSANCE_4457#79450, NOM_USUEL_4455#79451, PRENOM_4456#79452, SEXE_4459#79453, ANNEE_NAISSANCE_4466#79455]

(4) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, 10), ENSURE_REQUIREMENTS, [plan_id=26353]

(5) ShuffleQueryStage
Output [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: 0

(6) AQEShuffleRead
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: coalesced

(7) Sort [codegen id : 3]
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/ADRESSE_PATIENT_4467]
PushedFilters: [IsNotNull(IPP_4468)]
ReadSchema: struct<CODE_POSTAL_4471:string,COMMUNE_4472:string,IPP_4468:string,LATITUDE_ADRESS_4473:double,LONGITUDE_ADRES_4474:double,RUE_4470:string>

(9) ColumnarToRow [codegen id : 2]
Input [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]

(10) Filter [codegen id : 2]
Input [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]
Condition : isnotnull(IPP_4468#79475)

(11) Project [codegen id : 2]
Output [6]: [CODE_POSTAL_4471#79473 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, COMMUNE_4472#79474 AS ADRESSE_PATIENT_4467_COMMUNE_4472#79605, IPP_4468#79475 AS ADRESSE_PATIENT_4467_IPP_4468#79606, LATITUDE_ADRESS_4473#79476 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, LONGITUDE_ADRES_4474#79477 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, RUE_4470#79478 AS ADRESSE_PATIENT_4467_RUE_4470#79609]
Input [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]

(12) Exchange
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#79606, 10), ENSURE_REQUIREMENTS, [plan_id=26372]

(13) ShuffleQueryStage
Output [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: 1

(14) AQEShuffleRead
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: coalesced

(15) Sort [codegen id : 4]
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: [ADRESSE_PATIENT_4467_IPP_4468#79606 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 5]
Left keys [1]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570]
Right keys [1]: [ADRESSE_PATIENT_4467_IPP_4468#79606]
Join type: LeftOuter
Join condition: None

(17) Project [codegen id : 5]
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, ADRESSE_PATIENT_4467_RUE_4470#79609 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, ADRESSE_PATIENT_4467_COMMUNE_4472#79605 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]

(18) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 10), ENSURE_REQUIREMENTS, [plan_id=26479]

(19) ShuffleQueryStage
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: 2

(20) Sort [codegen id : 6]
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(21) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852], [1 DESC NULLS LAST]

(22) Project [codegen id : 7]
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]

(23) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]
Arguments: 1500

(24) Project
Output [13]: [IDENTIFIANT_DU__4454#79445 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, NOM_USUEL_4455#79451 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, PRENOM_4456#79452 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, NOM_NAISSANCE_4457#79450 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, NATIONALITE_4458#79447 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, SEXE_4459#79453 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, CIVILITE_4460#79442 AS COL_1856A62C_995E_4541_9113_FCAF59469832#79576, NE_E_LE_4461#79448 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, FINESS_ETAB_4462#79444 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, INSC_4463#79446 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, CODE_ETAB_4464#79443 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, NOM_ETAB_4465#79449 AS COL_48938166_DC92_438A_BDE1_798596353709#79581, ANNEE_NAISSANCE_4466#79455 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Input [13]: [CIVILITE_4460#79442, CODE_ETAB_4464#79443, FINESS_ETAB_4462#79444, IDENTIFIANT_DU__4454#79445, INSC_4463#79446, NATIONALITE_4458#79447, NE_E_LE_4461#79448, NOM_ETAB_4465#79449, NOM_NAISSANCE_4457#79450, NOM_USUEL_4455#79451, PRENOM_4456#79452, SEXE_4459#79453, ANNEE_NAISSANCE_4466#79455]

(25) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, 10), ENSURE_REQUIREMENTS, [plan_id=26312]

(26) Sort
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570 ASC NULLS FIRST], false, 0

(27) Filter
Input [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]
Condition : isnotnull(IPP_4468#79475)

(28) Project
Output [6]: [CODE_POSTAL_4471#79473 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, COMMUNE_4472#79474 AS ADRESSE_PATIENT_4467_COMMUNE_4472#79605, IPP_4468#79475 AS ADRESSE_PATIENT_4467_IPP_4468#79606, LATITUDE_ADRESS_4473#79476 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, LONGITUDE_ADRES_4474#79477 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, RUE_4470#79478 AS ADRESSE_PATIENT_4467_RUE_4470#79609]
Input [6]: [CODE_POSTAL_4471#79473, COMMUNE_4472#79474, IPP_4468#79475, LATITUDE_ADRESS_4473#79476, LONGITUDE_ADRES_4474#79477, RUE_4470#79478]

(29) Exchange
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#79606, 10), ENSURE_REQUIREMENTS, [plan_id=26313]

(30) Sort
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]
Arguments: [ADRESSE_PATIENT_4467_IPP_4468#79606 ASC NULLS FIRST], false, 0

(31) SortMergeJoin
Left keys [1]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570]
Right keys [1]: [ADRESSE_PATIENT_4467_IPP_4468#79606]
Join type: LeftOuter
Join condition: None

(32) Project
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, ADRESSE_PATIENT_4467_RUE_4470#79609 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, ADRESSE_PATIENT_4467_COMMUNE_4472#79605 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#79604, ADRESSE_PATIENT_4467_COMMUNE_4472#79605, ADRESSE_PATIENT_4467_IPP_4468#79606, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#79607, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#79608, ADRESSE_PATIENT_4467_RUE_4470#79609]

(33) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 10), ENSURE_REQUIREMENTS, [plan_id=26319]

(34) Sort
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(35) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852], [1 DESC NULLS LAST]

(36) Project
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]

(37) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]
Arguments: 1500

(38) AdaptiveSparkPlan
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#79570, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#79571, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#79572, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#79573, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#79574, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#79575, COL_1856A62C_995E_4541_9113_FCAF59469832#79576, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#79577, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#79578, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#79579, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#79580, COL_48938166_DC92_438A_BDE1_798596353709#79581, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#79582, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#79846, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#79847, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#79848, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#79849, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#79850, COL_F7FAE232_C978_4109_9201_2885C404DE4D#79851, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#79897, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#79852, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#79967L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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