SP1 - Details for Query 7004

Submitted Time: 2026/10/27 17:20:47
Duration: 0.8 s
Succeeded Jobs: 10496 10497 10498 10499 10500 10501 10502 10503

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 (14)\n \nduration: 2 ms"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 16.3 MiB number of output rows: 2 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 4 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 208.0 B number of coalesced partitions: 1"]; 5 [labelType="html" label="Exchange shuffle records written: 2 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: 2 local bytes read: 196.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: 120.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: 196.0 B"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 198 ms"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 193 ms peak memory: 256.0 KiB number of output rows: 2 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 21,131"]; 10 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 240 ms"; 12 [labelType="html" label="Sort sort time: 2 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 13 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 345.9 KiB number of coalesced partitions: 1"]; 14 [labelType="html" label="Exchange shuffle records written: 21,131 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: 21,131 local bytes read: 334.2 KiB 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: 1320.3 KiB 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: 334.2 KiB"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 37 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="SortMergeJoin number of output rows: 21,131 spill size: 0.0 B"]; } subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 78 ms"; 19 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 20 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 345.9 KiB number of coalesced partitions: 1"]; 21 [labelType="html" label="Exchange shuffle records written: 21,127 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: 21,127 local bytes read: 334.2 KiB 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: 1320.2 KiB 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: 334.2 KiB"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 59 ms"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="SortMergeJoin number of output rows: 21,127 spill size: 0.0 B"]; } subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 124 ms"; 26 [labelType="html" label="Sort sort time: 28 ms peak memory: 16.5 MiB spill size: 0.0 B"]; } 27 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 449.6 KiB number of coalesced partitions: 1"]; 28 [labelType="html" label="Exchange shuffle records written: 21,121 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 1 ms (stage 20975.0: task 27217)) 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: 21,121 local bytes read: 424.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 1320.1 KiB (41.4 KiB, 639.3 KiB, 639.3 KiB (stage 20975.0: task 27216)) 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)) 424.2 KiB (14.7 KiB, 203.1 KiB, 206.5 KiB (stage 20975.0: task 27216))"]; subgraph cluster29 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n172 ms (11 ms, 77 ms, 84 ms (stage 20975.0: task 27217))"; 30 [labelType="html" label=" Project "]; } 31 [labelType="html" label="Scan csv number of output rows: 21,121 number of files read: 1 metadata time: 0 ms size of files read: 8.3 MiB"]; subgraph cluster32 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 1.4 m"; 33 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 34 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 256.0 KiB number of output rows: 445 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 5.0 KiB number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 445 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: 445 local bytes read: 4.8 KiB 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: 13.9 KiB 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: 4.8 KiB"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 13 ms"; 38 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 10 ms peak memory: 256.0 KiB number of output rows: 445 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 39 [labelType="html" label=" Project "]; } 40 [labelType="html" label="Scan csv number of output rows: 1,216 number of files read: 1 metadata time: 0 ms size of files read: 111.6 KiB"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 76 ms"; 42 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 43 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 256.0 KiB number of output rows: 464 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 44 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 5.2 KiB number of coalesced partitions: 1"]; 45 [labelType="html" label="Exchange shuffle records written: 464 local merged chunks fetched: 0 shuffle write time: 2 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: 464 local bytes read: 5.0 KiB 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: 14.5 KiB 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.0 KiB"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 16 ms"; 47 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 12 ms peak memory: 256.0 KiB number of output rows: 464 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 48 [labelType="html" label=" Project "]; } 49 [labelType="html" label="Scan csv number of output rows: 486 number of files read: 1 metadata time: 0 ms size of files read: 50.8 KiB"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 238 ms"; 51 [labelType="html" label="Sort sort time: 5 ms peak memory: 16.5 MiB spill size: 0.0 B"]; 52 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 10 ms peak memory: 16.3 MiB number of output rows: 21,121 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 53 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 159.0 KiB number of coalesced partitions: 1"]; 54 [labelType="html" label="Exchange shuffle records written: 21,122 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 1 ms, 2 ms (stage 20978.0: task 27223)) 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: 21,122 local bytes read: 150.8 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 660.1 KiB (5.3 KiB, 316.2 KiB, 338.6 KiB (stage 20978.0: task 27222)) 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)) 150.8 KiB (2.3 KiB, 71.5 KiB, 77.0 KiB (stage 20978.0: task 27222))"]; subgraph cluster55 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n298 ms (16 ms, 137 ms, 145 ms (stage 20978.0: task 27222))"; 56 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 274 ms (10 ms, 129 ms, 135 ms (stage 20978.0: task 27222)) peak memory total (min, med, max (stageId: taskId)) 32.8 MiB (256.0 KiB, 16.3 MiB, 16.3 MiB (stage 20978.0: task 27221)) number of output rows: 21,122 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 20978.0: task 27221))"]; 57 [labelType="html" label=" Project "]; 58 [labelType="html" label="Filter number of output rows: 26,044"]; } 59 [labelType="html" label="Scan csv number of output rows: 26,044 number of files read: 1 metadata time: 0 ms size of files read: 8.0 MiB"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 19->17; 20->19; 21->20; 23->21; 24->23; 26->24; 27->26; 28->27; 30->28; 31->30; 33->24; 34->33; 35->34; 36->35; 38->36; 39->38; 40->39; 42->17; 43->42; 44->43; 45->44; 47->45; 48->47; 49->48; 51->10; 52->51; 53->52; 54->53; 56->54; 57->56; 58->57; 59->58; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=10, orderBy=[COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L DESC NULLS LAST], output=[COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292,COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L])

HashAggregate(keys=[COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265], functions=[count(1)])

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, 10), ENSURE_REQUIREMENTS, [plan_id=1031258]

HashAggregate(keys=[COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265], functions=[partial_count(1)])

Project [str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]

Filter isnotnull(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO), ), ))

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642], [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904], LeftOuter

WholeStageCodegen (13)

Sort [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1031131]

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642], [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767], FullOuter

WholeStageCodegen (10)

Sort [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1031011]

Project [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]

SortMergeJoin [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642], [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656], FullOuter

WholeStageCodegen (7)

Sort [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1030696]

Project [NO_ADMIN#1676243 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, str_remove_space(NO_ADMIN#1676243, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]

WholeStageCodegen (1)

FileScan csv [NO_ADMIN#1676243] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.1..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<NO_ADMIN:string>

Sort [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656 ASC NULLS FIRST], false, 0

HashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118], functions=[])

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118, 10), ENSURE_REQUIREMENTS, [plan_id=1030709]

HashAggregate(keys=[COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118], functions=[])

Project [str_remove_space(str_extract_middle(_c0#1678013, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]

WholeStageCodegen (2)

FileScan csv [_c0#1678013] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/DMI_M12_2025_237543/DMI-M12-2025 - BIS...., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Sort [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767 ASC NULLS FIRST], false, 0

HashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928], functions=[])

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928, 10), ENSURE_REQUIREMENTS, [plan_id=1030729]

HashAggregate(keys=[COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928], functions=[])

Project [str_remove_space(str_extract_middle(_c0#1677809, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]

WholeStageCodegen (3)

FileScan csv [_c0#1677809] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/MOLECULES_ONERE_237545/MO-M12-2025.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Sort [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904 ASC NULLS FIRST], false, 0

HashAggregate(keys=[COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127], functions=[])

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127, 10), ENSURE_REQUIREMENTS, [plan_id=1030750]

HashAggregate(keys=[COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127], functions=[])

Project [str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]

Filter isnotnull(str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL))

WholeStageCodegen (4)

FileScan csv [_c0#1675548] Batched: false, DataFilters: [isnotnull(str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL))], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/RSS_M12_2025_237542/RSS- 420780652.txt], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<_c0:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (87)
+- == Final Plan ==
   TakeOrderedAndProject (52)
   +- * HashAggregate (51)
      +- AQEShuffleRead (50)
         +- ShuffleQueryStage (49), Statistics(sizeInBytes=120.0 B, rowCount=2)
            +- Exchange (48)
               +- * HashAggregate (47)
                  +- * Project (46)
                     +- * Filter (45)
                        +- * SortMergeJoin LeftOuter (44)
                           :- * Sort (34)
                           :  +- AQEShuffleRead (33)
                           :     +- ShuffleQueryStage (32), Statistics(sizeInBytes=1320.3 KiB, rowCount=2.11E+4)
                           :        +- Exchange (31)
                           :           +- * Project (30)
                           :              +- * SortMergeJoin FullOuter (29)
                           :                 :- * Sort (20)
                           :                 :  +- AQEShuffleRead (19)
                           :                 :     +- ShuffleQueryStage (18), Statistics(sizeInBytes=1320.2 KiB, rowCount=2.11E+4)
                           :                 :        +- Exchange (17)
                           :                 :           +- * Project (16)
                           :                 :              +- * SortMergeJoin FullOuter (15)
                           :                 :                 :- * Sort (6)
                           :                 :                 :  +- AQEShuffleRead (5)
                           :                 :                 :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=1320.1 KiB, rowCount=2.11E+4)
                           :                 :                 :        +- Exchange (3)
                           :                 :                 :           +- * Project (2)
                           :                 :                 :              +- Scan csv  (1)
                           :                 :                 +- * Sort (14)
                           :                 :                    +- * HashAggregate (13)
                           :                 :                       +- AQEShuffleRead (12)
                           :                 :                          +- ShuffleQueryStage (11), Statistics(sizeInBytes=13.9 KiB, rowCount=445)
                           :                 :                             +- Exchange (10)
                           :                 :                                +- * HashAggregate (9)
                           :                 :                                   +- * Project (8)
                           :                 :                                      +- Scan csv  (7)
                           :                 +- * Sort (28)
                           :                    +- * HashAggregate (27)
                           :                       +- AQEShuffleRead (26)
                           :                          +- ShuffleQueryStage (25), Statistics(sizeInBytes=14.5 KiB, rowCount=464)
                           :                             +- Exchange (24)
                           :                                +- * HashAggregate (23)
                           :                                   +- * Project (22)
                           :                                      +- Scan csv  (21)
                           +- * Sort (43)
                              +- * HashAggregate (42)
                                 +- AQEShuffleRead (41)
                                    +- ShuffleQueryStage (40), Statistics(sizeInBytes=660.1 KiB, rowCount=2.11E+4)
                                       +- Exchange (39)
                                          +- * HashAggregate (38)
                                             +- * Project (37)
                                                +- * Filter (36)
                                                   +- Scan csv  (35)
+- == Initial Plan ==
   TakeOrderedAndProject (86)
   +- HashAggregate (85)
      +- Exchange (84)
         +- HashAggregate (83)
            +- Project (82)
               +- Filter (81)
                  +- SortMergeJoin LeftOuter (80)
                     :- Sort (73)
                     :  +- Exchange (72)
                     :     +- Project (71)
                     :        +- SortMergeJoin FullOuter (70)
                     :           :- Sort (64)
                     :           :  +- Exchange (63)
                     :           :     +- Project (62)
                     :           :        +- SortMergeJoin FullOuter (61)
                     :           :           :- Sort (55)
                     :           :           :  +- Exchange (54)
                     :           :           :     +- Project (53)
                     :           :           :        +- Scan csv  (1)
                     :           :           +- Sort (60)
                     :           :              +- HashAggregate (59)
                     :           :                 +- Exchange (58)
                     :           :                    +- HashAggregate (57)
                     :           :                       +- Project (56)
                     :           :                          +- Scan csv  (7)
                     :           +- Sort (69)
                     :              +- HashAggregate (68)
                     :                 +- Exchange (67)
                     :                    +- HashAggregate (66)
                     :                       +- Project (65)
                     :                          +- Scan csv  (21)
                     +- Sort (79)
                        +- HashAggregate (78)
                           +- Exchange (77)
                              +- HashAggregate (76)
                                 +- Project (75)
                                    +- Filter (74)
                                       +- Scan csv  (35)


(1) Scan csv 
Output [1]: [NO_ADMIN#1676243]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/VISUALVALOSEJOU_237544/420780652.2025.12.MCO.VisualValoSejours.csv]
ReadSchema: struct<NO_ADMIN:string>

(2) Project [codegen id : 1]
Output [2]: [NO_ADMIN#1676243 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, str_remove_space(NO_ADMIN#1676243, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [1]: [NO_ADMIN#1676243]

(3) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1030696]

(4) ShuffleQueryStage
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: 0

(5) AQEShuffleRead
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: coalesced

(6) Sort [codegen id : 5]
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [1]: [_c0#1678013]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/DMI_M12_2025_237543/DMI-M12-2025 - BIS.txt]
ReadSchema: struct<_c0:string>

(8) Project [codegen id : 2]
Output [1]: [str_remove_space(str_extract_middle(_c0#1678013, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Input [1]: [_c0#1678013]

(9) HashAggregate [codegen id : 2]
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]

(10) Exchange
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118, 10), ENSURE_REQUIREMENTS, [plan_id=1030709]

(11) ShuffleQueryStage
Output [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Arguments: 1

(12) AQEShuffleRead
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Arguments: coalesced

(13) HashAggregate [codegen id : 6]
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]

(14) Sort [codegen id : 6]
Input [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656 ASC NULLS FIRST], false, 0

(15) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]
Join type: FullOuter
Join condition: None

(16) Project [codegen id : 7]
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]

(17) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1031011]

(18) ShuffleQueryStage
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: 4

(19) AQEShuffleRead
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: coalesced

(20) Sort [codegen id : 8]
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(21) Scan csv 
Output [1]: [_c0#1677809]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/MOLECULES_ONERE_237545/MO-M12-2025.txt]
ReadSchema: struct<_c0:string>

(22) Project [codegen id : 3]
Output [1]: [str_remove_space(str_extract_middle(_c0#1677809, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Input [1]: [_c0#1677809]

(23) HashAggregate [codegen id : 3]
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]

(24) Exchange
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928, 10), ENSURE_REQUIREMENTS, [plan_id=1030729]

(25) ShuffleQueryStage
Output [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Arguments: 2

(26) AQEShuffleRead
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Arguments: coalesced

(27) HashAggregate [codegen id : 9]
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]

(28) Sort [codegen id : 9]
Input [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767 ASC NULLS FIRST], false, 0

(29) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]
Join type: FullOuter
Join condition: None

(30) Project [codegen id : 10]
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]

(31) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1031131]

(32) ShuffleQueryStage
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: 5

(33) AQEShuffleRead
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: coalesced

(34) Sort [codegen id : 11]
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(35) Scan csv 
Output [1]: [_c0#1675548]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/RSS_M12_2025_237542/RSS- 420780652.txt]
ReadSchema: struct<_c0:string>

(36) Filter [codegen id : 4]
Input [1]: [_c0#1675548]
Condition : isnotnull(str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL))

(37) Project [codegen id : 4]
Output [1]: [str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Input [1]: [_c0#1675548]

(38) HashAggregate [codegen id : 4]
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]

(39) Exchange
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127, 10), ENSURE_REQUIREMENTS, [plan_id=1030750]

(40) ShuffleQueryStage
Output [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Arguments: 3

(41) AQEShuffleRead
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Arguments: coalesced

(42) HashAggregate [codegen id : 12]
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]

(43) Sort [codegen id : 12]
Input [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904 ASC NULLS FIRST], false, 0

(44) SortMergeJoin [codegen id : 13]
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Join type: LeftOuter
Join condition: None

(45) Filter [codegen id : 13]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Condition : isnotnull(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))

(46) Project [codegen id : 13]
Output [1]: [str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]

(47) HashAggregate [codegen id : 13]
Input [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Keys [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1680326L]
Results [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]

(48) Exchange
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Arguments: hashpartitioning(COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, 10), ENSURE_REQUIREMENTS, [plan_id=1031258]

(49) ShuffleQueryStage
Output [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Arguments: 6

(50) AQEShuffleRead
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Arguments: coalesced

(51) HashAggregate [codegen id : 14]
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Keys [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1680317L]
Results [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265 AS COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, count(1)#1680317L AS COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]

(52) TakeOrderedAndProject
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]
Arguments: 10, [COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L DESC NULLS LAST], [COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]

(53) Project
Output [2]: [NO_ADMIN#1676243 AS COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, str_remove_space(NO_ADMIN#1676243, ALL) AS COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [1]: [NO_ADMIN#1676243]

(54) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1030596]

(55) Sort
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(56) Project
Output [1]: [str_remove_space(str_extract_middle(_c0#1678013, 12, 20), ALL) AS COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Input [1]: [_c0#1678013]

(57) HashAggregate
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]

(58) Exchange
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Arguments: hashpartitioning(COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118, 10), ENSURE_REQUIREMENTS, [plan_id=1030592]

(59) HashAggregate
Input [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Keys [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_9D7AAEDE_94EE_40AF_8530_BC9D1F27742A#1678118 AS 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]

(60) Sort
Input [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]
Arguments: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656 ASC NULLS FIRST], false, 0

(61) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]
Join type: FullOuter
Join condition: None

(62) Project
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 01_DMI_DECOUPAG_237714_COL_1D1ABD09_1E00_4FA7_81FE_A558E22F6A6D#1679656]

(63) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1030605]

(64) Sort
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(65) Project
Output [1]: [str_remove_space(str_extract_middle(_c0#1677809, 12, 20), ALL) AS COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Input [1]: [_c0#1677809]

(66) HashAggregate
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]

(67) Exchange
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Arguments: hashpartitioning(COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928, 10), ENSURE_REQUIREMENTS, [plan_id=1030601]

(68) HashAggregate
Input [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Keys [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_45066C9F_40FD_4BE1_ACAF_6139C274CECB#1677928 AS 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]

(69) Sort
Input [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]
Arguments: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767 ASC NULLS FIRST], false, 0

(70) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]
Join type: FullOuter
Join condition: None

(71) Project
Output [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 01_MOLECULES_ON_237708_COL_EE4AB0B4_F37E_40C0_9292_9E68BF166E36#1679767]

(72) Exchange
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: hashpartitioning(COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, 10), ENSURE_REQUIREMENTS, [plan_id=1030614]

(73) Sort
Input [2]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Arguments: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642 ASC NULLS FIRST], false, 0

(74) Filter
Input [1]: [_c0#1675548]
Condition : isnotnull(str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL))

(75) Project
Output [1]: [str_remove_space(str_extract_middle(_c0#1675548, 48, 20), ALL) AS COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Input [1]: [_c0#1675548]

(76) HashAggregate
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]

(77) Exchange
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Arguments: hashpartitioning(COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127, 10), ENSURE_REQUIREMENTS, [plan_id=1030610]

(78) HashAggregate
Input [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Keys [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127]
Functions: []
Aggregate Attributes: []
Results [1]: [COL_0FDBEAA7_683C_4647_A06F_34AC7E6418C2#1676127 AS RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]

(79) Sort
Input [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Arguments: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904 ASC NULLS FIRST], false, 0

(80) SortMergeJoin
Left keys [1]: [COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642]
Right keys [1]: [RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Join type: LeftOuter
Join condition: None

(81) Filter
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]
Condition : isnotnull(str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ))

(82) Project
Output [1]: [str_if_with_rule(isnull(COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115), str_join(array(str_join(array(séjour, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904), :), absent de VisualValoSej et présent dans Fichcomp DMI/MO),  ), ) AS COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Input [3]: [COL_5C76D7BA_A38A_4050_92DD_40D15A692CCA#1679115, COL_7948E047_29EE_472A_BFFC_723098878DAD#1679642, RSS_DECOUPAGE_237747_COL_5588E97C_F5A9_4AFC_AD58_2B0A6381409A#1679904]

(83) HashAggregate
Input [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Keys [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1680326L]
Results [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]

(84) Exchange
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Arguments: hashpartitioning(COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, 10), ENSURE_REQUIREMENTS, [plan_id=1030622]

(85) HashAggregate
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265, count#1680327L]
Keys [1]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265]
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1680317L]
Results [2]: [COL_125A5E52_9A2A_4ABD_A883_7B7334851195#1680265 AS COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, count(1)#1680317L AS COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]

(86) TakeOrderedAndProject
Input [2]: [COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]
Arguments: 10, [COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L DESC NULLS LAST], [COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]

(87) AdaptiveSparkPlan
Output [2]: [COL_125A5E52_9A2A_4ABD_A883_7B73348511951#1680292, COL_125A5E52_9A2A_4ABD_A883_7B73348511952#1680319L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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