SP1 - Details for Query 5155

Submitted Time: 2026/03/25 16:53:55
Duration: 2 s
Succeeded Jobs: 7813 7814 7815 7817 7818 7820

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: 9 ms number of output rows: 36,518 number of dynamic part: 0 written output: 202.6 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 366 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 36,518 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 432 ms"; 8 [labelType="html" label="Sort sort time: 6 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 721.3 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 36,518 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: 36,518 local bytes read: 685.5 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: 5.0 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 685.5 KiB"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 219 ms"; 12 [labelType="html" label=" Project "]; } 13 [labelType="html" label="CartesianProduct number of output rows: 36,518"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 219 ms"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 36,518"]; } 17 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 265 ms"; 19 [labelType="html" label="Sort sort time: 1 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 20 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster21 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 81 ms"; 22 [labelType="html" label="Sort sort time: 7 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 914.4 KiB number of coalesced partitions: 1"]; 24 [labelType="html" label="Exchange shuffle records written: 44,963 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: 44,963 local bytes read: 892.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: 4.5 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 892.3 KiB"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 433 ms"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Generate number of output rows: 44,963"]; 28 [labelType="html" label=" Project "]; } 29 [labelType="html" label="CartesianProduct number of output rows: 44,963"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 434 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="SortMergeJoin number of output rows: 44,963 spill size: 0.0 B"]; } subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 34 [labelType="html" label="Sort sort time: 39 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1082.5 KiB number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 85,710 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (2 ms, 5 ms, 5 ms (stage 14672.0: task 20358)) 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: 85,710 local bytes read: 1036.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 7.0 MiB (212.6 KiB, 6.8 MiB, 6.8 MiB (stage 14672.0: task 20358)) 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)) 1036.9 KiB (30.9 KiB, 1005.9 KiB, 1005.9 KiB (stage 14672.0: task 20358))"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n688 ms (54 ms, 634 ms, 634 ms (stage 14672.0: task 20358))"; 38 [labelType="html" label=" Project "]; 39 [labelType="html" label="Filter number of output rows: 85,710"]; } 40 [labelType="html" label="Scan csv number of output rows: 85,895 number of files read: 1 metadata time: 0 ms size of files read: 4.1 MiB"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 836 ms"; 42 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 43 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 365.0 B number of coalesced partitions: 1"]; 44 [labelType="html" label="Exchange shuffle records written: 4 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: 4 local bytes read: 345.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: 256.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: 345.0 B"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 8 ms"; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label="Filter number of output rows: 4"]; 48 [labelType="html" label="ColumnarToRow number of output rows: 36 number of input batches: 1"]; } 49 [labelType="html" label="Scan parquet number of files read: 1 scan time: 5 ms metadata time: 0 ms size of files read: 3.0 KiB number of output rows: 36"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 17 ms"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label="Filter number of output rows: 1"]; } 53 [labelType="html" label="Scan csv number of output rows: 1 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: 2 ms"; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label="ColumnarToRow number of output rows: 1 number of input batches: 1"]; } 57 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 2.1 KiB number of output rows: 1"]; 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: 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: 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_176023, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023], 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#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141434, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363]

SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084], [JOURS_FERIES_ME_175758_DATE_175759#1141269], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 10), ENSURE_REQUIREMENTS, [plan_id=588217]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]

WholeStageCodegen (13)

CartesianProduct

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084]

Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744 <=> 1))

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, 10), ENSURE_REQUIREMENTS, [plan_id=588053]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551]

WholeStageCodegen (8)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386], [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459], Inner

WholeStageCodegen (6)

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386, 10), ENSURE_REQUIREMENTS, [plan_id=587597]

Project [Numéro Séjour#1137427 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, Date soins#1137430 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1137431, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]

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

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1137427,Date soins#1137430,Spécialité exécutant#1137431] 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_175673/horodatage_actes..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

Sort [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, 10), ENSURE_REQUIREMENTS, [plan_id=587617]

Project [Codes+officiels#1138543 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1138541, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]

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

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#1138541,Codes+officiels#1138543,Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544] Batched: true, DataFilters: [isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544), isnotnull(str_replace_extend(str_transfor..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_175706_4f5cbb28add8..., 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#1137495) AND (RC-SUN-AUTO = REGLES#1137495)) AND (APPLICABLE#1137496 <=> O))

WholeStageCodegen (7)

FileScan csv [REGLES#1137495,APPLICABLE#1137496] Batched: false, DataFilters: [isnotnull(REGLES#1137495), (RC-SUN-AUTO = REGLES#1137495), (APPLICABLE#1137496 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/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#1137550, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127]

ColumnarToRow

WholeStageCodegen (12)

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

Sort [JOURS_FERIES_ME_175758_DATE_175759#1141269 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1141269, 10), ENSURE_REQUIREMENTS, [plan_id=587657]

Project [date#1140286 AS JOURS_FERIES_ME_175758_DATE_175759#1141269, departement#1140290 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, nom_jour_ferie#1140289 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]

Filter isnotnull(date#1140286)

WholeStageCodegen (3)

FileScan csv [date#1140286,nom_jour_ferie#1140289,departement#1140290] Batched: false, DataFilters: [isnotnull(date#1140286)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_175679/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=5.0 MiB, rowCount=3.65E+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=4.5 MiB, rowCount=4.50E+4)
               :                 :                       +- Exchange (25)
               :                 :                          +- * Project (24)
               :                 :                             +- * Generate (23)
               :                 :                                +- * Project (22)
               :                 :                                   +- CartesianProduct Inner (21)
               :                 :                                      :- * Project (17)
               :                 :                                      :  +- * SortMergeJoin Inner (16)
               :                 :                                      :     :- * Sort (7)
               :                 :                                      :     :  +- AQEShuffleRead (6)
               :                 :                                      :     :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=7.0 MiB, rowCount=8.57E+4)
               :                 :                                      :     :        +- Exchange (4)
               :                 :                                      :     :           +- * Project (3)
               :                 :                                      :     :              +- * Filter (2)
               :                 :                                      :     :                 +- Scan csv  (1)
               :                 :                                      :     +- * Sort (15)
               :                 :                                      :        +- AQEShuffleRead (14)
               :                 :                                      :           +- ShuffleQueryStage (13), Statistics(sizeInBytes=256.0 B, rowCount=4)
               :                 :                                      :              +- 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#1137427, Date soins#1137430, Spécialité exécutant#1137431]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_175673/horodatage_actes_Patient_Grasse_2025.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#1137427, Date soins#1137430, Spécialité exécutant#1137431]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1137431, ONLY_ONE), [ ], [-])), UPPER))

(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#1137427 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, Date soins#1137430 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1137431, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Input [3]: [Numéro Séjour#1137427, Date soins#1137430, Spécialité exécutant#1137431]

(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386, 10), ENSURE_REQUIREMENTS, [plan_id=587597]

(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: 0

(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1138541, Codes+officiels#1138543, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_175706_4f5cbb28add8b3253e8c4d59893ce285/Info_Etab_init_v1.1 GRASSE 280126v2.xlsx_348c7fdd3a4ab3b15ed2239bebf0d645]
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#1138541, Codes+officiels#1138543, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544]

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

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1138543 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1138541, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1138541, Codes+officiels#1138543, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, 10), ENSURE_REQUIREMENTS, [plan_id=587617]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Right keys [1]: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459]
Join type: Inner
Join condition: None

(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]

(18) Scan csv 
Output [2]: [REGLES#1137495, APPLICABLE#1137496]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_175682/REGLES-A-TTT new GRASSE 290126.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#1137495, APPLICABLE#1137496]
Condition : ((isnotnull(REGLES#1137495) AND (RC-SUN-AUTO = REGLES#1137495)) AND (APPLICABLE#1137496 <=> O))

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

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

(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]

(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585]

(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585]

(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, 10), ENSURE_REQUIREMENTS, [plan_id=588053]

(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: 3

(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744 <=> 1))

(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744]

(34) Scan parquet 
Output [1]: [Finess#1137550]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__175685_a7a13892c13ea2ed5e0a5452c6fe62f1/Info_Etab_init_v1.1 GRASSE 280126v2.xlsx_e3317d2d66b89b01957036401b4c27f2]
ReadSchema: struct<Finess:string>

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

(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#1137550, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127]
Input [1]: [Finess#1137550]

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

(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127]

(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 10), ENSURE_REQUIREMENTS, [plan_id=588217]

(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: 4

(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: coalesced

(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084 ASC NULLS FIRST], false, 0

(43) Scan csv 
Output [3]: [date#1140286, nom_jour_ferie#1140289, departement#1140290]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_175679/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#1140286, nom_jour_ferie#1140289, departement#1140290]
Condition : isnotnull(date#1140286)

(45) Project [codegen id : 3]
Output [3]: [date#1140286 AS JOURS_FERIES_ME_175758_DATE_175759#1141269, departement#1140290 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, nom_jour_ferie#1140289 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Input [3]: [date#1140286, nom_jour_ferie#1140289, departement#1140290]

(46) Exchange
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1141269, 10), ENSURE_REQUIREMENTS, [plan_id=587657]

(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: 2

(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: coalesced

(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: [JOURS_FERIES_ME_175758_DATE_175759#1141269 ASC NULLS FIRST], false, 0

(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084]
Right keys [1]: [JOURS_FERIES_ME_175758_DATE_175759#1141269]
Join type: LeftOuter
Join condition: None

(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246, JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]

(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141434, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363]

(53) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141434, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322]

(54) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023], 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#1137427, Date soins#1137430, Spécialité exécutant#1137431]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1137431, ONLY_ONE), [ ], [-])), UPPER))

(56) Project
Output [3]: [Numéro Séjour#1137427 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, Date soins#1137430 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1137431, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Input [3]: [Numéro Séjour#1137427, Date soins#1137430, Spécialité exécutant#1137431]

(57) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386, 10), ENSURE_REQUIREMENTS, [plan_id=587504]

(58) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386 ASC NULLS FIRST], false, 0

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

(60) Project
Output [3]: [Codes+officiels#1138543 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1138541, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1138541, Codes+officiels#1138543, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1138544]

(61) Exchange
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, 10), ENSURE_REQUIREMENTS, [plan_id=587505]

(62) Sort
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Arguments: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459 ASC NULLS FIRST], false, 0

(63) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386]
Right keys [1]: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459]
Join type: Inner
Join condition: None

(64) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1140386, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1140459, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]

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

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

(67) Project
Output: []
Input [2]: [REGLES#1137495, APPLICABLE#1137496]

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

(69) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1140457, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1140460]

(70) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1140542), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585]

(71) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1140585]

(72) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, 10), ENSURE_REQUIREMENTS, [plan_id=587515]

(73) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

(74) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

(75) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST], false, 0

(76) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551 ASC NULLS LAST]

(77) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744 <=> 1))

(78) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1140551, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1140682, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1140860, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1140744]

(79) Scan parquet 
Output [1]: [Finess#1137550]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__175685_a7a13892c13ea2ed5e0a5452c6fe62f1/Info_Etab_init_v1.1 GRASSE 280126v2.xlsx_e3317d2d66b89b01957036401b4c27f2]
ReadSchema: struct<Finess:string>

(80) Project
Output [1]: [str_extract(Finess#1137550, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127]
Input [1]: [Finess#1137550]

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

(82) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1141127]

(83) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, 10), ENSURE_REQUIREMENTS, [plan_id=587529]

(84) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084 ASC NULLS FIRST], false, 0

(85) Filter
Input [3]: [date#1140286, nom_jour_ferie#1140289, departement#1140290]
Condition : isnotnull(date#1140286)

(86) Project
Output [3]: [date#1140286 AS JOURS_FERIES_ME_175758_DATE_175759#1141269, departement#1140290 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, nom_jour_ferie#1140289 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Input [3]: [date#1140286, nom_jour_ferie#1140289, departement#1140290]

(87) Exchange
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1141269, 10), ENSURE_REQUIREMENTS, [plan_id=587530]

(88) Sort
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]
Arguments: [JOURS_FERIES_ME_175758_DATE_175759#1141269 ASC NULLS FIRST], false, 0

(89) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084]
Right keys [1]: [JOURS_FERIES_ME_175758_DATE_175759#1141269]
Join type: LeftOuter
Join condition: None

(90) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1140385, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1141084, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1141246, JOURS_FERIES_ME_175758_DATE_175759#1141269, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1141270, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1141271]

(91) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141434, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1141082, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1141083, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1141321, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1141342, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1141363]

(92) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1140382, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1140534, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141434, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1141322]

(93) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_176023], 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