digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 11 ms<br>number of output rows: 36,518<br>number of dynamic part: 0<br>written output: 202.6 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (16)\n \nduration: 491 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 36,518<br>spill size: 0.0 B"];
}
subgraph cluster7 {
isCluster="true";
label="WholeStageCodegen (14)\n \nduration: 582 ms";
8 [labelType="html" label="<b>Sort</b><br><br>sort time: 7 ms<br>peak memory: 17.0 MiB<br>spill size: 0.0 B"];
}
9 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 721.3 KiB<br>number of coalesced partitions: 1"];
10 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 36,518<br>local merged chunks fetched: 0<br>shuffle write time: 3 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 36,518<br>local bytes read: 685.5 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 5.0 MiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 685.5 KiB"];
subgraph cluster11 {
isCluster="true";
label="WholeStageCodegen (13)\n \nduration: 321 ms";
12 [labelType="html" label="<br><b>Project</b><br><br>"];
}
13 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 36,518"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 321 ms";
15 [labelType="html" label="<br><b>Project</b><br><br>"];
16 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 36,518"];
}
17 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 387 ms";
19 [labelType="html" label="<b>Sort</b><br><br>sort time: 1 ms<br>peak memory: 18.0 MiB<br>spill size: 0.0 B"];
}
20 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 92 ms";
22 [labelType="html" label="<b>Sort</b><br><br>sort time: 5 ms<br>peak memory: 18.0 MiB<br>spill size: 0.0 B"];
}
23 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 914.4 KiB<br>number of coalesced partitions: 1"];
24 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 44,963<br>local merged chunks fetched: 0<br>shuffle write time: 3 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 44,963<br>local bytes read: 892.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 4.5 MiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 892.3 KiB"];
subgraph cluster25 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 420 ms";
26 [labelType="html" label="<br><b>Project</b><br><br>"];
27 [labelType="html" label="<b>Generate</b><br><br>number of output rows: 44,963"];
28 [labelType="html" label="<br><b>Project</b><br><br>"];
}
29 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 44,963"];
subgraph cluster30 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 420 ms";
31 [labelType="html" label="<br><b>Project</b><br><br>"];
32 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 44,963<br>spill size: 0.0 B"];
}
subgraph cluster33 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 0 ms";
34 [labelType="html" label="<b>Sort</b><br><br>sort time: 10 ms<br>peak memory: 18.0 MiB<br>spill size: 0.0 B"];
}
35 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 1082.5 KiB<br>number of coalesced partitions: 1"];
36 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 85,710<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>6 ms (1 ms, 4 ms, 4 ms (stage 15574.0: task 21512))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 85,710<br>local bytes read: 1036.9 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>7.0 MiB (212.6 KiB, 6.8 MiB, 6.8 MiB (stage 15574.0: task 21512))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>1036.9 KiB (30.9 KiB, 1005.9 KiB, 1005.9 KiB (stage 15574.0: task 21512))"];
subgraph cluster37 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n429 ms (21 ms, 408 ms, 408 ms (stage 15574.0: task 21512))";
38 [labelType="html" label="<br><b>Project</b><br><br>"];
39 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 85,710"];
}
40 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 85,895<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 4.1 MiB"];
subgraph cluster41 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 797 ms";
42 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
43 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 365.0 B<br>number of coalesced partitions: 1"];
44 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 4<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 4<br>local bytes read: 345.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 256.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 345.0 B"];
subgraph cluster45 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 4 ms";
46 [labelType="html" label="<br><b>Project</b><br><br>"];
47 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 4"];
48 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 36<br>number of input batches: 1"];
}
49 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 3.0 KiB<br>number of output rows: 36"];
subgraph cluster50 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 6 ms";
51 [labelType="html" label="<br><b>Project</b><br><br>"];
52 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
}
53 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 1<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.0 B"];
subgraph cluster54 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: 4 ms";
55 [labelType="html" label="<br><b>Project</b><br><br>"];
56 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1<br>number of input batches: 1"];
}
57 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 2.1 KiB<br>number of output rows: 1"];
subgraph cluster58 {
isCluster="true";
label="WholeStageCodegen (15)\n \nduration: 0 ms";
59 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
60 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 2.4 KiB<br>number of coalesced partitions: 1"];
61 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 52<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 52<br>local bytes read: 2.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 3.6 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 2.3 KiB"];
subgraph cluster62 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 7 ms";
63 [labelType="html" label="<br><b>Project</b><br><br>"];
64 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 52"];
}
65 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 52<br>number of files read: 1<br>metadata time: 0 ms<br>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;
}
66
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#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1213456, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344]
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385]
SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157], [JOURS_FERIES_ME_175758_DATE_175759#1213291], LeftOuter
WholeStageCodegen (16)
Sort [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157 ASC NULLS FIRST], false, 0
WholeStageCodegen (14)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 10), ENSURE_REQUIREMENTS, [plan_id=680510]
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
WholeStageCodegen (13)
CartesianProduct
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157]
Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911 <=> 1))
WholeStageCodegen (11)
Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
WholeStageCodegen (10)
Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
WholeStageCodegen (9)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, 10), ENSURE_REQUIREMENTS, [plan_id=680324]
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829]
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818]
WholeStageCodegen (8)
CartesianProduct
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696], [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748], Inner
WholeStageCodegen (6)
Sort [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696 ASC NULLS FIRST], false, 0
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696, 10), ENSURE_REQUIREMENTS, [plan_id=679733]
Project [Numéro Séjour#1210928 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, Date soins#1210931 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Filter isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER))
WholeStageCodegen (1)
FileScan csv [Numéro Séjour#1210928,Date soins#1210931,Spécialité exécutant#1210932] 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#1212748 ASC NULLS FIRST], false, 0
WholeStageCodegen (5)
AQEShuffleRead coalesced
Exchange hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, 10), ENSURE_REQUIREMENTS, [plan_id=679753]
Project [Codes+officiels#1211484 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Filter (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;)))
ColumnarToRow
WholeStageCodegen (2)
FileScan parquet [Sp%C3%A9cialit%C3%A9+etab#1211482,Codes+officiels#1211484,Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485] Batched: true, DataFilters: [isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485), 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#1211169) AND (RC-SUN-AUTO = REGLES#1211169)) AND (APPLICABLE#1211170 <=> O))
WholeStageCodegen (7)
FileScan csv [REGLES#1211169,APPLICABLE#1211170] Batched: false, DataFilters: [isnotnull(REGLES#1211169), (RC-SUN-AUTO = REGLES#1211169), (APPLICABLE#1211170 <=> 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#1211224, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180]
ColumnarToRow
WholeStageCodegen (12)
FileScan parquet [Finess#1211224] 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#1213291 ASC NULLS FIRST], false, 0
WholeStageCodegen (15)
AQEShuffleRead coalesced
Exchange hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1213291, 10), ENSURE_REQUIREMENTS, [plan_id=679793]
Project [date#1212616 AS JOURS_FERIES_ME_175758_DATE_175759#1213291, departement#1212620 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, nom_jour_ferie#1212619 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Filter isnotnull(date#1212616)
WholeStageCodegen (3)
FileScan csv [date#1212616,nom_jour_ferie#1212619,departement#1212620] Batched: false, DataFilters: [isnotnull(date#1212616)], 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>
== 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#1210928, Date soins#1210931, Spécialité exécutant#1210932]
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#1210928, Date soins#1210931, Spécialité exécutant#1210932]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER))
(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#1210928 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, Date soins#1210931 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Input [3]: [Numéro Séjour#1210928, Date soins#1210931, Spécialité exécutant#1210932]
(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696, 10), ENSURE_REQUIREMENTS, [plan_id=679733]
(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: 0
(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: coalesced
(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696 ASC NULLS FIRST], false, 0
(8) Scan parquet
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
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#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
(10) Filter [codegen id : 2]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;)))
(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1211484 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, 10), ENSURE_REQUIREMENTS, [plan_id=679753]
(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: 1
(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: coalesced
(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748 ASC NULLS FIRST], false, 0
(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Right keys [1]: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748]
Join type: Inner
Join condition: None
(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
(18) Scan csv
Output [2]: [REGLES#1211169, APPLICABLE#1211170]
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#1211169, APPLICABLE#1211170]
Condition : ((isnotnull(REGLES#1211169) AND (RC-SUN-AUTO = REGLES#1211169)) AND (APPLICABLE#1211170 <=> O))
(20) Project [codegen id : 7]
Output: []
Input [2]: [REGLES#1211169, APPLICABLE#1211170]
(21) CartesianProduct
Join type: Inner
Join condition: None
(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829]
(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829]
(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, 10), ENSURE_REQUIREMENTS, [plan_id=680324]
(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: 3
(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: coalesced
(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911 <=> 1))
(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911]
(34) Scan parquet
Output [1]: [Finess#1211224]
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#1211224]
(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#1211224, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180]
Input [1]: [Finess#1211224]
(37) CartesianProduct
Join type: Inner
Join condition: None
(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180]
(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 10), ENSURE_REQUIREMENTS, [plan_id=680510]
(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: 4
(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: coalesced
(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157 ASC NULLS FIRST], false, 0
(43) Scan csv
Output [3]: [date#1212616, nom_jour_ferie#1212619, departement#1212620]
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#1212616, nom_jour_ferie#1212619, departement#1212620]
Condition : isnotnull(date#1212616)
(45) Project [codegen id : 3]
Output [3]: [date#1212616 AS JOURS_FERIES_ME_175758_DATE_175759#1213291, departement#1212620 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, nom_jour_ferie#1212619 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Input [3]: [date#1212616, nom_jour_ferie#1212619, departement#1212620]
(46) Exchange
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1213291, 10), ENSURE_REQUIREMENTS, [plan_id=679793]
(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: 2
(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: coalesced
(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: [JOURS_FERIES_ME_175758_DATE_175759#1213291 ASC NULLS FIRST], false, 0
(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157]
Right keys [1]: [JOURS_FERIES_ME_175758_DATE_175759#1213291]
Join type: LeftOuter
Join condition: None
(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268, JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1213456, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385]
(53) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1213456, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344]
(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#1210928, Date soins#1210931, Spécialité exécutant#1210932]
Condition : isnotnull(str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER))
(56) Project
Output [3]: [Numéro Séjour#1210928 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, Date soins#1210931 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1210932, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Input [3]: [Numéro Séjour#1210928, Date soins#1210931, Spécialité exécutant#1210932]
(57) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696, 10), ENSURE_REQUIREMENTS, [plan_id=679640]
(58) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696 ASC NULLS FIRST], false, 0
(59) Filter
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
Condition : (((isnotnull(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485) AND isnotnull(str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]))) AND (size(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;), true) > 0)) AND isnotnull(str_split(Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485, ;)))
(60) Project
Output [3]: [Codes+officiels#1211484 AS LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1211482, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485 AS LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1211482, Codes+officiels#1211484, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1211485]
(61) Exchange
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, 10), ENSURE_REQUIREMENTS, [plan_id=679641]
(62) Sort
Input [3]: [LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Arguments: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748 ASC NULLS FIRST], false, 0
(63) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696]
Right keys [1]: [LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748]
Join type: Inner
Join condition: None
(64) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1212696, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_ETAB_175827#1212748, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
(65) Scan csv
Output [2]: [REGLES#1211169, APPLICABLE#1211170]
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#1211169, APPLICABLE#1211170]
Condition : ((isnotnull(REGLES#1211169) AND (RC-SUN-AUTO = REGLES#1211169)) AND (APPLICABLE#1211170 <=> O))
(67) Project
Output: []
Input [2]: [REGLES#1211169, APPLICABLE#1211170]
(68) CartesianProduct
Join type: Inner
Join condition: None
(69) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_split(LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LISTE_UF_SUN_SU_175826_CODES_OFFICIELS_175829#1212746, LISTE_UF_SUN_SU_175826_SPECIALITE_URGE_175830#1212749]
(70) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1212809), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829]
(71) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1212829]
(72) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, 10), ENSURE_REQUIREMENTS, [plan_id=679651]
(73) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
(74) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
(75) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST], false, 0
(76) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818 ASC NULLS LAST]
(77) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911 <=> 1))
(78) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1212818, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1212885, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1212994, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1212911]
(79) Scan parquet
Output [1]: [Finess#1211224]
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#1211224, LEFT, 2) AS 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180]
Input [1]: [Finess#1211224]
(81) CartesianProduct
Join type: Inner
Join condition: None
(82) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 09_INFORMATION__175821_DEPARTEMENTETAB_175825#1213180]
(83) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, 10), ENSURE_REQUIREMENTS, [plan_id=679665]
(84) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157 ASC NULLS FIRST], false, 0
(85) Filter
Input [3]: [date#1212616, nom_jour_ferie#1212619, departement#1212620]
Condition : isnotnull(date#1212616)
(86) Project
Output [3]: [date#1212616 AS JOURS_FERIES_ME_175758_DATE_175759#1213291, departement#1212620 AS JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, nom_jour_ferie#1212619 AS JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Input [3]: [date#1212616, nom_jour_ferie#1212619, departement#1212620]
(87) Exchange
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: hashpartitioning(JOURS_FERIES_ME_175758_DATE_175759#1213291, 10), ENSURE_REQUIREMENTS, [plan_id=679666]
(88) Sort
Input [3]: [JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
Arguments: [JOURS_FERIES_ME_175758_DATE_175759#1213291 ASC NULLS FIRST], false, 0
(89) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157]
Right keys [1]: [JOURS_FERIES_ME_175758_DATE_175759#1213291]
Join type: LeftOuter
Join condition: None
(90) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1212695, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1213157, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1213268, JOURS_FERIES_ME_175758_DATE_175759#1213291, JOURS_FERIES_ME_175758_DEPARTEMENT_175763#1213292, JOURS_FERIES_ME_175758_NOM_JOUR_FERIE_175762#1213293]
(91) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1213456, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1213155, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1213156, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1213343, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1213364, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1213385]
(92) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1212692, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1212801, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1213456, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1213344]
(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