SP1 - Details for Query 5201

Submitted Time: 2026/05/22 14:16:38
Duration: 4 s
Succeeded Jobs: 8132 8133 8134 8135 8136 8137

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 11 ms number of output rows: 76,341 number of dynamic part: 0 written output: 483.7 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 531 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 76,341 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 577 ms"; 8 [labelType="html" label="Sort sort time: 28 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1886.8 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 76,341 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 9 ms (2 ms, 3 ms, 3 ms (stage 16708.0: task 23088)) 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: 76,341 local bytes read: 1784.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 3 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 10.5 MiB (3.1 MiB, 3.1 MiB, 4.2 MiB (stage 16708.0: task 23088)) 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)) 1784.9 KiB (539.5 KiB, 540.8 KiB, 704.6 KiB (stage 16708.0: task 23088))"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: total (min, med, max (stageId: taskId))\n362 ms (109 ms, 112 ms, 141 ms (stage 16708.0: task 23088))"; 12 [labelType="html" label=" Project "]; } 13 [labelType="html" label="CartesianProduct number of output rows: 76,341"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: total (min, med, max (stageId: taskId))\n363 ms (109 ms, 112 ms, 142 ms (stage 16708.0: task 23088))"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 76,341"]; } 17 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16708.0: task 23086))"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: total (min, med, max (stageId: taskId))\n588 ms (182 ms, 184 ms, 222 ms (stage 16708.0: task 23088))"; 19 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 35 ms (10 ms, 10 ms, 15 ms (stage 16708.0: task 23088)) peak memory total (min, med, max (stageId: taskId)) 56.0 MiB (18.0 MiB, 18.0 MiB, 20.0 MiB (stage 16708.0: task 23088)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16708.0: task 23086))"]; } 20 [labelType="html" label="Window spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16708.0: task 23086))"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: total (min, med, max (stageId: taskId))\n370 ms (114 ms, 117 ms, 139 ms (stage 16708.0: task 23088))"; 22 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 89 ms (25 ms, 26 ms, 38 ms (stage 16708.0: task 23088)) peak memory total (min, med, max (stageId: taskId)) 56.0 MiB (18.0 MiB, 18.0 MiB, 20.0 MiB (stage 16708.0: task 23088)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16708.0: task 23086))"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 3 partition data size total (min, med, max (stageId: taskId)) 4.3 MiB (1329.9 KiB, 1330.5 KiB, 1770.3 KiB (driver)) number of coalesced partitions: 3"]; 24 [labelType="html" label="Exchange shuffle records written: 270,457 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 20 ms (1 ms, 4 ms, 6 ms (stage 16704.0: task 23078)) 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: 270,457 local bytes read total (min, med, max (stageId: taskId)) 4.1 MiB (1255.8 KiB, 1272.7 KiB, 1690.5 KiB (stage 16708.0: task 23088)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16708.0: task 23086)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 18 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 26.8 MiB (433.3 KiB, 4.4 MiB, 12.1 MiB (stage 16704.0: task 23078)) 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)) 4.1 MiB (95.7 KiB, 803.1 KiB, 1591.7 KiB (stage 16704.0: task 23078))"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: total (min, med, max (stageId: taskId))\n4.7 s (32 ms, 203 ms, 1.4 s (stage 16704.0: task 23084))"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Generate number of output rows: 270,457"]; 28 [labelType="html" label=" Project "]; } 29 [labelType="html" label="CartesianProduct number of output rows: 115,951"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n4.7 s (32 ms, 203 ms, 1.4 s (stage 16704.0: task 23084))"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="SortMergeJoin number of output rows: 115,951 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16704.0: task 23085))"]; } subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 86 ms"; 34 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 3.5 s (9 ms, 35 ms, 1.3 s (stage 16704.0: task 23084)) peak memory total (min, med, max (stageId: taskId)) 230.0 MiB (18.0 MiB, 20.0 MiB, 40.0 MiB (stage 16704.0: task 23081)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16704.0: task 23085))"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 9 partition data size total (min, med, max (stageId: taskId)) 23.1 MiB (1151.0 KiB, 2039.0 KiB, 4.3 MiB (driver)) number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 1,115,956 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 118 ms (2 ms, 10 ms, 37 ms (stage 16699.0: task 23068)) 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,115,956 local bytes read total (min, med, max (stageId: taskId)) 22.0 MiB (1104.0 KiB, 1987.6 KiB, 4.1 MiB (stage 16704.0: task 23077)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16704.0: task 23085)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 82 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 104.2 MiB (4.6 MiB, 11.0 MiB, 11.7 MiB (stage 16699.0: task 23073)) 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)) 22.0 MiB (497.4 KiB, 2.4 MiB, 2.4 MiB (stage 16699.0: task 23065))"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n7.9 s (336 ms, 791 ms, 1.3 s (stage 16699.0: task 23073))"; 38 [labelType="html" label=" Project "]; 39 [labelType="html" label="Filter number of output rows: 1,115,956"]; } 40 [labelType="html" label="Scan csv number of output rows: 1,115,956 number of files read: 1 metadata time: 0 ms size of files read: 64.4 MiB"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n8.7 s (33 ms, 249 ms, 2.8 s (stage 16704.0: task 23084))"; 42 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16704.0: task 23085)) peak memory total (min, med, max (stageId: taskId)) 96.6 MiB (64.0 KiB, 16.1 MiB, 16.1 MiB (stage 16704.0: task 23082)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 16704.0: task 23085))"]; } 43 [labelType="html" label="AQEShuffleRead number of partitions: 9 partition data size total (min, med, max (stageId: taskId)) 883.0 B (0.0 B, 117.0 B, 189.0 B (driver)) number of coalesced partitions: 1"]; 44 [labelType="html" label="Exchange shuffle records written: 8 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 8 local bytes read total (min, med, max (stageId: taskId)) 849.0 B (111.0 B, 130.0 B, 189.0 B (stage 16704.0: task 23084)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 16704.0: task 23082)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size: 656.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: 849.0 B"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 7 ms"; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label="Filter number of output rows: 8"]; 48 [labelType="html" label="ColumnarToRow number of output rows: 62 number of input batches: 1"]; } 49 [labelType="html" label="Scan parquet number of files read: 1 scan time: 4 ms metadata time: 0 ms size of files read: 3.9 KiB number of output rows: 62"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n48 ms (4 ms, 5 ms, 6 ms (stage 16704.0: task 23082))"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label="Filter number of output rows: 9"]; } 53 [labelType="html" label="Scan csv number of output rows: 9 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster54 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: total (min, med, max (stageId: taskId))\n8 ms (2 ms, 3 ms, 3 ms (stage 16708.0: task 23087))"; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label="ColumnarToRow number of output rows: 3 number of input batches: 3"]; } 57 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 8 ms (2 ms, 3 ms, 3 ms (stage 16708.0: task 23087)) metadata time: 0 ms size of files read: 2.1 KiB number of output rows: 3"]; subgraph cluster58 { isCluster="true"; label="WholeStageCodegen (15)\n \nduration: 0 ms"; 59 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 60 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 2.4 KiB number of coalesced partitions: 1"]; 61 [labelType="html" label="Exchange shuffle records written: 52 local merged chunks fetched: 0 shuffle write time: 4 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: 2.3 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: 3.6 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.3 KiB"]; subgraph cluster62 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 8 ms"; 63 [labelType="html" label=" Project "]; 64 [labelType="html" label="Filter number of output rows: 52"]; } 65 [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"]; 1->0; 2->1; 4->2; 5->4; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 15->13; 16->15; 17->16; 19->17; 20->19; 22->20; 23->22; 24->23; 26->24; 27->26; 28->27; 29->28; 31->29; 32->31; 34->32; 35->34; 36->35; 38->36; 39->38; 40->39; 42->32; 43->42; 44->43; 46->44; 47->46; 48->47; 49->48; 51->29; 52->51; 53->52; 55->13; 56->55; 57->56; 59->6; 60->59; 61->60; 63->61; 64->63; 65->64; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217], Overwrite, [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8]

WriteFiles

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1293200, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129]

SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901], [JOURS_FERIES_ME_187979_DATE_187980#1293035], LeftOuter

WholeStageCodegen (16)

Sort [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901 ASC NULLS FIRST], false, 0

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 10), ENSURE_REQUIREMENTS, [plan_id=737371]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]

WholeStageCodegen (13)

CartesianProduct

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901]

Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655 <=> 1))

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, 10), ENSURE_REQUIREMENTS, [plan_id=737207]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_split(LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562]

WholeStageCodegen (8)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440], [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492], Inner

WholeStageCodegen (6)

Sort [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440, 10), ENSURE_REQUIREMENTS, [plan_id=736773]

Project [Numéro Séjour#1292135 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, Date soins#1292138 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]

Filter isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER))

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1292135,Date soins#1292138,Spécialité exécutant#1292139] Batched: false, DataFilters: [isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité ex..., Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_187894/horodatage_actes..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

Sort [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, 10), ENSURE_REQUIREMENTS, [plan_id=736793]

Project [Codes+officiels#1292276 AS LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277 AS LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]

Filter (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;)))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#1292274,Codes+officiels#1292276,Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277] Batched: true, DataFilters: [isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277), isnotnull(str_replace_extend(str_transfor..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_187927_2d8ded9b509a..., PartitionFilters: [], PushedFilters: [IsNotNull(`Sp%C3%A9cialit%C3%A9+urgentiste+UF`)], ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string,Codes+officiels:string,Sp%C3%A9cialit%C3%A9+urgentiste+UF...

Project

Filter ((isnotnull(REGLES#1292203) AND (RC-SUN-AUTO = REGLES#1292203)) AND (APPLICABLE#1292204 <=> O))

WholeStageCodegen (7)

FileScan csv [REGLES#1292203,APPLICABLE#1292204] Batched: false, DataFilters: [isnotnull(REGLES#1292203), (RC-SUN-AUTO = REGLES#1292203), (APPLICABLE#1292204 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Project [str_extract(Finess#1292223, LEFT, 2) AS 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924]

ColumnarToRow

WholeStageCodegen (12)

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

Sort [JOURS_FERIES_ME_187979_DATE_187980#1293035 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_187979_DATE_187980#1293035, 10), ENSURE_REQUIREMENTS, [plan_id=736833]

Project [date#1292360 AS JOURS_FERIES_ME_187979_DATE_187980#1293035, departement#1292364 AS JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, nom_jour_ferie#1292363 AS JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]

Filter isnotnull(date#1292360)

WholeStageCodegen (3)

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

Details

== Physical Plan ==
AdaptiveSparkPlan (94)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (54)
   +- WriteFiles (53)
      +- * Project (52)
         +- * Project (51)
            +- * SortMergeJoin LeftOuter (50)
               :- * Sort (42)
               :  +- AQEShuffleRead (41)
               :     +- ShuffleQueryStage (40), Statistics(sizeInBytes=10.5 MiB, rowCount=7.63E+4)
               :        +- Exchange (39)
               :           +- * Project (38)
               :              +- CartesianProduct Inner (37)
               :                 :- * Project (33)
               :                 :  +- * Filter (32)
               :                 :     +- Window (31)
               :                 :        +- * Sort (30)
               :                 :           +- Window (29)
               :                 :              +- * Sort (28)
               :                 :                 +- AQEShuffleRead (27)
               :                 :                    +- ShuffleQueryStage (26), Statistics(sizeInBytes=26.8 MiB, rowCount=2.70E+5)
               :                 :                       +- Exchange (25)
               :                 :                          +- * Project (24)
               :                 :                             +- * Generate (23)
               :                 :                                +- * Project (22)
               :                 :                                   +- CartesianProduct Inner (21)
               :                 :                                      :- * Project (17)
               :                 :                                      :  +- * SortMergeJoin Inner (16)
               :                 :                                      :     :- * Sort (7)
               :                 :                                      :     :  +- AQEShuffleRead (6)
               :                 :                                      :     :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=104.2 MiB, rowCount=1.12E+6)
               :                 :                                      :     :        +- Exchange (4)
               :                 :                                      :     :           +- * Project (3)
               :                 :                                      :     :              +- * Filter (2)
               :                 :                                      :     :                 +- Scan csv  (1)
               :                 :                                      :     +- * Sort (15)
               :                 :                                      :        +- AQEShuffleRead (14)
               :                 :                                      :           +- ShuffleQueryStage (13), Statistics(sizeInBytes=656.0 B, rowCount=8)
               :                 :                                      :              +- Exchange (12)
               :                 :                                      :                 +- * Project (11)
               :                 :                                      :                    +- * Filter (10)
               :                 :                                      :                       +- * ColumnarToRow (9)
               :                 :                                      :                          +- Scan parquet  (8)
               :                 :                                      +- * Project (20)
               :                 :                                         +- * Filter (19)
               :                 :                                            +- Scan csv  (18)
               :                 +- * Project (36)
               :                    +- * ColumnarToRow (35)
               :                       +- Scan parquet  (34)
               +- * Sort (49)
                  +- AQEShuffleRead (48)
                     +- ShuffleQueryStage (47), Statistics(sizeInBytes=3.6 KiB, rowCount=52)
                        +- Exchange (46)
                           +- * Project (45)
                              +- * Filter (44)
                                 +- Scan csv  (43)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (93)
   +- WriteFiles (92)
      +- Project (91)
         +- Project (90)
            +- SortMergeJoin LeftOuter (89)
               :- Sort (84)
               :  +- Exchange (83)
               :     +- Project (82)
               :        +- CartesianProduct Inner (81)
               :           :- Project (78)
               :           :  +- Filter (77)
               :           :     +- Window (76)
               :           :        +- Sort (75)
               :           :           +- Window (74)
               :           :              +- Sort (73)
               :           :                 +- Exchange (72)
               :           :                    +- Project (71)
               :           :                       +- Generate (70)
               :           :                          +- Project (69)
               :           :                             +- CartesianProduct Inner (68)
               :           :                                :- Project (64)
               :           :                                :  +- SortMergeJoin Inner (63)
               :           :                                :     :- Sort (58)
               :           :                                :     :  +- Exchange (57)
               :           :                                :     :     +- Project (56)
               :           :                                :     :        +- Filter (55)
               :           :                                :     :           +- Scan csv  (1)
               :           :                                :     +- Sort (62)
               :           :                                :        +- Exchange (61)
               :           :                                :           +- Project (60)
               :           :                                :              +- Filter (59)
               :           :                                :                 +- Scan parquet  (8)
               :           :                                +- Project (67)
               :           :                                   +- Filter (66)
               :           :                                      +- Scan csv  (65)
               :           +- Project (80)
               :              +- Scan parquet  (79)
               +- Sort (88)
                  +- Exchange (87)
                     +- Project (86)
                        +- Filter (85)
                           +- Scan csv  (43)


(1) Scan csv 
Output [3]: [Numéro Séjour#1292135, Date soins#1292138, Spécialité exécutant#1292139]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_187894/horodatage_actes_patient_Besancon_M122025.csv]
ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

(2) Filter [codegen id : 1]
Input [3]: [Numéro Séjour#1292135, Date soins#1292138, Spécialité exécutant#1292139]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER))

(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#1292135 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, Date soins#1292138 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Input [3]: [Numéro Séjour#1292135, Date soins#1292138, Spécialité exécutant#1292139]

(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440, 10), ENSURE_REQUIREMENTS, [plan_id=736773]

(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: 0

(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_187927_2d8ded9b509a530e140c956378bc6b0f/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_f0e9c180412288e9b4060131274dc89f]
PushedFilters: [IsNotNull(`Sp%C3%A9cialit%C3%A9+urgentiste+UF`)]
ReadSchema: struct<Sp%C3%A9cialit%C3%A9+etab:string,Codes+officiels:string,Sp%C3%A9cialit%C3%A9+urgentiste+UF:string>

(9) ColumnarToRow [codegen id : 2]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]

(10) Filter [codegen id : 2]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;)))

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1292276 AS LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277 AS LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, 10), ENSURE_REQUIREMENTS, [plan_id=736793]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Right keys [1]: [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492]
Join type: Inner
Join condition: None

(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]

(18) Scan csv 
Output [2]: [REGLES#1292203, APPLICABLE#1292204]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(19) Filter [codegen id : 7]
Input [2]: [REGLES#1292203, APPLICABLE#1292204]
Condition : ((isnotnull(REGLES#1292203) AND (RC-SUN-AUTO = REGLES#1292203)) AND (APPLICABLE#1292204 <=> O))

(20) Project [codegen id : 7]
Output: []
Input [2]: [REGLES#1292203, APPLICABLE#1292204]

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

(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_split(LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]

(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573]

(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573]

(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, 10), ENSURE_REQUIREMENTS, [plan_id=737207]

(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: 3

(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655 <=> 1))

(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655]

(34) Scan parquet 
Output [1]: [Finess#1292223]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_1db677b0d41d8b748205e3cc9d82b61c]
ReadSchema: struct<Finess:string>

(35) ColumnarToRow [codegen id : 12]
Input [1]: [Finess#1292223]

(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#1292223, LEFT, 2) AS 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924]
Input [1]: [Finess#1292223]

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

(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924]

(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 10), ENSURE_REQUIREMENTS, [plan_id=737371]

(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: 4

(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: coalesced

(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901 ASC NULLS FIRST], false, 0

(43) Scan csv 
Output [3]: [date#1292360, nom_jour_ferie#1292363, departement#1292364]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_187900/jours_feries_metropole.csv]
PushedFilters: [IsNotNull(date)]
ReadSchema: struct<date:string,nom_jour_ferie:string,departement:string>

(44) Filter [codegen id : 3]
Input [3]: [date#1292360, nom_jour_ferie#1292363, departement#1292364]
Condition : isnotnull(date#1292360)

(45) Project [codegen id : 3]
Output [3]: [date#1292360 AS JOURS_FERIES_ME_187979_DATE_187980#1293035, departement#1292364 AS JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, nom_jour_ferie#1292363 AS JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Input [3]: [date#1292360, nom_jour_ferie#1292363, departement#1292364]

(46) Exchange
Input [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: hashpartitioning(JOURS_FERIES_ME_187979_DATE_187980#1293035, 10), ENSURE_REQUIREMENTS, [plan_id=736833]

(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: 2

(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: coalesced

(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: [JOURS_FERIES_ME_187979_DATE_187980#1293035 ASC NULLS FIRST], false, 0

(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901]
Right keys [1]: [JOURS_FERIES_ME_187979_DATE_187980#1293035]
Join type: LeftOuter
Join condition: None

(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012, JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]

(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1293200, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129]

(53) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1293200, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088]

(54) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217], Overwrite, [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8]

(55) Filter
Input [3]: [Numéro Séjour#1292135, Date soins#1292138, Spécialité exécutant#1292139]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER))

(56) Project
Output [3]: [Numéro Séjour#1292135 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, Date soins#1292138 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1292139, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Input [3]: [Numéro Séjour#1292135, Date soins#1292138, Spécialité exécutant#1292139]

(57) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440, 10), ENSURE_REQUIREMENTS, [plan_id=736680]

(58) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440 ASC NULLS FIRST], false, 0

(59) Filter
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277, ;)))

(60) Project
Output [3]: [Codes+officiels#1292276 AS LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1292274, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277 AS LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1292274, Codes+officiels#1292276, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1292277]

(61) Exchange
Input [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, 10), ENSURE_REQUIREMENTS, [plan_id=736681]

(62) Sort
Input [3]: [LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Arguments: [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492 ASC NULLS FIRST], false, 0

(63) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440]
Right keys [1]: [LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492]
Join type: Inner
Join condition: None

(64) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1292440, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_ETAB_188048#1292492, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]

(65) Scan csv 
Output [2]: [REGLES#1292203, APPLICABLE#1292204]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(66) Filter
Input [2]: [REGLES#1292203, APPLICABLE#1292204]
Condition : ((isnotnull(REGLES#1292203) AND (RC-SUN-AUTO = REGLES#1292203)) AND (APPLICABLE#1292204 <=> O))

(67) Project
Output: []
Input [2]: [REGLES#1292203, APPLICABLE#1292204]

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

(69) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_split(LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LISTE_UF_SUN_SU_188047_CODES_OFFICIELS_188050#1292490, LISTE_UF_SUN_SU_188047_SPECIALITE_URGE_188051#1292493]

(70) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1292553), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573]

(71) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1292573]

(72) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, 10), ENSURE_REQUIREMENTS, [plan_id=736691]

(73) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

(74) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

(75) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST], false, 0

(76) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562 ASC NULLS LAST]

(77) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655 <=> 1))

(78) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1292562, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1292629, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1292738, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1292655]

(79) Scan parquet 
Output [1]: [Finess#1292223]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__187906_90bcb2880853aac1d0b4de97d0dcab75/Info_Etab_init_v1.1 CHU Besançon 310126.xlsx_1db677b0d41d8b748205e3cc9d82b61c]
ReadSchema: struct<Finess:string>

(80) Project
Output [1]: [str_extract(Finess#1292223, LEFT, 2) AS 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924]
Input [1]: [Finess#1292223]

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

(82) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 09_INFORMATION__188042_DEPARTEMENTETAB_188046#1292924]

(83) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, 10), ENSURE_REQUIREMENTS, [plan_id=736705]

(84) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901 ASC NULLS FIRST], false, 0

(85) Filter
Input [3]: [date#1292360, nom_jour_ferie#1292363, departement#1292364]
Condition : isnotnull(date#1292360)

(86) Project
Output [3]: [date#1292360 AS JOURS_FERIES_ME_187979_DATE_187980#1293035, departement#1292364 AS JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, nom_jour_ferie#1292363 AS JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Input [3]: [date#1292360, nom_jour_ferie#1292363, departement#1292364]

(87) Exchange
Input [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: hashpartitioning(JOURS_FERIES_ME_187979_DATE_187980#1293035, 10), ENSURE_REQUIREMENTS, [plan_id=736706]

(88) Sort
Input [3]: [JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]
Arguments: [JOURS_FERIES_ME_187979_DATE_187980#1293035 ASC NULLS FIRST], false, 0

(89) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901]
Right keys [1]: [JOURS_FERIES_ME_187979_DATE_187980#1293035]
Join type: LeftOuter
Join condition: None

(90) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1292439, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1292901, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1293012, JOURS_FERIES_ME_187979_DATE_187980#1293035, JOURS_FERIES_ME_187979_DEPARTEMENT_187984#1293036, JOURS_FERIES_ME_187979_NOM_JOUR_FERIE_187983#1293037]

(91) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1293200, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1292899, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1292900, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1293087, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1293108, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1293129]

(92) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1292436, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1292545, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1293200, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1293088]

(93) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_188217], Overwrite, [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8]

(94) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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