SP1 - Details for Query 17539

Submitted Time: 2026/06/10 15:49:20
Duration: 0.4 s
Succeeded Jobs: 23845 23846 23847 23848 23849

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n6 ms (2 ms, 4 ms, 4 ms (stage 44945.0: task 64241))"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label=" Union "]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 4 ms"; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Generate number of output rows: 3"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 1"]; } 10 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 40 ms"; 12 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 142.0 B number of coalesced partitions: 1"]; 14 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 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: 1 local bytes read: 131.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 96.0 B 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: 131.0 B"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 93 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Filter number of output rows: 1"]; } 18 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 3.5 MiB"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 16 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 808.0 B number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 7 local merged chunks fetched: 0 shuffle write time: 1 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: 7 local bytes read: 787.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 504.0 B local merged bytes read: 0.0 B number of partitions: 7 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 787.0 B"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n14 ms (3 ms, 11 ms, 11 ms (stage 44939.0: task 64239))"; 24 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 44939.0: task 64239)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 44939.0: task 64239)) number of output rows: 14 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 25 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 741.0 B number of coalesced partitions: 1"]; 26 [labelType="html" label="Exchange shuffle records written: 7 local merged chunks fetched: 0 shuffle write time: 0 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: 14 local bytes read total (min, med, max (stageId: taskId)) 1444.0 B (722.0 B, 722.0 B, 722.0 B (stage 44939.0: task 64239)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 44939.0: task 64239)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 504.0 B 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: 722.0 B"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n79 ms (4 ms, 8 ms, 14 ms (stage 44937.0: task 64231))"; 28 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 44 ms (2 ms, 4 ms, 7 ms (stage 44937.0: task 64231)) peak memory total (min, med, max (stageId: taskId)) 2.5 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 44937.0: task 64233)) number of output rows: 7 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 29 [labelType="html" label=" Project "]; 30 [labelType="html" label="Generate number of output rows: 147"]; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="Filter number of output rows: 21"]; 33 [labelType="html" label="ColumnarToRow number of output rows: 14,679 number of input batches: 4"]; } 34 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 41 ms (2 ms, 4 ms, 7 ms (stage 44937.0: task 64231)) metadata time: 0 ms size of files read: 23.0 MiB number of output rows: 14,679"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 18->17; 20->4; 21->20; 22->21; 24->22; 25->24; 26->25; 28->26; 29->28; 30->29; 31->30; 32->31; 33->32; 34->33; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433 ASC NULLS FIRST,COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434 ASC NULLS FIRST], output=[COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433,COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434,COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435])

Project [COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403 AS COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404 AS COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405 AS COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]

WholeStageCodegen (7)

Union

Project [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363 AS COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403, col0#3881372 AS COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404, col1#3881373 AS COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405]

Generate stack(3, 01-UF, COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, 02-Transport, COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, 03-CCMU, COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366), [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363], false, [col0#3881372, col1#3881373]

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 AS COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856 AS COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857 AS COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858 AS COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877 <=> 1)

WholeStageCodegen (5)

Window [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855], [1 DESC NULLS LAST]

Sort [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 10), ENSURE_REQUIREMENTS, [plan_id=1822095]

Project [Numéro Séjour#3880742 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, UF#3880743 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, str_remove_space(Transport admission#3880747, ONLY_ONE) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#3880744, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]

Filter (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#3880742, #)) THEN false ELSE StartsWith(Numéro Séjour#3880742, #) END AND (Numéro Séjour#3880742 <=> 243267453))

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#3880742,UF#3880743,Niveau CCMU#3880744,Transport admission#3880747] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#3880742, #)) THEN false ELSE StartsWith(Numéro Séj..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_212789/passage_Patient_..., PartitionFilters: [], PushedFilters: [EqualNullSafe(Numéro Séjour,243267453)], ReadSchema: struct<Numéro Séjour:string,UF:string,Niveau CCMU:string,Transport admission:string>

Sort [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST], true, 0

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange rangepartitioning(COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=1822216]

HashAggregate(keys=[COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299], functions=[])

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299, 10), ENSURE_REQUIREMENTS, [plan_id=1822143]

HashAggregate(keys=[COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299], functions=[])

Project [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258 AS COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, col0#3881275 AS COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, col1#3881276 AS COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]

Generate stack(7, 04-Date Naissance, COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, 05-Date Entree, COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, 06-Date Sortie, COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, 07-Fides, COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, 08-Facturable AM, COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, 09-Justif Exo, COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, 10-Nature Ass, COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265), [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258], false, [col0#3881275, col1#3881276]

Project [COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 AS COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939 AS COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941 AS COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942 AS COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937 AS COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938 AS COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, COL_4473F770_A575_4100_97F6_8190F900749A#3880946 AS COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947 AS COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265]

Filter (COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 <=> 243267453)

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938,COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939,COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940,COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941,COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942,COL_4473F770_A575_4100_97F6_8190F900749A#3880946,COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947] Batched: true, DataFilters: [(COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 <=> 243267453)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_212978], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,243267453)], ReadSchema: struct<COL_0521CAB9_7617_4F31_948E_95DCA16387D7:string,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (52)
+- == Final Plan ==
   TakeOrderedAndProject (30)
   +- * Project (29)
      +- Union (28)
         :- * Project (12)
         :  +- * Generate (11)
         :     +- * Project (10)
         :        +- * Filter (9)
         :           +- Window (8)
         :              +- * Sort (7)
         :                 +- AQEShuffleRead (6)
         :                    +- ShuffleQueryStage (5), Statistics(sizeInBytes=96.0 B, rowCount=1)
         :                       +- Exchange (4)
         :                          +- * Project (3)
         :                             +- * Filter (2)
         :                                +- Scan csv  (1)
         +- * Sort (27)
            +- AQEShuffleRead (26)
               +- ShuffleQueryStage (25), Statistics(sizeInBytes=504.0 B, rowCount=7)
                  +- Exchange (24)
                     +- * HashAggregate (23)
                        +- AQEShuffleRead (22)
                           +- ShuffleQueryStage (21), Statistics(sizeInBytes=504.0 B, rowCount=7)
                              +- Exchange (20)
                                 +- * HashAggregate (19)
                                    +- * Project (18)
                                       +- * Generate (17)
                                          +- * Project (16)
                                             +- * Filter (15)
                                                +- * ColumnarToRow (14)
                                                   +- Scan parquet  (13)
+- == Initial Plan ==
   TakeOrderedAndProject (51)
   +- Project (50)
      +- Union (49)
         :- Project (39)
         :  +- Generate (38)
         :     +- Project (37)
         :        +- Filter (36)
         :           +- Window (35)
         :              +- Sort (34)
         :                 +- Exchange (33)
         :                    +- Project (32)
         :                       +- Filter (31)
         :                          +- Scan csv  (1)
         +- Sort (48)
            +- Exchange (47)
               +- HashAggregate (46)
                  +- Exchange (45)
                     +- HashAggregate (44)
                        +- Project (43)
                           +- Generate (42)
                              +- Project (41)
                                 +- Filter (40)
                                    +- Scan parquet  (13)


(1) Scan csv 
Output [4]: [Numéro Séjour#3880742, UF#3880743, Niveau CCMU#3880744, Transport admission#3880747]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_212789/passage_Patient_Colmar_M12025.csv]
PushedFilters: [EqualNullSafe(Numéro Séjour,243267453)]
ReadSchema: struct<Numéro Séjour:string,UF:string,Niveau CCMU:string,Transport admission:string>

(2) Filter [codegen id : 1]
Input [4]: [Numéro Séjour#3880742, UF#3880743, Niveau CCMU#3880744, Transport admission#3880747]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#3880742, #)) THEN false ELSE StartsWith(Numéro Séjour#3880742, #) END AND (Numéro Séjour#3880742 <=> 243267453))

(3) Project [codegen id : 1]
Output [4]: [Numéro Séjour#3880742 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, UF#3880743 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, str_remove_space(Transport admission#3880747, ONLY_ONE) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#3880744, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Input [4]: [Numéro Séjour#3880742, UF#3880743, Niveau CCMU#3880744, Transport admission#3880747]

(4) Exchange
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 10), ENSURE_REQUIREMENTS, [plan_id=1822095]

(5) ShuffleQueryStage
Output [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: 0

(6) AQEShuffleRead
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855], [1 DESC NULLS LAST]

(9) Filter [codegen id : 5]
Input [5]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877 <=> 1)

(10) Project [codegen id : 5]
Output [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 AS COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856 AS COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857 AS COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858 AS COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366]
Input [5]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877]

(11) Generate [codegen id : 5]
Input [4]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366]
Arguments: stack(3, 01-UF, COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, 02-Transport, COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, 03-CCMU, COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366), [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363], false, [col0#3881372, col1#3881373]

(12) Project [codegen id : 5]
Output [3]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363 AS COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403, col0#3881372 AS COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404, col1#3881373 AS COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405]
Input [3]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, col0#3881372, col1#3881373]

(13) Scan parquet 
Output [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_212978]
PushedFilters: [EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,243267453)]
ReadSchema: struct<COL_0521CAB9_7617_4F31_948E_95DCA16387D7:string,COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7:string,COL_9262BBED_C393_416D_B38C_8F1458965BA7:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_96E2282E_0771_460E_8BDB_D11261BD9020:string,COL_12028397_66B1_4E3C_BBDB_64537606E7DE:string,COL_4473F770_A575_4100_97F6_8190F900749A:string,COL_715B3479_EAD2_422C_BF5C_7B020197D946:string>

(14) ColumnarToRow [codegen id : 2]
Input [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]

(15) Filter [codegen id : 2]
Input [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]
Condition : (COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 <=> 243267453)

(16) Project [codegen id : 2]
Output [8]: [COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 AS COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939 AS COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941 AS COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942 AS COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937 AS COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938 AS COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, COL_4473F770_A575_4100_97F6_8190F900749A#3880946 AS COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947 AS COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265]
Input [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]

(17) Generate [codegen id : 2]
Input [8]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265]
Arguments: stack(7, 04-Date Naissance, COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, 05-Date Entree, COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, 06-Date Sortie, COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, 07-Fides, COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, 08-Facturable AM, COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, 09-Justif Exo, COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, 10-Nature Ass, COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265), [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258], false, [col0#3881275, col1#3881276]

(18) Project [codegen id : 2]
Output [3]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258 AS COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, col0#3881275 AS COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, col1#3881276 AS COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Input [3]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, col0#3881275, col1#3881276]

(19) HashAggregate [codegen id : 2]
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Keys [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]

(20) Exchange
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Arguments: hashpartitioning(COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299, 10), ENSURE_REQUIREMENTS, [plan_id=1822143]

(21) ShuffleQueryStage
Output [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Arguments: 1

(22) AQEShuffleRead
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Arguments: coalesced

(23) HashAggregate [codegen id : 3]
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Keys [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297 AS COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298 AS COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299 AS COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]

(24) Exchange
Input [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: rangepartitioning(COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=1822216]

(25) ShuffleQueryStage
Output [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: 2

(26) AQEShuffleRead
Input [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: coalesced

(27) Sort [codegen id : 6]
Input [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST], true, 0

(28) Union

(29) Project [codegen id : 7]
Output [3]: [COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403 AS COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404 AS COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405 AS COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]
Input [3]: [COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403, COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404, COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405]

(30) TakeOrderedAndProject
Input [3]: [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]
Arguments: 500000, [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433 ASC NULLS FIRST, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434 ASC NULLS FIRST], [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]

(31) Filter
Input [4]: [Numéro Séjour#3880742, UF#3880743, Niveau CCMU#3880744, Transport admission#3880747]
Condition : (NOT CASE WHEN isnull(StartsWith(Numéro Séjour#3880742, #)) THEN false ELSE StartsWith(Numéro Séjour#3880742, #) END AND (Numéro Séjour#3880742 <=> 243267453))

(32) Project
Output [4]: [Numéro Séjour#3880742 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, UF#3880743 AS COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, str_remove_space(Transport admission#3880747, ONLY_ONE) AS COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, str_remove_space(str_list_get(str_extract_by_regex(Niveau CCMU#3880744, [+\d]+), 0), ALL) AS COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Input [4]: [Numéro Séjour#3880742, UF#3880743, Niveau CCMU#3880744, Transport admission#3880747]

(33) Exchange
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 10), ENSURE_REQUIREMENTS, [plan_id=1822069]

(34) Sort
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(35) Window
Input [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855], [1 DESC NULLS LAST]

(36) Filter
Input [5]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877 <=> 1)

(37) Project
Output [4]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855 AS COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856 AS COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857 AS COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858 AS COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366]
Input [5]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#3880855, COL_E82CFB57_01EB_4E90_836D_4D6F4CA131FE#3880856, COL_E1010A22_775B_43B4_B8CA_4603C0801D28#3880857, COL_6A6D32F5_2B4E_4DF6_A459_B248882F909D#3880858, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#3880877]

(38) Generate
Input [4]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366]
Arguments: stack(3, 01-UF, COL_48FD2AAE_6F4D_4D43_BEE7_8A161203783C#3881364, 02-Transport, COL_E0699193_FC70_4F64_BAE6_B2F241857F3B#3881365, 03-CCMU, COL_630C2F1A_DB89_4A08_A2D2_179A10CC9FD2#3881366), [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363], false, [col0#3881372, col1#3881373]

(39) Project
Output [3]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363 AS COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403, col0#3881372 AS COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404, col1#3881373 AS COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405]
Input [3]: [COL_DEB05435_3A84_4F8F_8CD2_6BE209A14FA8#3881363, col0#3881372, col1#3881373]

(40) Filter
Input [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]
Condition : (COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 <=> 243267453)

(41) Project
Output [8]: [COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940 AS COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939 AS COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941 AS COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942 AS COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937 AS COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938 AS COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, COL_4473F770_A575_4100_97F6_8190F900749A#3880946 AS COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947 AS COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265]
Input [8]: [COL_0521CAB9_7617_4F31_948E_95DCA16387D7#3880937, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#3880938, COL_9262BBED_C393_416D_B38C_8F1458965BA7#3880939, COL_F76265AB_8748_4114_92B4_00E37DE25D34#3880940, COL_96E2282E_0771_460E_8BDB_D11261BD9020#3880941, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#3880942, COL_4473F770_A575_4100_97F6_8190F900749A#3880946, COL_715B3479_EAD2_422C_BF5C_7B020197D946#3880947]

(42) Generate
Input [8]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265]
Arguments: stack(7, 04-Date Naissance, COL_95E23023_63AA_4AB8_A60F_50D45234CFDD#3881259, 05-Date Entree, COL_78B23D10_75E8_415E_A3C0_8AB5C826A837#3881260, 06-Date Sortie, COL_885784F8_1772_40E3_89B6_6ACE1FAB6407#3881261, 07-Fides, COL_32AA235F_1BB1_4047_B8BA_AD2E9197AD1F#3881262, 08-Facturable AM, COL_3BBA8558_C3D5_4921_93AE_D7C9E273B39D#3881263, 09-Justif Exo, COL_35788C71_38EE_4A08_B685_AAC68457246A#3881264, 10-Nature Ass, COL_6EC95BD9_A121_4728_BE4A_49B7EA2976F2#3881265), [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258], false, [col0#3881275, col1#3881276]

(43) Project
Output [3]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258 AS COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, col0#3881275 AS COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, col1#3881276 AS COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Input [3]: [COL_BC7CB40E_B2CA_42C4_94A5_B6AA996E14DC#3881258, col0#3881275, col1#3881276]

(44) HashAggregate
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Keys [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]

(45) Exchange
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Arguments: hashpartitioning(COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299, 10), ENSURE_REQUIREMENTS, [plan_id=1822076]

(46) HashAggregate
Input [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Keys [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_8D7490B1_ED4B_4A07_9680_ECC66DF49E37#3881297 AS COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_7F6B8B23_E564_4B4E_8794_0FC7CE59D60B#3881298 AS COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_B6440F86_8BD4_4AFD_8640_45556688ABB9#3881299 AS COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]

(47) Exchange
Input [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: rangepartitioning(COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST, 10), ENSURE_REQUIREMENTS, [plan_id=1822079]

(48) Sort
Input [3]: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304, COL_3744BFD9_1F3B_4691_AA97_1C8D69F364B8#3881305]
Arguments: [COL_DC1A3ABF_ADFC_4208_8B24_35ED54CC87DF#3881303 ASC NULLS FIRST, COL_EA9AE57C_DE84_4BBE_9131_053814B337F4#3881304 ASC NULLS FIRST], true, 0

(49) Union

(50) Project
Output [3]: [COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403 AS COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404 AS COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405 AS COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]
Input [3]: [COL_E5ADB260_1BF6_449C_8439_0A94CEE6956C#3881403, COL_59774853_4110_4672_B6E2_C0D5DE930914#3881404, COL_E58DD17C_E55F_4036_9FA9_A5365B045A1A#3881405]

(51) TakeOrderedAndProject
Input [3]: [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]
Arguments: 500000, [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433 ASC NULLS FIRST, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434 ASC NULLS FIRST], [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]

(52) AdaptiveSparkPlan
Output [3]: [COL_DFDE51D5_CDE5_445D_AA51_D91EED80C67A#3881433, COL_69A47656_C694_4DC8_B168_E7B2B018331D#3881434, COL_304BAD49_CD1A_47FE_BEA1_EF22F989615D#3881435]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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