SP1 - Details for Query 11298

Submitted Time: 2026/01/24 15:02:59
Duration: 3 s
Succeeded Jobs: 16762 16763 16764 16768 16770 16771

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: 0 ms number of written files: 1 job commit time: 10 ms number of output rows: 4,922 number of dynamic part: 0 written output: 30.9 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 88 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 4,922 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 158 ms"; 8 [labelType="html" label="Sort sort time: 2 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 114.3 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 4,922 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: 4,922 local bytes read: 109.0 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 692.2 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 109.0 KiB"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 31 ms"; 12 [labelType="html" label=" Project "]; } 13 [labelType="html" label="CartesianProduct number of output rows: 4,922"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 32 ms"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 4,922"]; } 17 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 42 ms"; 19 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.3 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: 16 ms"; 22 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 120.1 KiB number of coalesced partitions: 1"]; 24 [labelType="html" label="Exchange shuffle records written: 8,098 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,098 local bytes read: 115.4 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 885.7 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: 115.4 KiB"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 291 ms"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Generate number of output rows: 8,098"]; 28 [labelType="html" label=" Project "]; } 29 [labelType="html" label="CartesianProduct number of output rows: 8,098"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 291 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="SortMergeJoin number of output rows: 8,098 spill size: 0.0 B"]; } subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 34 [labelType="html" label="Sort sort time: 38 ms peak memory: 64.0 MiB spill size: 0.0 B"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1658.3 KiB number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 453,233 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 22 ms (2 ms, 2 ms, 3 ms (stage 30399.0: task 36116)) 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: 453,233 local bytes read: 1577.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 9 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 46.2 MiB (4.9 MiB, 5.2 MiB, 5.3 MiB (stage 30399.0: task 36105)) 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)) 1577.2 KiB (135.4 KiB, 185.1 KiB, 189.4 KiB (stage 30399.0: task 36101))"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n4.5 s (402 ms, 481 ms, 755 ms (stage 30399.0: task 36116))"; 38 [labelType="html" label=" Project "]; 39 [labelType="html" label="Filter number of output rows: 453,233"]; } 40 [labelType="html" label="Scan csv number of output rows: 591,883 number of files read: 1 metadata time: 0 ms size of files read: 35.9 MiB"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 523 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: 97.0 B number of coalesced partitions: 1"]; 44 [labelType="html" label="Exchange shuffle records written: 1 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 96.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: 72.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: 96.0 B"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 5 ms"; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label="Filter number of output rows: 1"]; 48 [labelType="html" label="ColumnarToRow number of output rows: 24 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.1 KiB number of output rows: 24"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 3 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: 163.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: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 52 local bytes read: 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: 4 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_161611, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_161611], 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#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#2313265, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194]

SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966], [JOURS_FERIES_ME_161487_DATE_161488#2313100], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 10), ENSURE_REQUIREMENTS, [plan_id=1141830]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]

WholeStageCodegen (13)

CartesianProduct

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966]

Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720 <=> 1))

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, 10), ENSURE_REQUIREMENTS, [plan_id=1141654]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_split(LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627]

WholeStageCodegen (8)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505], [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557], Inner

WholeStageCodegen (6)

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505, 10), ENSURE_REQUIREMENTS, [plan_id=1140952]

Project [Numéro Séjour#2311587 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, Date soins#2311590 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#2311591, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]

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

WholeStageCodegen (1)

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

Sort [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, 10), ENSURE_REQUIREMENTS, [plan_id=1140972]

Project [Codes+officiels#2312083 AS LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#2312081, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084 AS LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]

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

ColumnarToRow

WholeStageCodegen (2)

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

WholeStageCodegen (7)

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

Project [str_extract(Finess#2311917, LEFT, 2) AS 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989]

ColumnarToRow

WholeStageCodegen (12)

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

Sort [JOURS_FERIES_ME_161487_DATE_161488#2313100 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_161487_DATE_161488#2313100, 10), ENSURE_REQUIREMENTS, [plan_id=1141012]

Project [date#2312425 AS JOURS_FERIES_ME_161487_DATE_161488#2313100, departement#2312429 AS JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, nom_jour_ferie#2312428 AS JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]

Filter isnotnull(date#2312425)

WholeStageCodegen (3)

FileScan csv [date#2312425,nom_jour_ferie#2312428,departement#2312429] Batched: false, DataFilters: [isnotnull(date#2312425)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_161408/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=692.2 KiB, rowCount=4.92E+3)
               :        +- 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=885.7 KiB, rowCount=8.10E+3)
               :                 :                       +- Exchange (25)
               :                 :                          +- * Project (24)
               :                 :                             +- * Generate (23)
               :                 :                                +- * Project (22)
               :                 :                                   +- CartesianProduct Inner (21)
               :                 :                                      :- * Project (17)
               :                 :                                      :  +- * SortMergeJoin Inner (16)
               :                 :                                      :     :- * Sort (7)
               :                 :                                      :     :  +- AQEShuffleRead (6)
               :                 :                                      :     :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=46.2 MiB, rowCount=4.53E+5)
               :                 :                                      :     :        +- Exchange (4)
               :                 :                                      :     :           +- * Project (3)
               :                 :                                      :     :              +- * Filter (2)
               :                 :                                      :     :                 +- Scan csv  (1)
               :                 :                                      :     +- * Sort (15)
               :                 :                                      :        +- AQEShuffleRead (14)
               :                 :                                      :           +- ShuffleQueryStage (13), Statistics(sizeInBytes=72.0 B, rowCount=1)
               :                 :                                      :              +- 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#2311587, Date soins#2311590, Spécialité exécutant#2311591]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_161402/horodatage_actes_Patient_VERSAILLES_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#2311587, Date soins#2311590, Spécialité exécutant#2311591]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#2311591, ONLY_ONE), [ ], [-])), UPPER))

(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#2311587 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, Date soins#2311590 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#2311591, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Input [3]: [Numéro Séjour#2311587, Date soins#2311590, Spécialité exécutant#2311591]

(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505, 10), ENSURE_REQUIREMENTS, [plan_id=1140952]

(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: 0

(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#2312081, Codes+officiels#2312083, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_161435_3bd91559ea9fa05b0cc54dc64e2d2c25/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_25627045fa09349062229bff6b20a5ea]
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#2312081, Codes+officiels#2312083, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084]

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

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#2312083 AS LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#2312081, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084 AS LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#2312081, Codes+officiels#2312083, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, 10), ENSURE_REQUIREMENTS, [plan_id=1140972]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Right keys [1]: [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557]
Join type: Inner
Join condition: None

(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]

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

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

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

(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_split(LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]

(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638]

(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638]

(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, 10), ENSURE_REQUIREMENTS, [plan_id=1141654]

(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: 3

(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720 <=> 1))

(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720]

(34) Scan parquet 
Output [1]: [Finess#2311917]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__161414_08437267f14eaeea5155ff0547c9894a/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_76bfdf777744bb35a959e1cebfa7679b]
ReadSchema: struct<Finess:string>

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

(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#2311917, LEFT, 2) AS 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989]
Input [1]: [Finess#2311917]

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

(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989]

(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 10), ENSURE_REQUIREMENTS, [plan_id=1141830]

(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: 4

(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: coalesced

(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966 ASC NULLS FIRST], false, 0

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

(45) Project [codegen id : 3]
Output [3]: [date#2312425 AS JOURS_FERIES_ME_161487_DATE_161488#2313100, departement#2312429 AS JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, nom_jour_ferie#2312428 AS JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Input [3]: [date#2312425, nom_jour_ferie#2312428, departement#2312429]

(46) Exchange
Input [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: hashpartitioning(JOURS_FERIES_ME_161487_DATE_161488#2313100, 10), ENSURE_REQUIREMENTS, [plan_id=1141012]

(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: 2

(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: coalesced

(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: [JOURS_FERIES_ME_161487_DATE_161488#2313100 ASC NULLS FIRST], false, 0

(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966]
Right keys [1]: [JOURS_FERIES_ME_161487_DATE_161488#2313100]
Join type: LeftOuter
Join condition: None

(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077, JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]

(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#2313265, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194]

(53) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#2313265, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153]

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

(56) Project
Output [3]: [Numéro Séjour#2311587 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, Date soins#2311590 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#2311591, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Input [3]: [Numéro Séjour#2311587, Date soins#2311590, Spécialité exécutant#2311591]

(57) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505, 10), ENSURE_REQUIREMENTS, [plan_id=1140859]

(58) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505 ASC NULLS FIRST], false, 0

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

(60) Project
Output [3]: [Codes+officiels#2312083 AS LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#2312081, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084 AS LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#2312081, Codes+officiels#2312083, Sp%C3%A9cialit%C3%A9+urgentiste+UF#2312084]

(61) Exchange
Input [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, 10), ENSURE_REQUIREMENTS, [plan_id=1140860]

(62) Sort
Input [3]: [LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Arguments: [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557 ASC NULLS FIRST], false, 0

(63) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505]
Right keys [1]: [LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557]
Join type: Inner
Join condition: None

(64) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#2312505, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_ETAB_161555#2312557, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]

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

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

(67) Project
Output: []
Input [2]: [REGLES#2311716, APPLICABLE#2311717]

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

(69) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_split(LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LISTE_UF_SUN_SU_161554_CODES_OFFICIELS_161557#2312555, LISTE_UF_SUN_SU_161554_SPECIALITE_URGE_161558#2312558]

(70) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#2312618), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638]

(71) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#2312638]

(72) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, 10), ENSURE_REQUIREMENTS, [plan_id=1140870]

(73) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

(74) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

(75) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST], false, 0

(76) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627 ASC NULLS LAST]

(77) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720 <=> 1))

(78) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#2312627, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#2312694, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#2312803, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#2312720]

(79) Scan parquet 
Output [1]: [Finess#2311917]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__161414_08437267f14eaeea5155ff0547c9894a/Info_Etab_init_v1.1 VERSAILLES 230126.xlsx_76bfdf777744bb35a959e1cebfa7679b]
ReadSchema: struct<Finess:string>

(80) Project
Output [1]: [str_extract(Finess#2311917, LEFT, 2) AS 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989]
Input [1]: [Finess#2311917]

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

(82) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 09_INFORMATION__161549_DEPARTEMENTETAB_161553#2312989]

(83) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, 10), ENSURE_REQUIREMENTS, [plan_id=1140884]

(84) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966 ASC NULLS FIRST], false, 0

(85) Filter
Input [3]: [date#2312425, nom_jour_ferie#2312428, departement#2312429]
Condition : isnotnull(date#2312425)

(86) Project
Output [3]: [date#2312425 AS JOURS_FERIES_ME_161487_DATE_161488#2313100, departement#2312429 AS JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, nom_jour_ferie#2312428 AS JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Input [3]: [date#2312425, nom_jour_ferie#2312428, departement#2312429]

(87) Exchange
Input [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: hashpartitioning(JOURS_FERIES_ME_161487_DATE_161488#2313100, 10), ENSURE_REQUIREMENTS, [plan_id=1140885]

(88) Sort
Input [3]: [JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]
Arguments: [JOURS_FERIES_ME_161487_DATE_161488#2313100 ASC NULLS FIRST], false, 0

(89) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966]
Right keys [1]: [JOURS_FERIES_ME_161487_DATE_161488#2313100]
Join type: LeftOuter
Join condition: None

(90) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#2312504, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#2312966, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#2313077, JOURS_FERIES_ME_161487_DATE_161488#2313100, JOURS_FERIES_ME_161487_DEPARTEMENT_161492#2313101, JOURS_FERIES_ME_161487_NOM_JOUR_FERIE_161491#2313102]

(91) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#2313265, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#2312964, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#2312965, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#2313152, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#2313173, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#2313194]

(92) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#2312501, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#2312610, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#2313265, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#2313153]

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