SP1 - Details for Query 2567

Submitted Time: 2026/06/11 10:29:21
Duration: 2 s
Succeeded Jobs: 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 3882 3883 3893 3895

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (35)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [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: 59.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: 16.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (34)\n \nduration: 3 ms"; 5 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 3 ms peak memory: 0.0 B number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (32)\n \nduration: 28 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (30)\n \nduration: 52 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: 194.0 B number of coalesced partitions: 1"]; 14 [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: 7 local bytes read: 190.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: 232.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: 190.0 B"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (29)\n \nduration: 9 ms"; 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (27)\n \nduration: 33 ms"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (25)\n \nduration: 53 ms"; 22 [labelType="html" label=" Project "]; 23 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (23)\n \nduration: 77 ms"; 25 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 26 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 388.0 B number of coalesced partitions: 1"]; 27 [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: 7 local bytes read: 376.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: 344.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: 376.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (22)\n \nduration: 3 ms"; 29 [labelType="html" label=" Project "]; 30 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (20)\n \nduration: 25 ms"; 32 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 33 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 228.0 B number of coalesced partitions: 1"]; 34 [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: 7 local bytes read: 208.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: 512.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: 208.0 B"]; 35 [labelType="html" label="CartesianProduct number of output rows: 7"]; subgraph cluster36 { isCluster="true"; label="WholeStageCodegen (18)\n \nduration: 9 ms"; 37 [labelType="html" label=" Project "]; 38 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster39 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 47 ms"; 40 [labelType="html" label=" Project "]; } 41 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster42 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 80 ms"; 43 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; 44 [labelType="html" label=" Project "]; 45 [labelType="html" label=" Project "]; 46 [labelType="html" label="SortMergeJoin number of output rows: 7 spill size: 0.0 B"]; } subgraph cluster47 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 71 ms"; 48 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 49 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 501.0 B number of coalesced partitions: 1"]; 50 [labelType="html" label="Exchange shuffle records written: 7 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 2 ms (0 ms, 0 ms, 0 ms (stage 8152.0: task 8836)) 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: 479.0 B 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)) 736.0 B (112.0 B, 208.0 B, 416.0 B (stage 8152.0: task 8836)) 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)) 479.0 B (152.0 B, 153.0 B, 174.0 B (stage 8152.0: task 8841))"]; subgraph cluster51 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.7 s (57 ms, 176 ms, 212 ms (stage 8152.0: task 8837))"; 52 [labelType="html" label=" Project "]; 53 [labelType="html" label="Filter number of output rows: 7"]; } 54 [labelType="html" label="Scan csv number of output rows: 7 number of files read: 1 metadata time: 0 ms size of files read: 36.3 MiB"]; subgraph cluster55 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 32 ms"; 56 [labelType="html" label=" Project "]; 57 [labelType="html" label="Filter number of output rows: 1"]; } 58 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster59 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 51 ms"; 60 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 61 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 88.0 B number of coalesced partitions: 1"]; 62 [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: 86.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: 48.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: 86.0 B"]; subgraph cluster63 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 5 ms"; 64 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 0 ms peak memory: 256.0 KiB number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 65 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 117.0 B number of coalesced partitions: 1"]; 66 [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: 112.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: 80.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: 112.0 B"]; subgraph cluster67 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n190 ms (5 ms, 6 ms, 49 ms (stage 8153.0: task 8845))"; 68 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 54 ms (3 ms, 4 ms, 11 ms (stage 8153.0: task 8850)) peak memory total (min, med, max (stageId: taskId)) 2.5 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 8153.0: task 8846)) number of output rows: 1 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 69 [labelType="html" label=" Project "]; 70 [labelType="html" label="Filter number of output rows: 12"]; 71 [labelType="html" label="ColumnarToRow number of output rows: 20,000 number of input batches: 5"]; } 72 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 51 ms (3 ms, 4 ms, 10 ms (stage 8153.0: task 8845)) metadata time: 0 ms size of files read: 30.5 MiB number of output rows: 20,000"]; subgraph cluster73 { isCluster="true"; label="WholeStageCodegen (17)\n \nduration: 22 ms"; 74 [labelType="html" label=" Project "]; 75 [labelType="html" label="Filter number of output rows: 1"]; } 76 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster77 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 34 ms"; 78 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 79 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 80.0 B number of coalesced partitions: 1"]; 80 [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: 76.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: 32.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: 76.0 B"]; subgraph cluster81 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n172 ms (66 ms, 106 ms, 106 ms (stage 8154.0: task 8848))"; 82 [labelType="html" label=" Project "]; 83 [labelType="html" label="Filter number of output rows: 1"]; } 84 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 7.2 MiB"]; subgraph cluster85 { isCluster="true"; label="WholeStageCodegen (19)\n \nduration: 2 ms"; 86 [labelType="html" label="ColumnarToRow number of output rows: 1 number of input batches: 1"]; } 87 [labelType="html" label="Scan parquet number of files read: 1 scan time: 1 ms metadata time: 0 ms size of files read: 2044.0 B number of output rows: 1"]; subgraph cluster88 { isCluster="true"; label="WholeStageCodegen (21)\n \nduration: 0 ms"; 89 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 90 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1292.0 B number of coalesced partitions: 1"]; 91 [labelType="html" label="Exchange shuffle records written: 52 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: 52 local bytes read: 1226.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: 1664.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: 1226.0 B"]; subgraph cluster92 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 11 ms"; 93 [labelType="html" label=" Project "]; 94 [labelType="html" label="Filter number of output rows: 52"]; } 95 [labelType="html" label="Scan csv number of output rows: 52 number of files read: 1 metadata time: 0 ms size of files read: 2.3 KiB"]; subgraph cluster96 { isCluster="true"; label="WholeStageCodegen (24)\n \nduration: 0 ms"; 97 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 98 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1250.0 B number of coalesced partitions: 1"]; 99 [labelType="html" label="Exchange shuffle records written: 66 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: 66 local bytes read: 1199.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: 1584.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: 1199.0 B"]; subgraph cluster100 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 4 ms"; 101 [labelType="html" label=" Project "]; 102 [labelType="html" label="Filter number of output rows: 66"]; 103 [labelType="html" label="ColumnarToRow number of output rows: 66 number of input batches: 1"]; } 104 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 6.2 KiB number of output rows: 66"]; subgraph cluster105 { isCluster="true"; label="WholeStageCodegen (26)\n \nduration: 0 ms"; 106 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 107 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.5 KiB number of coalesced partitions: 1"]; 108 [labelType="html" label="Exchange shuffle records written: 209 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: 209 local bytes read: 2.4 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: 4.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: 2.4 KiB"]; subgraph cluster109 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 4 ms"; 110 [labelType="html" label=" Project "]; 111 [labelType="html" label="Filter number of output rows: 209"]; 112 [labelType="html" label="ColumnarToRow number of output rows: 209 number of input batches: 1"]; } 113 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 10.7 KiB number of output rows: 209"]; subgraph cluster114 { isCluster="true"; label="WholeStageCodegen (28)\n \nduration: 16 ms"; 115 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 116 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 144.0 B number of coalesced partitions: 1"]; 117 [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: 136.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: 48.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: 136.0 B"]; subgraph cluster118 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 3 ms"; 119 [labelType="html" label=" Project "]; 120 [labelType="html" label="Filter number of output rows: 2"]; 121 [labelType="html" label="ColumnarToRow number of output rows: 2 number of input batches: 1"]; } 122 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 1395.0 B number of output rows: 2"]; subgraph cluster123 { isCluster="true"; label="WholeStageCodegen (31)\n \nduration: 38 ms"; 124 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 125 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 645.0 B number of coalesced partitions: 1"]; 126 [labelType="html" label="Exchange shuffle records written: 13 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: 13 local bytes read: 622.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: 432.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: 622.0 B"]; subgraph cluster127 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 4 ms"; 128 [labelType="html" label=" Project "]; 129 [labelType="html" label="Filter number of output rows: 13"]; 130 [labelType="html" label="ColumnarToRow number of output rows: 13 number of input batches: 1"]; } 131 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 2.5 KiB number of output rows: 13"]; subgraph cluster132 { isCluster="true"; label="WholeStageCodegen (33)\n \nduration: 14 ms"; 133 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 134 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 80.0 B number of coalesced partitions: 1"]; 135 [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: 76.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: 32.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: 76.0 B"]; subgraph cluster136 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 3 ms"; 137 [labelType="html" label=" Project "]; 138 [labelType="html" label="Filter number of output rows: 1"]; 139 [labelType="html" label="ColumnarToRow number of output rows: 1 number of input batches: 1"]; } 140 [labelType="html" label="Scan parquet number of files read: 1 scan time: 1 ms metadata time: 0 ms size of files read: 1660.0 B number of output rows: 1"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 12->10; 13->12; 14->13; 16->14; 17->16; 19->17; 20->19; 22->20; 23->22; 25->23; 26->25; 27->26; 29->27; 30->29; 32->30; 33->32; 34->33; 35->34; 37->35; 38->37; 40->38; 41->40; 43->41; 44->43; 45->44; 46->45; 48->46; 49->48; 50->49; 52->50; 53->52; 54->53; 56->46; 57->56; 58->57; 60->58; 61->60; 62->61; 64->62; 65->64; 66->65; 68->66; 69->68; 70->69; 71->70; 72->71; 74->38; 75->74; 76->75; 78->76; 79->78; 80->79; 82->80; 83->82; 84->83; 86->35; 87->86; 89->30; 90->89; 91->90; 93->91; 94->93; 95->94; 97->23; 98->97; 99->98; 101->99; 102->101; 103->102; 104->103; 106->20; 107->106; 108->107; 110->108; 111->110; 112->111; 113->112; 115->17; 116->115; 117->116; 119->117; 120->119; 121->120; 122->121; 124->10; 125->124; 126->125; 128->126; 129->128; 130->129; 131->130; 133->7; 134->133; 135->134; 137->135; 138->137; 139->138; 140->139; }

141

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (35)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=494117]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

SortMergeJoin [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211], [08_METIER_RADIO_210074_EXECUTANT_210075#804656], LeftOuter

WholeStageCodegen (34)

Project [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211], [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278], LeftOuter

WholeStageCodegen (32)

Sort [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211 ASC NULLS FIRST], false, 0

WholeStageCodegen (30)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 10), ENSURE_REQUIREMENTS, [plan_id=493191]

Project [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089], [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058], LeftOuter

WholeStageCodegen (29)

Project [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089], [SIC_NOMENCLATUR_210050_CODE_210051#803860], LeftOuter

WholeStageCodegen (27)

Project [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089], [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646], LeftOuter

WholeStageCodegen (25)

Sort [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089 ASC NULLS FIRST], false, 0

WholeStageCodegen (23)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, 10), ENSURE_REQUIREMENTS, [plan_id=493007]

Project [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209], [JOURS_FERIES_ME_210058_DATE_210059#803417], LeftOuter

WholeStageCodegen (22)

Sort [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209 ASC NULLS FIRST], false, 0

WholeStageCodegen (20)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, 10), ENSURE_REQUIREMENTS, [plan_id=492778]

CartesianProduct

Project [str_remove_space(COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, RIGHT) AS COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, str_extract(str_if_with_rule((COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538 <=> B), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795), LEFT, 10) AS COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, str_remove_space(COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, RIGHT) AS COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]

SortMergeJoin [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537], [00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814], LeftOuter

WholeStageCodegen (18)

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, str_if_with_rule(((COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642 <=> ) OR isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642)), date_time_to_str(COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642) AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]

WholeStageCodegen (15)

Window [min(COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653) windowspecdefinition(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685], [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537], [1 DESC NULLS LAST]

Sort [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_to_datez(COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_if_with_rule((isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AND isnotnull(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554)), str_join(array(str_join(array(str_extract(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, RIGHT, 4), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 3, 2), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 1, 2)), -), 00:01:00), ), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AS COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589]

SortMergeJoin [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537], [02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553], LeftOuter

WholeStageCodegen (14)

Sort [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST], false, 0

WholeStageCodegen (11)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 10), ENSURE_REQUIREMENTS, [plan_id=491643]

Project [Numéro Séjour#800736 AS COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, Code Acte#800737 AS COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, Date soins#800739 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#800740, ONLY_ONE), [ ], [-])), UPPER) AS COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]

Filter (Numéro Séjour#800736 <=> 011040518)

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#800736,Code Acte#800737,Date soins#800739,Spécialité exécutant#800740] Batched: false, DataFilters: [(Numéro Séjour#800736 <=> 011040518)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_209974/Horodatage_actes..., PartitionFilters: [], PushedFilters: [EqualNullSafe(Numéro Séjour,011040518)], ReadSchema: struct<Numéro Séjour:string,Code Acte:string,Date soins:string,Spécialité exécutant:string>

Project [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 AS 02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 AS 02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554]

Filter (COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608 <=> 1)

WholeStageCodegen (13)

Window [row_number() windowspecdefinition(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608], [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535], [COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST]

Sort [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 ASC NULLS FIRST, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST], false, 0

WholeStageCodegen (12)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, 10), ENSURE_REQUIREMENTS, [plan_id=492113]

HashAggregate(keys=[COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475], functions=[])

WholeStageCodegen (10)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475, 10), ENSURE_REQUIREMENTS, [plan_id=491665]

HashAggregate(keys=[COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475], functions=[])

Project [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103 AS COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 AS COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108 AS COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]

Filter ((COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 <=> 011040518) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103,COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107,COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108] Batched: true, DataFilters: [(COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 <=> 011040518), isnotnull(COL_F76265AB_8748_411..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_210376], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,011040518), IsNotNull(COL_F76265AB_8748_4..., ReadSchema: struct<COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:s...

Project [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396 AS 00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]

Filter (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412 <=> 1)

WholeStageCodegen (17)

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

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

WholeStageCodegen (16)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, 10), ENSURE_REQUIREMENTS, [plan_id=491694]

Project [Numéro Séjour#802278 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]

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

WholeStageCodegen (3)

FileScan csv [Numéro Séjour#802278] Batched: false, DataFilters: [NOT CASE WHEN isnull(StartsWith(Numéro Séjour#802278, #)) THEN false ELSE StartsWith(Numéro Séjo..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_209976/passage_Patient_..., PartitionFilters: [], PushedFilters: [EqualNullSafe(Numéro Séjour,011040518), IsNotNull(Numéro Séjour)], ReadSchema: struct<Numéro Séjour:string>

ColumnarToRow

WholeStageCodegen (19)

FileScan parquet [] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/09_INFORMATION__209985_16b54f457978..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<>

Sort [JOURS_FERIES_ME_210058_DATE_210059#803417 ASC NULLS FIRST], false, 0

WholeStageCodegen (21)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#803417, 10), ENSURE_REQUIREMENTS, [plan_id=491717]

Project [date#801998 AS JOURS_FERIES_ME_210058_DATE_210059#803417]

Filter isnotnull(date#801998)

WholeStageCodegen (4)

FileScan csv [date#801998] Batched: false, DataFilters: [isnotnull(date#801998)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_209980/jours_feries_met..., PartitionFilters: [], PushedFilters: [IsNotNull(date)], ReadSchema: struct<date:string>

Sort [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646 ASC NULLS FIRST], false, 0

WholeStageCodegen (24)

AQEShuffleRead coalesced

Exchange hashpartitioning(CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646, 10), ENSURE_REQUIREMENTS, [plan_id=491741]

Project [Code+CCMU#801528 AS CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]

Filter isnotnull(Code+CCMU#801528)

ColumnarToRow

WholeStageCodegen (5)

FileScan parquet [Code+CCMU#801528] Batched: true, DataFilters: [isnotnull(Code+CCMU#801528)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/CCMU_SERVEUR_209992_d8efd69afe82378..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+CCMU`)], ReadSchema: struct<Code+CCMU:string>

Sort [SIC_NOMENCLATUR_210050_CODE_210051#803860 ASC NULLS FIRST], false, 0

WholeStageCodegen (26)

AQEShuffleRead coalesced

Exchange hashpartitioning(SIC_NOMENCLATUR_210050_CODE_210051#803860, 10), ENSURE_REQUIREMENTS, [plan_id=491764]

Project [CODE#801713 AS SIC_NOMENCLATUR_210050_CODE_210051#803860]

Filter isnotnull(CODE#801713)

ColumnarToRow

WholeStageCodegen (6)

FileScan parquet [CODE#801713] Batched: true, DataFilters: [isnotnull(CODE#801713)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/SIC_SERVEUR_209997_1f27113dc3325158..., PartitionFilters: [], PushedFilters: [IsNotNull(CODE)], ReadSchema: struct<CODE:string>

Sort [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058 ASC NULLS FIRST], false, 0

WholeStageCodegen (28)

AQEShuffleRead coalesced

Exchange hashpartitioning(05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058, 10), ENSURE_REQUIREMENTS, [plan_id=491787]

Project [Code+Acte+en+G#802178 AS 05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]

Filter isnotnull(Code+Acte+en+G#802178)

ColumnarToRow

WholeStageCodegen (7)

FileScan parquet [Code+Acte+en+G#802178] Batched: true, DataFilters: [isnotnull(Code+Acte+en+G#802178)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/05_ACTE_EN_G_SE_209986_1f8120086527..., PartitionFilters: [], PushedFilters: [IsNotNull(`Code+Acte+en+G`)], ReadSchema: struct<Code+Acte+en+G:string>

Sort [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278 ASC NULLS FIRST], false, 0

WholeStageCodegen (31)

AQEShuffleRead coalesced

Exchange hashpartitioning(07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278, 10), ENSURE_REQUIREMENTS, [plan_id=491812]

Project [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER) AS 07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]

Filter isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER))

ColumnarToRow

WholeStageCodegen (8)

FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#800650] Batched: true, DataFilters: [isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9ciali..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/07_SPECIALITE_S_209989_bdcb1a20fa99..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string>

Sort [08_METIER_RADIO_210074_EXECUTANT_210075#804656 ASC NULLS FIRST], false, 0

WholeStageCodegen (33)

AQEShuffleRead coalesced

Exchange hashpartitioning(08_METIER_RADIO_210074_EXECUTANT_210075#804656, 10), ENSURE_REQUIREMENTS, [plan_id=491835]

Project [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER) AS 08_METIER_RADIO_210074_EXECUTANT_210075#804656]

Filter isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER))

ColumnarToRow

WholeStageCodegen (9)

FileScan parquet [+EXECUTANT#802472] Batched: true, DataFilters: [isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#80..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/08_METIER_RADIO_209987_93eff1bff90f..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<+EXECUTANT:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (195)
+- == Final Plan ==
   * HashAggregate (119)
   +- ShuffleQueryStage (118), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- Exchange (117)
         +- * HashAggregate (116)
            +- * Project (115)
               +- * SortMergeJoin LeftOuter (114)
                  :- * Project (105)
                  :  +- * SortMergeJoin LeftOuter (104)
                  :     :- * Sort (95)
                  :     :  +- AQEShuffleRead (94)
                  :     :     +- ShuffleQueryStage (93), Statistics(sizeInBytes=232.0 B, rowCount=7)
                  :     :        +- Exchange (92)
                  :     :           +- * Project (91)
                  :     :              +- * SortMergeJoin LeftOuter (90)
                  :     :                 :- * Project (81)
                  :     :                 :  +- * SortMergeJoin LeftOuter (80)
                  :     :                 :     :- * Project (71)
                  :     :                 :     :  +- * SortMergeJoin LeftOuter (70)
                  :     :                 :     :     :- * Sort (61)
                  :     :                 :     :     :  +- AQEShuffleRead (60)
                  :     :                 :     :     :     +- ShuffleQueryStage (59), Statistics(sizeInBytes=344.0 B, rowCount=7)
                  :     :                 :     :     :        +- Exchange (58)
                  :     :                 :     :     :           +- * Project (57)
                  :     :                 :     :     :              +- * SortMergeJoin LeftOuter (56)
                  :     :                 :     :     :                 :- * Sort (48)
                  :     :                 :     :     :                 :  +- AQEShuffleRead (47)
                  :     :                 :     :     :                 :     +- ShuffleQueryStage (46), Statistics(sizeInBytes=512.0 B, rowCount=7)
                  :     :                 :     :     :                 :        +- Exchange (45)
                  :     :                 :     :     :                 :           +- CartesianProduct Inner (44)
                  :     :                 :     :     :                 :              :- * Project (41)
                  :     :                 :     :     :                 :              :  +- * SortMergeJoin LeftOuter (40)
                  :     :                 :     :     :                 :              :     :- * Project (29)
                  :     :                 :     :     :                 :              :     :  +- Window (28)
                  :     :                 :     :     :                 :              :     :     +- * Sort (27)
                  :     :                 :     :     :                 :              :     :        +- * Project (26)
                  :     :                 :     :     :                 :              :     :           +- * Project (25)
                  :     :                 :     :     :                 :              :     :              +- * SortMergeJoin LeftOuter (24)
                  :     :                 :     :     :                 :              :     :                 :- * Sort (7)
                  :     :                 :     :     :                 :              :     :                 :  +- AQEShuffleRead (6)
                  :     :                 :     :     :                 :              :     :                 :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=736.0 B, rowCount=7)
                  :     :                 :     :     :                 :              :     :                 :        +- Exchange (4)
                  :     :                 :     :     :                 :              :     :                 :           +- * Project (3)
                  :     :                 :     :     :                 :              :     :                 :              +- * Filter (2)
                  :     :                 :     :     :                 :              :     :                 :                 +- Scan csv  (1)
                  :     :                 :     :     :                 :              :     :                 +- * Project (23)
                  :     :                 :     :     :                 :              :     :                    +- * Filter (22)
                  :     :                 :     :     :                 :              :     :                       +- Window (21)
                  :     :                 :     :     :                 :              :     :                          +- * Sort (20)
                  :     :                 :     :     :                 :              :     :                             +- AQEShuffleRead (19)
                  :     :                 :     :     :                 :              :     :                                +- ShuffleQueryStage (18), Statistics(sizeInBytes=48.0 B, rowCount=1)
                  :     :                 :     :     :                 :              :     :                                   +- Exchange (17)
                  :     :                 :     :     :                 :              :     :                                      +- * HashAggregate (16)
                  :     :                 :     :     :                 :              :     :                                         +- AQEShuffleRead (15)
                  :     :                 :     :     :                 :              :     :                                            +- ShuffleQueryStage (14), Statistics(sizeInBytes=80.0 B, rowCount=1)
                  :     :                 :     :     :                 :              :     :                                               +- Exchange (13)
                  :     :                 :     :     :                 :              :     :                                                  +- * HashAggregate (12)
                  :     :                 :     :     :                 :              :     :                                                     +- * Project (11)
                  :     :                 :     :     :                 :              :     :                                                        +- * Filter (10)
                  :     :                 :     :     :                 :              :     :                                                           +- * ColumnarToRow (9)
                  :     :                 :     :     :                 :              :     :                                                              +- Scan parquet  (8)
                  :     :                 :     :     :                 :              :     +- * Project (39)
                  :     :                 :     :     :                 :              :        +- * Filter (38)
                  :     :                 :     :     :                 :              :           +- Window (37)
                  :     :                 :     :     :                 :              :              +- * Sort (36)
                  :     :                 :     :     :                 :              :                 +- AQEShuffleRead (35)
                  :     :                 :     :     :                 :              :                    +- ShuffleQueryStage (34), Statistics(sizeInBytes=32.0 B, rowCount=1)
                  :     :                 :     :     :                 :              :                       +- Exchange (33)
                  :     :                 :     :     :                 :              :                          +- * Project (32)
                  :     :                 :     :     :                 :              :                             +- * Filter (31)
                  :     :                 :     :     :                 :              :                                +- Scan csv  (30)
                  :     :                 :     :     :                 :              +- * ColumnarToRow (43)
                  :     :                 :     :     :                 :                 +- Scan parquet  (42)
                  :     :                 :     :     :                 +- * Sort (55)
                  :     :                 :     :     :                    +- AQEShuffleRead (54)
                  :     :                 :     :     :                       +- ShuffleQueryStage (53), Statistics(sizeInBytes=1664.0 B, rowCount=52)
                  :     :                 :     :     :                          +- Exchange (52)
                  :     :                 :     :     :                             +- * Project (51)
                  :     :                 :     :     :                                +- * Filter (50)
                  :     :                 :     :     :                                   +- Scan csv  (49)
                  :     :                 :     :     +- * Sort (69)
                  :     :                 :     :        +- AQEShuffleRead (68)
                  :     :                 :     :           +- ShuffleQueryStage (67), Statistics(sizeInBytes=1584.0 B, rowCount=66)
                  :     :                 :     :              +- Exchange (66)
                  :     :                 :     :                 +- * Project (65)
                  :     :                 :     :                    +- * Filter (64)
                  :     :                 :     :                       +- * ColumnarToRow (63)
                  :     :                 :     :                          +- Scan parquet  (62)
                  :     :                 :     +- * Sort (79)
                  :     :                 :        +- AQEShuffleRead (78)
                  :     :                 :           +- ShuffleQueryStage (77), Statistics(sizeInBytes=4.9 KiB, rowCount=209)
                  :     :                 :              +- Exchange (76)
                  :     :                 :                 +- * Project (75)
                  :     :                 :                    +- * Filter (74)
                  :     :                 :                       +- * ColumnarToRow (73)
                  :     :                 :                          +- Scan parquet  (72)
                  :     :                 +- * Sort (89)
                  :     :                    +- AQEShuffleRead (88)
                  :     :                       +- ShuffleQueryStage (87), Statistics(sizeInBytes=48.0 B, rowCount=2)
                  :     :                          +- Exchange (86)
                  :     :                             +- * Project (85)
                  :     :                                +- * Filter (84)
                  :     :                                   +- * ColumnarToRow (83)
                  :     :                                      +- Scan parquet  (82)
                  :     +- * Sort (103)
                  :        +- AQEShuffleRead (102)
                  :           +- ShuffleQueryStage (101), Statistics(sizeInBytes=432.0 B, rowCount=13)
                  :              +- Exchange (100)
                  :                 +- * Project (99)
                  :                    +- * Filter (98)
                  :                       +- * ColumnarToRow (97)
                  :                          +- Scan parquet  (96)
                  +- * Sort (113)
                     +- AQEShuffleRead (112)
                        +- ShuffleQueryStage (111), Statistics(sizeInBytes=32.0 B, rowCount=1)
                           +- Exchange (110)
                              +- * Project (109)
                                 +- * Filter (108)
                                    +- * ColumnarToRow (107)
                                       +- Scan parquet  (106)
+- == Initial Plan ==
   HashAggregate (194)
   +- Exchange (193)
      +- HashAggregate (192)
         +- Project (191)
            +- SortMergeJoin LeftOuter (190)
               :- Project (185)
               :  +- SortMergeJoin LeftOuter (184)
               :     :- Sort (179)
               :     :  +- Exchange (178)
               :     :     +- Project (177)
               :     :        +- SortMergeJoin LeftOuter (176)
               :     :           :- Project (171)
               :     :           :  +- SortMergeJoin LeftOuter (170)
               :     :           :     :- Project (165)
               :     :           :     :  +- SortMergeJoin LeftOuter (164)
               :     :           :     :     :- Sort (159)
               :     :           :     :     :  +- Exchange (158)
               :     :           :     :     :     +- Project (157)
               :     :           :     :     :        +- SortMergeJoin LeftOuter (156)
               :     :           :     :     :           :- Sort (151)
               :     :           :     :     :           :  +- Exchange (150)
               :     :           :     :     :           :     +- CartesianProduct Inner (149)
               :     :           :     :     :           :        :- Project (148)
               :     :           :     :     :           :        :  +- SortMergeJoin LeftOuter (147)
               :     :           :     :     :           :        :     :- Project (139)
               :     :           :     :     :           :        :     :  +- Window (138)
               :     :           :     :     :           :        :     :     +- Sort (137)
               :     :           :     :     :           :        :     :        +- Project (136)
               :     :           :     :     :           :        :     :           +- Project (135)
               :     :           :     :     :           :        :     :              +- SortMergeJoin LeftOuter (134)
               :     :           :     :     :           :        :     :                 :- Sort (123)
               :     :           :     :     :           :        :     :                 :  +- Exchange (122)
               :     :           :     :     :           :        :     :                 :     +- Project (121)
               :     :           :     :     :           :        :     :                 :        +- Filter (120)
               :     :           :     :     :           :        :     :                 :           +- Scan csv  (1)
               :     :           :     :     :           :        :     :                 +- Project (133)
               :     :           :     :     :           :        :     :                    +- Filter (132)
               :     :           :     :     :           :        :     :                       +- Window (131)
               :     :           :     :     :           :        :     :                          +- Sort (130)
               :     :           :     :     :           :        :     :                             +- Exchange (129)
               :     :           :     :     :           :        :     :                                +- HashAggregate (128)
               :     :           :     :     :           :        :     :                                   +- Exchange (127)
               :     :           :     :     :           :        :     :                                      +- HashAggregate (126)
               :     :           :     :     :           :        :     :                                         +- Project (125)
               :     :           :     :     :           :        :     :                                            +- Filter (124)
               :     :           :     :     :           :        :     :                                               +- Scan parquet  (8)
               :     :           :     :     :           :        :     +- Project (146)
               :     :           :     :     :           :        :        +- Filter (145)
               :     :           :     :     :           :        :           +- Window (144)
               :     :           :     :     :           :        :              +- Sort (143)
               :     :           :     :     :           :        :                 +- Exchange (142)
               :     :           :     :     :           :        :                    +- Project (141)
               :     :           :     :     :           :        :                       +- Filter (140)
               :     :           :     :     :           :        :                          +- Scan csv  (30)
               :     :           :     :     :           :        +- Scan parquet  (42)
               :     :           :     :     :           +- Sort (155)
               :     :           :     :     :              +- Exchange (154)
               :     :           :     :     :                 +- Project (153)
               :     :           :     :     :                    +- Filter (152)
               :     :           :     :     :                       +- Scan csv  (49)
               :     :           :     :     +- Sort (163)
               :     :           :     :        +- Exchange (162)
               :     :           :     :           +- Project (161)
               :     :           :     :              +- Filter (160)
               :     :           :     :                 +- Scan parquet  (62)
               :     :           :     +- Sort (169)
               :     :           :        +- Exchange (168)
               :     :           :           +- Project (167)
               :     :           :              +- Filter (166)
               :     :           :                 +- Scan parquet  (72)
               :     :           +- Sort (175)
               :     :              +- Exchange (174)
               :     :                 +- Project (173)
               :     :                    +- Filter (172)
               :     :                       +- Scan parquet  (82)
               :     +- Sort (183)
               :        +- Exchange (182)
               :           +- Project (181)
               :              +- Filter (180)
               :                 +- Scan parquet  (96)
               +- Sort (189)
                  +- Exchange (188)
                     +- Project (187)
                        +- Filter (186)
                           +- Scan parquet  (106)


(1) Scan csv 
Output [4]: [Numéro Séjour#800736, Code Acte#800737, Date soins#800739, Spécialité exécutant#800740]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_209974/Horodatage_actes_Patient_CHSF_M122025.csv]
PushedFilters: [EqualNullSafe(Numéro Séjour,011040518)]
ReadSchema: struct<Numéro Séjour:string,Code Acte:string,Date soins:string,Spécialité exécutant:string>

(2) Filter [codegen id : 1]
Input [4]: [Numéro Séjour#800736, Code Acte#800737, Date soins#800739, Spécialité exécutant#800740]
Condition : (Numéro Séjour#800736 <=> 011040518)

(3) Project [codegen id : 1]
Output [4]: [Numéro Séjour#800736 AS COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, Code Acte#800737 AS COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, Date soins#800739 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#800740, ONLY_ONE), [ ], [-])), UPPER) AS COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Input [4]: [Numéro Séjour#800736, Code Acte#800737, Date soins#800739, Spécialité exécutant#800740]

(4) Exchange
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: hashpartitioning(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 10), ENSURE_REQUIREMENTS, [plan_id=491643]

(5) ShuffleQueryStage
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: 0

(6) AQEShuffleRead
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: coalesced

(7) Sort [codegen id : 11]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_210376]
PushedFilters: [EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,011040518), IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_96E2282E_0771_460E_8BDB_D11261BD9020:string>

(9) ColumnarToRow [codegen id : 2]
Input [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]

(10) Filter [codegen id : 2]
Input [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]
Condition : ((COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 <=> 011040518) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107))

(11) Project [codegen id : 2]
Output [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103 AS COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 AS COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108 AS COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Input [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]

(12) HashAggregate [codegen id : 2]
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Keys [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]

(13) Exchange
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Arguments: hashpartitioning(COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475, 10), ENSURE_REQUIREMENTS, [plan_id=491665]

(14) ShuffleQueryStage
Output [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Arguments: 1

(15) AQEShuffleRead
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Arguments: coalesced

(16) HashAggregate [codegen id : 10]
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Keys [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Functions: []
Aggregate Attributes: []
Results [2]: [COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474 AS COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475 AS COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]

(17) Exchange
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: hashpartitioning(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, 10), ENSURE_REQUIREMENTS, [plan_id=492113]

(18) ShuffleQueryStage
Output [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: 9

(19) AQEShuffleRead
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: coalesced

(20) Sort [codegen id : 12]
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 ASC NULLS FIRST, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST], false, 0

(21) Window
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: [row_number() windowspecdefinition(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608], [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535], [COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST]

(22) Filter [codegen id : 13]
Input [3]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536, COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608]
Condition : (COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608 <=> 1)

(23) Project [codegen id : 13]
Output [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 AS 02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 AS 02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554]
Input [3]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536, COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608]

(24) SortMergeJoin [codegen id : 14]
Left keys [1]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537]
Right keys [1]: [02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553]
Join type: LeftOuter
Join condition: None

(25) Project [codegen id : 14]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_if_with_rule((isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AND isnotnull(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554)), str_join(array(str_join(array(str_extract(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, RIGHT, 4), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 3, 2), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 1, 2)), -), 00:01:00),  ), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AS COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589]
Input [6]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, 02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553, 02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554]

(26) Project [codegen id : 14]
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_to_datez(COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589]

(27) Sort [codegen id : 14]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(28) Window
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Arguments: [min(COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653) windowspecdefinition(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685], [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537], [1 DESC NULLS LAST]

(29) Project [codegen id : 15]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, str_if_with_rule(((COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642 <=> ) OR isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642)), date_time_to_str(COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642) AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Input [6]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653, COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685]

(30) Scan csv 
Output [1]: [Numéro Séjour#802278]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/02_PASSAGE_PATI_209976/passage_Patient_CHSF_M12025.csv]
PushedFilters: [EqualNullSafe(Numéro Séjour,011040518), IsNotNull(Numéro Séjour)]
ReadSchema: struct<Numéro Séjour:string>

(31) Filter [codegen id : 3]
Input [1]: [Numéro Séjour#802278]
Condition : ((NOT CASE WHEN isnull(StartsWith(Numéro Séjour#802278, #)) THEN false ELSE StartsWith(Numéro Séjour#802278, #) END AND (Numéro Séjour#802278 <=> 011040518)) AND isnotnull(Numéro Séjour#802278))

(32) Project [codegen id : 3]
Output [1]: [Numéro Séjour#802278 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Input [1]: [Numéro Séjour#802278]

(33) Exchange
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, 10), ENSURE_REQUIREMENTS, [plan_id=491694]

(34) ShuffleQueryStage
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: 2

(35) AQEShuffleRead
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: coalesced

(36) Sort [codegen id : 16]
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(37) Window
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396], [1 DESC NULLS LAST]

(38) Filter [codegen id : 17]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412 <=> 1)

(39) Project [codegen id : 17]
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396 AS 00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412]

(40) SortMergeJoin [codegen id : 18]
Left keys [1]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537]
Right keys [1]: [00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]
Join type: LeftOuter
Join condition: None

(41) Project [codegen id : 18]
Output [3]: [str_remove_space(COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, RIGHT) AS COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, str_extract(str_if_with_rule((COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538 <=> B), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795), LEFT, 10) AS COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, str_remove_space(COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, RIGHT) AS COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, 00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]

(42) Scan parquet 
Output: []
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__209985_16b54f45797834c8181d09b272ecbea3/Info_Etab_init_v1.1 CHSF.xlsx_1ab25517c9bbf37714f2739a531aa141]
ReadSchema: struct<>

(43) ColumnarToRow [codegen id : 19]
Input: []

(44) CartesianProduct
Join type: Inner
Join condition: None

(45) Exchange
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, 10), ENSURE_REQUIREMENTS, [plan_id=492778]

(46) ShuffleQueryStage
Output [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: 10

(47) AQEShuffleRead
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: coalesced

(48) Sort [codegen id : 20]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209 ASC NULLS FIRST], false, 0

(49) Scan csv 
Output [1]: [date#801998]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_209980/jours_feries_metropole.csv]
PushedFilters: [IsNotNull(date)]
ReadSchema: struct<date:string>

(50) Filter [codegen id : 4]
Input [1]: [date#801998]
Condition : isnotnull(date#801998)

(51) Project [codegen id : 4]
Output [1]: [date#801998 AS JOURS_FERIES_ME_210058_DATE_210059#803417]
Input [1]: [date#801998]

(52) Exchange
Input [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#803417, 10), ENSURE_REQUIREMENTS, [plan_id=491717]

(53) ShuffleQueryStage
Output [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: 3

(54) AQEShuffleRead
Input [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: coalesced

(55) Sort [codegen id : 21]
Input [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: [JOURS_FERIES_ME_210058_DATE_210059#803417 ASC NULLS FIRST], false, 0

(56) SortMergeJoin [codegen id : 22]
Left keys [1]: [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209]
Right keys [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Join type: LeftOuter
Join condition: None

(57) Project [codegen id : 22]
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [4]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, JOURS_FERIES_ME_210058_DATE_210059#803417]

(58) Exchange
Input [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, 10), ENSURE_REQUIREMENTS, [plan_id=493007]

(59) ShuffleQueryStage
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: 11

(60) AQEShuffleRead
Input [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: coalesced

(61) Sort [codegen id : 23]
Input [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089 ASC NULLS FIRST], false, 0

(62) Scan parquet 
Output [1]: [Code+CCMU#801528]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/CCMU_SERVEUR_209992_d8efd69afe82378dae7a34d0cfc5cde3/CCMU2+.xlsx_d8e42fed6d4eb0bf9d31a7c9a6a6efcd]
PushedFilters: [IsNotNull(`Code+CCMU`)]
ReadSchema: struct<Code+CCMU:string>

(63) ColumnarToRow [codegen id : 5]
Input [1]: [Code+CCMU#801528]

(64) Filter [codegen id : 5]
Input [1]: [Code+CCMU#801528]
Condition : isnotnull(Code+CCMU#801528)

(65) Project [codegen id : 5]
Output [1]: [Code+CCMU#801528 AS CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Input [1]: [Code+CCMU#801528]

(66) Exchange
Input [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: hashpartitioning(CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646, 10), ENSURE_REQUIREMENTS, [plan_id=491741]

(67) ShuffleQueryStage
Output [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: 4

(68) AQEShuffleRead
Input [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: coalesced

(69) Sort [codegen id : 24]
Input [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646 ASC NULLS FIRST], false, 0

(70) SortMergeJoin [codegen id : 25]
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Join type: LeftOuter
Join condition: None

(71) Project [codegen id : 25]
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]

(72) Scan parquet 
Output [1]: [CODE#801713]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/SIC_SERVEUR_209997_1f27113dc3325158c051f220df0fe09f/SIC.xlsx_82b27f493bc3c9a9c94d3dbc7c9b69b5]
PushedFilters: [IsNotNull(CODE)]
ReadSchema: struct<CODE:string>

(73) ColumnarToRow [codegen id : 6]
Input [1]: [CODE#801713]

(74) Filter [codegen id : 6]
Input [1]: [CODE#801713]
Condition : isnotnull(CODE#801713)

(75) Project [codegen id : 6]
Output [1]: [CODE#801713 AS SIC_NOMENCLATUR_210050_CODE_210051#803860]
Input [1]: [CODE#801713]

(76) Exchange
Input [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: hashpartitioning(SIC_NOMENCLATUR_210050_CODE_210051#803860, 10), ENSURE_REQUIREMENTS, [plan_id=491764]

(77) ShuffleQueryStage
Output [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: 5

(78) AQEShuffleRead
Input [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: coalesced

(79) Sort [codegen id : 26]
Input [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: [SIC_NOMENCLATUR_210050_CODE_210051#803860 ASC NULLS FIRST], false, 0

(80) SortMergeJoin [codegen id : 27]
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Join type: LeftOuter
Join condition: None

(81) Project [codegen id : 27]
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, SIC_NOMENCLATUR_210050_CODE_210051#803860]

(82) Scan parquet 
Output [1]: [Code+Acte+en+G#802178]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/05_ACTE_EN_G_SE_209986_1f8120086527859129de7a103ae82ebe/Info_Etab_init_v1.1 CHSF.xlsx_daa06075269289fc10eca7675c0dca0a]
PushedFilters: [IsNotNull(`Code+Acte+en+G`)]
ReadSchema: struct<Code+Acte+en+G:string>

(83) ColumnarToRow [codegen id : 7]
Input [1]: [Code+Acte+en+G#802178]

(84) Filter [codegen id : 7]
Input [1]: [Code+Acte+en+G#802178]
Condition : isnotnull(Code+Acte+en+G#802178)

(85) Project [codegen id : 7]
Output [1]: [Code+Acte+en+G#802178 AS 05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Input [1]: [Code+Acte+en+G#802178]

(86) Exchange
Input [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: hashpartitioning(05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058, 10), ENSURE_REQUIREMENTS, [plan_id=491787]

(87) ShuffleQueryStage
Output [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: 6

(88) AQEShuffleRead
Input [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: coalesced

(89) Sort [codegen id : 28]
Input [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058 ASC NULLS FIRST], false, 0

(90) SortMergeJoin [codegen id : 29]
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Join type: LeftOuter
Join condition: None

(91) Project [codegen id : 29]
Output [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]

(92) Exchange
Input [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 10), ENSURE_REQUIREMENTS, [plan_id=493191]

(93) ShuffleQueryStage
Output [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: 12

(94) AQEShuffleRead
Input [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: coalesced

(95) Sort [codegen id : 30]
Input [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211 ASC NULLS FIRST], false, 0

(96) Scan parquet 
Output [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/07_SPECIALITE_S_209989_bdcb1a20fa99e293127a2b0c80a1f92b/Info_Etab_init_v1.1 CHSF.xlsx_f76f6c31e563b107665656ddd804a9e2]
ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string>

(97) ColumnarToRow [codegen id : 8]
Input [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]

(98) Filter [codegen id : 8]
Input [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER))

(99) Project [codegen id : 8]
Output [1]: [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER) AS 07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Input [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]

(100) Exchange
Input [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: hashpartitioning(07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278, 10), ENSURE_REQUIREMENTS, [plan_id=491812]

(101) ShuffleQueryStage
Output [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: 7

(102) AQEShuffleRead
Input [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: coalesced

(103) Sort [codegen id : 31]
Input [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278 ASC NULLS FIRST], false, 0

(104) SortMergeJoin [codegen id : 32]
Left keys [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Right keys [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Join type: LeftOuter
Join condition: None

(105) Project [codegen id : 32]
Output [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [2]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]

(106) Scan parquet 
Output [1]: [+EXECUTANT#802472]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/08_METIER_RADIO_209987_93eff1bff90f8cdafb2283b9663e437e/Info_Etab_init_v1.1 CHSF.xlsx_3ffa43f14b33e8171e82a345b733f1cb]
ReadSchema: struct<+EXECUTANT:string>

(107) ColumnarToRow [codegen id : 9]
Input [1]: [+EXECUTANT#802472]

(108) Filter [codegen id : 9]
Input [1]: [+EXECUTANT#802472]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER))

(109) Project [codegen id : 9]
Output [1]: [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER) AS 08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Input [1]: [+EXECUTANT#802472]

(110) Exchange
Input [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: hashpartitioning(08_METIER_RADIO_210074_EXECUTANT_210075#804656, 10), ENSURE_REQUIREMENTS, [plan_id=491835]

(111) ShuffleQueryStage
Output [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: 8

(112) AQEShuffleRead
Input [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: coalesced

(113) Sort [codegen id : 33]
Input [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: [08_METIER_RADIO_210074_EXECUTANT_210075#804656 ASC NULLS FIRST], false, 0

(114) SortMergeJoin [codegen id : 34]
Left keys [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Right keys [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Join type: LeftOuter
Join condition: None

(115) Project [codegen id : 34]
Output: []
Input [2]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 08_METIER_RADIO_210074_EXECUTANT_210075#804656]

(116) HashAggregate [codegen id : 34]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#809169L]
Results [1]: [count#809170L]

(117) Exchange
Input [1]: [count#809170L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=494117]

(118) ShuffleQueryStage
Output [1]: [count#809170L]
Arguments: 13

(119) HashAggregate [codegen id : 35]
Input [1]: [count#809170L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#808697L]
Results [1]: [count(1)#808697L AS count#808698L]

(120) Filter
Input [4]: [Numéro Séjour#800736, Code Acte#800737, Date soins#800739, Spécialité exécutant#800740]
Condition : (Numéro Séjour#800736 <=> 011040518)

(121) Project
Output [4]: [Numéro Séjour#800736 AS COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, Code Acte#800737 AS COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, Date soins#800739 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#800740, ONLY_ONE), [ ], [-])), UPPER) AS COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Input [4]: [Numéro Séjour#800736, Code Acte#800737, Date soins#800739, Spécialité exécutant#800740]

(122) Exchange
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: hashpartitioning(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 10), ENSURE_REQUIREMENTS, [plan_id=491414]

(123) Sort
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST], false, 0

(124) Filter
Input [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]
Condition : ((COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 <=> 011040518) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107))

(125) Project
Output [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103 AS COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107 AS COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108 AS COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Input [3]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#800103, COL_F76265AB_8748_4114_92B4_00E37DE25D34#800107, COL_96E2282E_0771_460E_8BDB_D11261BD9020#800108]

(126) HashAggregate
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Keys [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]

(127) Exchange
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Arguments: hashpartitioning(COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475, 10), ENSURE_REQUIREMENTS, [plan_id=491404]

(128) HashAggregate
Input [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Keys [3]: [COL_2FEA4158_845C_4424_A9CA_B85AB23BC787#800470, COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475]
Functions: []
Aggregate Attributes: []
Results [2]: [COL_B0A3BD57_143D_4D99_B6D3_1643D1B44515#800474 AS COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_5B2C7C51_2758_4EFF_BFA0_563051DD3532#800475 AS COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]

(129) Exchange
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: hashpartitioning(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, 10), ENSURE_REQUIREMENTS, [plan_id=491407]

(130) Sort
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 ASC NULLS FIRST, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST], false, 0

(131) Window
Input [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536]
Arguments: [row_number() windowspecdefinition(COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608], [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535], [COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 ASC NULLS LAST]

(132) Filter
Input [3]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536, COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608]
Condition : (COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608 <=> 1)

(133) Project
Output [2]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535 AS 02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536 AS 02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554]
Input [3]: [COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#800535, COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#800536, COL_F8B7155B_85D8_4C56_AA9E_CBA107862DA4#800608]

(134) SortMergeJoin
Left keys [1]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537]
Right keys [1]: [02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553]
Join type: LeftOuter
Join condition: None

(135) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_if_with_rule((isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AND isnotnull(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554)), str_join(array(str_join(array(str_extract(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, RIGHT, 4), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 3, 2), str_extract_middle(02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554, 1, 2)), -), 00:01:00),  ), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540) AS COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589]
Input [6]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802540, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, 02_D_ELIGIBLE_D_210509_COL_E7A43A36_E00B_4FF8_A077_36E0B3CB668E#802553, 02_D_ELIGIBLE_D_210509_COL_B848A9AB_FC92_4DF9_9680_B28D2728DEA6#802554]

(136) Project
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589 AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, str_to_datez(COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_B37ECD07_F495_4093_A00C_6F422F16F29C#802589]

(137) Sort
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Arguments: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(138) Window
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653]
Arguments: [min(COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653) windowspecdefinition(COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685], [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537], [1 DESC NULLS LAST]

(139) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, str_if_with_rule(((COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642 <=> ) OR isnull(COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642)), date_time_to_str(COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642) AS COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541]
Input [6]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802642, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, COL_D2FFC838_F283_4212_9AB1_200623DBA7E3#802653, COL_EC5FC3FE_63E2_47F4_9B2C_24B65B0FA626#802685]

(140) Filter
Input [1]: [Numéro Séjour#802278]
Condition : ((NOT CASE WHEN isnull(StartsWith(Numéro Séjour#802278, #)) THEN false ELSE StartsWith(Numéro Séjour#802278, #) END AND (Numéro Séjour#802278 <=> 011040518)) AND isnotnull(Numéro Séjour#802278))

(141) Project
Output [1]: [Numéro Séjour#802278 AS COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Input [1]: [Numéro Séjour#802278]

(142) Exchange
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: hashpartitioning(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, 10), ENSURE_REQUIREMENTS, [plan_id=491423]

(143) Sort
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(144) Window
Input [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396]
Arguments: [row_number() windowspecdefinition(COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412], [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396], [1 DESC NULLS LAST]

(145) Filter
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412]
Condition : (COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412 <=> 1)

(146) Project
Output [1]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396 AS 00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]
Input [2]: [COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802396, COL_6B340AEB_6908_4A50_8AD6_FE561D33FBE0#802412]

(147) SortMergeJoin
Left keys [1]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537]
Right keys [1]: [00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]
Join type: LeftOuter
Join condition: None

(148) Project
Output [3]: [str_remove_space(COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, RIGHT) AS COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, str_extract(str_if_with_rule((COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538 <=> B), COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795), LEFT, 10) AS COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, str_remove_space(COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, RIGHT) AS COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#802537, COL_C8730919_E879_44D7_A7DD_B3561E73867D#802538, COL_7D270645_B926_42AF_A110_EB3A1A53031B#802795, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#802541, 00_C_PASSAGE_PA_210485_COL_2AF4FE05_74B1_4A24_9BC1_7612D6ED731D#802814]

(149) CartesianProduct
Join type: Inner
Join condition: None

(150) Exchange
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, 10), ENSURE_REQUIREMENTS, [plan_id=491436]

(151) Sort
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209 ASC NULLS FIRST], false, 0

(152) Filter
Input [1]: [date#801998]
Condition : isnotnull(date#801998)

(153) Project
Output [1]: [date#801998 AS JOURS_FERIES_ME_210058_DATE_210059#803417]
Input [1]: [date#801998]

(154) Exchange
Input [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: hashpartitioning(JOURS_FERIES_ME_210058_DATE_210059#803417, 10), ENSURE_REQUIREMENTS, [plan_id=491437]

(155) Sort
Input [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Arguments: [JOURS_FERIES_ME_210058_DATE_210059#803417 ASC NULLS FIRST], false, 0

(156) SortMergeJoin
Left keys [1]: [COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209]
Right keys [1]: [JOURS_FERIES_ME_210058_DATE_210059#803417]
Join type: LeftOuter
Join condition: None

(157) Project
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [4]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_3A5D02F6_4E3A_45C4_8CDF_BB835CE099A1#803209, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, JOURS_FERIES_ME_210058_DATE_210059#803417]

(158) Exchange
Input [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, 10), ENSURE_REQUIREMENTS, [plan_id=491446]

(159) Sort
Input [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089 ASC NULLS FIRST], false, 0

(160) Filter
Input [1]: [Code+CCMU#801528]
Condition : isnotnull(Code+CCMU#801528)

(161) Project
Output [1]: [Code+CCMU#801528 AS CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Input [1]: [Code+CCMU#801528]

(162) Exchange
Input [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: hashpartitioning(CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646, 10), ENSURE_REQUIREMENTS, [plan_id=491447]

(163) Sort
Input [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Arguments: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646 ASC NULLS FIRST], false, 0

(164) SortMergeJoin
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]
Join type: LeftOuter
Join condition: None

(165) Project
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, CCMU_NOMENCLATU_210042_CODE_CCMU_210044#803646]

(166) Filter
Input [1]: [CODE#801713]
Condition : isnotnull(CODE#801713)

(167) Project
Output [1]: [CODE#801713 AS SIC_NOMENCLATUR_210050_CODE_210051#803860]
Input [1]: [CODE#801713]

(168) Exchange
Input [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: hashpartitioning(SIC_NOMENCLATUR_210050_CODE_210051#803860, 10), ENSURE_REQUIREMENTS, [plan_id=491454]

(169) Sort
Input [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Arguments: [SIC_NOMENCLATUR_210050_CODE_210051#803860 ASC NULLS FIRST], false, 0

(170) SortMergeJoin
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [SIC_NOMENCLATUR_210050_CODE_210051#803860]
Join type: LeftOuter
Join condition: None

(171) Project
Output [2]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, SIC_NOMENCLATUR_210050_CODE_210051#803860]

(172) Filter
Input [1]: [Code+Acte+en+G#802178]
Condition : isnotnull(Code+Acte+en+G#802178)

(173) Project
Output [1]: [Code+Acte+en+G#802178 AS 05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Input [1]: [Code+Acte+en+G#802178]

(174) Exchange
Input [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: hashpartitioning(05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058, 10), ENSURE_REQUIREMENTS, [plan_id=491460]

(175) Sort
Input [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Arguments: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058 ASC NULLS FIRST], false, 0

(176) SortMergeJoin
Left keys [1]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089]
Right keys [1]: [05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]
Join type: LeftOuter
Join condition: None

(177) Project
Output [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [3]: [COL_BE0A06CA_C165_46C5_AC16_64541F42FB67#803089, COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 05_ACTE_EN_G_210072_CODE_ACTE_EN_G_210073#804058]

(178) Exchange
Input [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: hashpartitioning(COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 10), ENSURE_REQUIREMENTS, [plan_id=491468]

(179) Sort
Input [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Arguments: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211 ASC NULLS FIRST], false, 0

(180) Filter
Input [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER))

(181) Project
Output [1]: [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#800650, ONLY_ONE), [ ], [-])), UPPER) AS 07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Input [1]: [Sp%C3%A9cialit%C3%A9+etab#800650]

(182) Exchange
Input [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: hashpartitioning(07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278, 10), ENSURE_REQUIREMENTS, [plan_id=491469]

(183) Sort
Input [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Arguments: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278 ASC NULLS FIRST], false, 0

(184) SortMergeJoin
Left keys [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Right keys [1]: [07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]
Join type: LeftOuter
Join condition: None

(185) Project
Output [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Input [2]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 07_SPECIALITE_S_210099_SPECIALITE_ETAB_210100#804278]

(186) Filter
Input [1]: [+EXECUTANT#802472]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER))

(187) Project
Output [1]: [str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(+EXECUTANT#802472, ONLY_ONE), [ ], [-])), UPPER) AS 08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Input [1]: [+EXECUTANT#802472]

(188) Exchange
Input [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: hashpartitioning(08_METIER_RADIO_210074_EXECUTANT_210075#804656, 10), ENSURE_REQUIREMENTS, [plan_id=491476]

(189) Sort
Input [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Arguments: [08_METIER_RADIO_210074_EXECUTANT_210075#804656 ASC NULLS FIRST], false, 0

(190) SortMergeJoin
Left keys [1]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211]
Right keys [1]: [08_METIER_RADIO_210074_EXECUTANT_210075#804656]
Join type: LeftOuter
Join condition: None

(191) Project
Output: []
Input [2]: [COL_19C0E740_E06D_42D5_B307_A1E931A5DCDB#803211, 08_METIER_RADIO_210074_EXECUTANT_210075#804656]

(192) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#809169L]
Results [1]: [count#809170L]

(193) Exchange
Input [1]: [count#809170L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=491482]

(194) HashAggregate
Input [1]: [count#809170L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#808697L]
Results [1]: [count(1)#808697L AS count#808698L]

(195) AdaptiveSparkPlan
Output [1]: [count#808698L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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