EVAL1_SPC1 - Details for Query 156

Submitted Time: 2026/06/03 08:14:05
Duration: 1 s
Succeeded Jobs: 334 335 336 337

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: 5 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)) 144 ms (10 ms, 21 ms, 79 ms (stage 662.0: task 1485)) 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 662.0: task 1482)) 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 662.0: task 1482))"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n2.2 s (434 ms, 453 ms, 465 ms (stage 662.0: task 1481))"; 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 662.0: task 1484))"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.3 s (437 ms, 455 ms, 467 ms (stage 662.0: task 1481))"; 12 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 7 ms (1 ms, 1 ms, 3 ms (stage 662.0: task 1483)) peak memory total (min, med, max (stageId: taskId)) 321.2 MiB (64.2 MiB, 64.2 MiB, 64.2 MiB (stage 662.0: task 1484)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 662.0: task 1484))"]; } 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)) 13 ms (3 ms, 10 ms, 10 ms (stage 658.0: task 1478)) 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 662.0: task 1482)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 662.0: task 1484)) 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 658.0: task 1478)) 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 658.0: task 1478))"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n258 ms (58 ms, 200 ms, 200 ms (stage 658.0: task 1478))"; 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)) 18 ms (8 ms, 10 ms, 10 ms (stage 658.0: task 1478)) 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))\n2.7 s (454 ms, 874 ms, 916 ms (stage 662.0: task 1485))"; 20 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 10 ms (2 ms, 2 ms, 2 ms (stage 662.0: task 1484)) peak memory total (min, med, max (stageId: taskId)) 322.5 MiB (64.5 MiB, 64.5 MiB, 64.5 MiB (stage 662.0: task 1484)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 662.0: task 1484))"]; } 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 662.0: task 1482)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 662.0: task 1484)) 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: 218 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: 24 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#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]

WholeStageCodegen (7)

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

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

WholeStageCodegen (6)

Exchange hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 10), ENSURE_REQUIREMENTS, [plan_id=27232]

Project [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, ADRESSE_PATIENT_4467_RUE_4470#82141 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, ADRESSE_PATIENT_4467_COMMUNE_4472#82137 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]

SortMergeJoin [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102], [ADRESSE_PATIENT_4467_IPP_4468#82138], LeftOuter

WholeStageCodegen (5)

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, 10), ENSURE_REQUIREMENTS, [plan_id=27110]

Project [IDENTIFIANT_DU__4454#81977 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, NOM_USUEL_4455#81983 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, PRENOM_4456#81984 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, NOM_NAISSANCE_4457#81982 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, NATIONALITE_4458#81979 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, SEXE_4459#81985 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, CIVILITE_4460#81974 AS COL_1856A62C_995E_4541_9113_FCAF59469832#82108, NE_E_LE_4461#81980 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, FINESS_ETAB_4462#81976 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, INSC_4463#81978 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, CODE_ETAB_4464#81975 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, NOM_ETAB_4465#81981 AS COL_48938166_DC92_438A_BDE1_798596353709#82113, ANNEE_NAISSANCE_4466#81987 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [CIVILITE_4460#81974,CODE_ETAB_4464#81975,FINESS_ETAB_4462#81976,IDENTIFIANT_DU__4454#81977,INSC_4463#81978,NATIONALITE_4458#81979,NE_E_LE_4461#81980,NOM_ETAB_4465#81981,NOM_NAISSANCE_4457#81982,NOM_USUEL_4455#81983,PRENOM_4456#81984,SEXE_4459#81985,ANNEE_NAISSANCE_4466#81987] 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#82138 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#82138, 10), ENSURE_REQUIREMENTS, [plan_id=27129]

Project [CODE_POSTAL_4471#82005 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, COMMUNE_4472#82006 AS ADRESSE_PATIENT_4467_COMMUNE_4472#82137, IPP_4468#82007 AS ADRESSE_PATIENT_4467_IPP_4468#82138, LATITUDE_ADRESS_4473#82008 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, LONGITUDE_ADRES_4474#82009 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, RUE_4470#82010 AS ADRESSE_PATIENT_4467_RUE_4470#82141]

Filter isnotnull(IPP_4468#82007)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [CODE_POSTAL_4471#82005,COMMUNE_4472#82006,IPP_4468#82007,LATITUDE_ADRESS_4473#82008,LONGITUDE_ADRES_4474#82009,RUE_4470#82010] Batched: true, DataFilters: [isnotnull(IPP_4468#82007)], 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#81974, CODE_ETAB_4464#81975, FINESS_ETAB_4462#81976, IDENTIFIANT_DU__4454#81977, INSC_4463#81978, NATIONALITE_4458#81979, NE_E_LE_4461#81980, NOM_ETAB_4465#81981, NOM_NAISSANCE_4457#81982, NOM_USUEL_4455#81983, PRENOM_4456#81984, SEXE_4459#81985, ANNEE_NAISSANCE_4466#81987]
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#81974, CODE_ETAB_4464#81975, FINESS_ETAB_4462#81976, IDENTIFIANT_DU__4454#81977, INSC_4463#81978, NATIONALITE_4458#81979, NE_E_LE_4461#81980, NOM_ETAB_4465#81981, NOM_NAISSANCE_4457#81982, NOM_USUEL_4455#81983, PRENOM_4456#81984, SEXE_4459#81985, ANNEE_NAISSANCE_4466#81987]

(3) Project [codegen id : 1]
Output [13]: [IDENTIFIANT_DU__4454#81977 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, NOM_USUEL_4455#81983 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, PRENOM_4456#81984 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, NOM_NAISSANCE_4457#81982 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, NATIONALITE_4458#81979 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, SEXE_4459#81985 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, CIVILITE_4460#81974 AS COL_1856A62C_995E_4541_9113_FCAF59469832#82108, NE_E_LE_4461#81980 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, FINESS_ETAB_4462#81976 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, INSC_4463#81978 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, CODE_ETAB_4464#81975 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, NOM_ETAB_4465#81981 AS COL_48938166_DC92_438A_BDE1_798596353709#82113, ANNEE_NAISSANCE_4466#81987 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Input [13]: [CIVILITE_4460#81974, CODE_ETAB_4464#81975, FINESS_ETAB_4462#81976, IDENTIFIANT_DU__4454#81977, INSC_4463#81978, NATIONALITE_4458#81979, NE_E_LE_4461#81980, NOM_ETAB_4465#81981, NOM_NAISSANCE_4457#81982, NOM_USUEL_4455#81983, PRENOM_4456#81984, SEXE_4459#81985, ANNEE_NAISSANCE_4466#81987]

(4) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, 10), ENSURE_REQUIREMENTS, [plan_id=27110]

(5) ShuffleQueryStage
Output [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: 0

(6) AQEShuffleRead
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: coalesced

(7) Sort [codegen id : 3]
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [6]: [CODE_POSTAL_4471#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]
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#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]

(10) Filter [codegen id : 2]
Input [6]: [CODE_POSTAL_4471#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]
Condition : isnotnull(IPP_4468#82007)

(11) Project [codegen id : 2]
Output [6]: [CODE_POSTAL_4471#82005 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, COMMUNE_4472#82006 AS ADRESSE_PATIENT_4467_COMMUNE_4472#82137, IPP_4468#82007 AS ADRESSE_PATIENT_4467_IPP_4468#82138, LATITUDE_ADRESS_4473#82008 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, LONGITUDE_ADRES_4474#82009 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, RUE_4470#82010 AS ADRESSE_PATIENT_4467_RUE_4470#82141]
Input [6]: [CODE_POSTAL_4471#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]

(12) Exchange
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#82138, 10), ENSURE_REQUIREMENTS, [plan_id=27129]

(13) ShuffleQueryStage
Output [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: 1

(14) AQEShuffleRead
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: coalesced

(15) Sort [codegen id : 4]
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: [ADRESSE_PATIENT_4467_IPP_4468#82138 ASC NULLS FIRST], false, 0

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

(17) Project [codegen id : 5]
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, ADRESSE_PATIENT_4467_RUE_4470#82141 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, ADRESSE_PATIENT_4467_COMMUNE_4472#82137 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]

(18) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 10), ENSURE_REQUIREMENTS, [plan_id=27232]

(19) ShuffleQueryStage
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: 2

(20) Sort [codegen id : 6]
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(21) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384], [1 DESC NULLS LAST]

(22) Project [codegen id : 7]
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]

(23) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]
Arguments: 1500

(24) Project
Output [13]: [IDENTIFIANT_DU__4454#81977 AS COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, NOM_USUEL_4455#81983 AS COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, PRENOM_4456#81984 AS COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, NOM_NAISSANCE_4457#81982 AS COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, NATIONALITE_4458#81979 AS COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, SEXE_4459#81985 AS COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, CIVILITE_4460#81974 AS COL_1856A62C_995E_4541_9113_FCAF59469832#82108, NE_E_LE_4461#81980 AS COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, FINESS_ETAB_4462#81976 AS COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, INSC_4463#81978 AS COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, CODE_ETAB_4464#81975 AS COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, NOM_ETAB_4465#81981 AS COL_48938166_DC92_438A_BDE1_798596353709#82113, ANNEE_NAISSANCE_4466#81987 AS COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Input [13]: [CIVILITE_4460#81974, CODE_ETAB_4464#81975, FINESS_ETAB_4462#81976, IDENTIFIANT_DU__4454#81977, INSC_4463#81978, NATIONALITE_4458#81979, NE_E_LE_4461#81980, NOM_ETAB_4465#81981, NOM_NAISSANCE_4457#81982, NOM_USUEL_4455#81983, PRENOM_4456#81984, SEXE_4459#81985, ANNEE_NAISSANCE_4466#81987]

(25) Exchange
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: hashpartitioning(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, 10), ENSURE_REQUIREMENTS, [plan_id=27069]

(26) Sort
Input [13]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114]
Arguments: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102 ASC NULLS FIRST], false, 0

(27) Filter
Input [6]: [CODE_POSTAL_4471#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]
Condition : isnotnull(IPP_4468#82007)

(28) Project
Output [6]: [CODE_POSTAL_4471#82005 AS ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, COMMUNE_4472#82006 AS ADRESSE_PATIENT_4467_COMMUNE_4472#82137, IPP_4468#82007 AS ADRESSE_PATIENT_4467_IPP_4468#82138, LATITUDE_ADRESS_4473#82008 AS ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, LONGITUDE_ADRES_4474#82009 AS ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, RUE_4470#82010 AS ADRESSE_PATIENT_4467_RUE_4470#82141]
Input [6]: [CODE_POSTAL_4471#82005, COMMUNE_4472#82006, IPP_4468#82007, LATITUDE_ADRESS_4473#82008, LONGITUDE_ADRES_4474#82009, RUE_4470#82010]

(29) Exchange
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: hashpartitioning(ADRESSE_PATIENT_4467_IPP_4468#82138, 10), ENSURE_REQUIREMENTS, [plan_id=27070]

(30) Sort
Input [6]: [ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]
Arguments: [ADRESSE_PATIENT_4467_IPP_4468#82138 ASC NULLS FIRST], false, 0

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

(32) Project
Output [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, ADRESSE_PATIENT_4467_RUE_4470#82141 AS COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136 AS COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, ADRESSE_PATIENT_4467_COMMUNE_4472#82137 AS COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139 AS COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140 AS COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, str_extract(ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, LEFT, 2) AS COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, str_encrypt(str_join(array(COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103), -)) AS COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Input [19]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, ADRESSE_PATIENT_4467_CODE_POSTAL_4471#82136, ADRESSE_PATIENT_4467_COMMUNE_4472#82137, ADRESSE_PATIENT_4467_IPP_4468#82138, ADRESSE_PATIENT_4467_LATITUDE_ADRESS_4473#82139, ADRESSE_PATIENT_4467_LONGITUDE_ADRES_4474#82140, ADRESSE_PATIENT_4467_RUE_4470#82141]

(33) Exchange
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: hashpartitioning(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 10), ENSURE_REQUIREMENTS, [plan_id=27076]

(34) Sort
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(35) Window
Input [20]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384]
Arguments: [row_number() windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, count(1) windowspecdefinition(COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L], [COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384], [1 DESC NULLS LAST]

(36) Project
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]

(37) CollectLimit
Input [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]
Arguments: 1500

(38) AdaptiveSparkPlan
Output [22]: [COL_DA837A66_A5E3_4D78_8146_E77811E1D906#82102, COL_A1D52110_06F2_4919_BC41_B4C12C03A4D6#82103, COL_FD35B5D9_22F4_4296_87B4_D3D2AD82C75A#82104, COL_FE9AE82C_82DB_4A84_B792_6D0B9FDCD6F3#82105, COL_038F34E2_6E00_4358_912F_12FA53F2A3DA#82106, COL_6B656202_FD9C_4220_AC7F_53E214FADF1B#82107, COL_1856A62C_995E_4541_9113_FCAF59469832#82108, COL_03D2760C_9C02_4012_93FC_D386830CCE1A#82109, COL_4B83C5E0_479D_4358_A78D_D4686C5C9F79#82110, COL_D6E299BD_E434_48A7_9BB0_CD703734900D#82111, COL_B7FECF84_F58A_47AC_A8CF_5F35088EFA68#82112, COL_48938166_DC92_438A_BDE1_798596353709#82113, COL_C4CA054F_F4FF_4F5E_B755_2351358745E6#82114, COL_0DB0E977_3A15_4B5E_A041_36364CE4A406#82378, COL_A3C1A606_F7FE_4D78_A8FF_8B13297AB002#82379, COL_D8730194_0C1D_4956_ADE5_58992AB0C50F#82380, COL_166C1390_7BC3_4E96_A7DF_22DAD2D148AD#82381, COL_C0DDDD79_E6EB_45DC_8799_7ADCBB1DB038#82382, COL_F7FAE232_C978_4109_9201_2885C404DE4D#82383, COL_1D44A7C3_418B_4BE7_BD38_034B6CD2157B#82429, COL_F342FA2F_B106_418E_AA8E_A195AD9F1DA3#82384, COL_44F364D4_5A36_4D5D_9FEF_B20BC91DD2B5#82499L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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