SP1 - Details for Query 4535

Submitted Time: 2026/05/20 14:30:57
Duration: 1.0 s
Succeeded Jobs: 7044 7045 7046 7047 7048 7050

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 10 ms number of output rows: 5,638 number of dynamic part: 0 written output: 35.4 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (16)\n \nduration: 160 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 5,638 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (14)\n \nduration: 225 ms"; 8 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 132.1 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 5,638 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: 5,638 local bytes read: 125.6 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: 792.8 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: 125.6 KiB"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (13)\n \nduration: 27 ms"; 12 [labelType="html" label=" Project "]; } 13 [labelType="html" label="CartesianProduct number of output rows: 5,638"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 28 ms"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 5,638"]; } 17 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 44 ms"; 19 [labelType="html" label="Sort sort time: 1 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: 27 ms"; 22 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 23 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 149.6 KiB number of coalesced partitions: 1"]; 24 [labelType="html" label="Exchange shuffle records written: 8,482 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: 8,482 local bytes read: 143.6 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: 861.5 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: 143.6 KiB"]; subgraph cluster25 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 53 ms"; 26 [labelType="html" label=" Project "]; 27 [labelType="html" label="Generate number of output rows: 8,482"]; 28 [labelType="html" label=" Project "]; } 29 [labelType="html" label="CartesianProduct number of output rows: 8,482"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 53 ms"; 31 [labelType="html" label=" Project "]; 32 [labelType="html" label="SortMergeJoin number of output rows: 8,482 spill size: 0.0 B"]; } subgraph cluster33 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 34 [labelType="html" label="Sort sort time: 3 ms peak memory: 17.0 MiB spill size: 0.0 B"]; } 35 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 316.2 KiB number of coalesced partitions: 1"]; 36 [labelType="html" label="Exchange shuffle records written: 24,063 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: 24,063 local bytes read: 307.2 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: 2.1 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 307.2 KiB"]; subgraph cluster37 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 162 ms"; 38 [labelType="html" label=" Project "]; 39 [labelType="html" label="Filter number of output rows: 24,063"]; } 40 [labelType="html" label="Scan csv number of output rows: 24,063 number of files read: 1 metadata time: 0 ms size of files read: 1354.4 KiB"]; subgraph cluster41 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 85 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: 223.0 B number of coalesced partitions: 1"]; 44 [labelType="html" label="Exchange shuffle records written: 2 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: 2 local bytes read: 218.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: 136.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: 218.0 B"]; subgraph cluster45 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 6 ms"; 46 [labelType="html" label=" Project "]; 47 [labelType="html" label="Filter number of output rows: 2"]; 48 [labelType="html" label="ColumnarToRow number of output rows: 20 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: 2.8 KiB number of output rows: 20"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 5 ms"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label="Filter number of output rows: 1"]; } 53 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster54 { isCluster="true"; label="WholeStageCodegen (12)\n \nduration: 2 ms"; 55 [labelType="html" label=" Project "]; 56 [labelType="html" label="ColumnarToRow number of output rows: 1 number of input batches: 1"]; } 57 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 2.0 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: 6 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_172443, false, Parquet, [path=file:///data/output/cache/parquet/datablock/00_G_ACTES_AUTO_172443], 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#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1118105, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034]

SortMergeJoin [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806], [JOURS_FERIES_ME_172178_DATE_172179#1117940], LeftOuter

WholeStageCodegen (16)

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

WholeStageCodegen (14)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 10), ENSURE_REQUIREMENTS, [plan_id=628743]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]

WholeStageCodegen (13)

CartesianProduct

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806]

Filter ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560 <=> 1))

WholeStageCodegen (11)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

WholeStageCodegen (10)

Window [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

Sort [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, 10), ENSURE_REQUIREMENTS, [plan_id=628579]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]

Generate explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478]

Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_split(LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467]

WholeStageCodegen (8)

CartesianProduct

SortMergeJoin [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345], [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397], Inner

WholeStageCodegen (6)

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345, 10), ENSURE_REQUIREMENTS, [plan_id=628142]

Project [Numéro Séjour#1117043 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, Date soins#1117046 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1117047, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]

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

WholeStageCodegen (1)

FileScan csv [Numéro Séjour#1117043,Date soins#1117046,Spécialité exécutant#1117047] 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_172093/Horodatage_actes..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

Sort [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, 10), ENSURE_REQUIREMENTS, [plan_id=628162]

Project [Codes+officiels#1114172 AS LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1114170, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173 AS LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]

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

ColumnarToRow

WholeStageCodegen (2)

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

WholeStageCodegen (7)

FileScan csv [REGLES#1117246,APPLICABLE#1117247] Batched: false, DataFilters: [isnotnull(REGLES#1117246), (RC-SUN-AUTO = REGLES#1117246), (APPLICABLE#1117247 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/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#1113867, LEFT, 2) AS 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829]

ColumnarToRow

WholeStageCodegen (12)

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

Sort [JOURS_FERIES_ME_172178_DATE_172179#1117940 ASC NULLS FIRST], false, 0

WholeStageCodegen (15)

AQEShuffleRead coalesced

Exchange hashpartitioning(JOURS_FERIES_ME_172178_DATE_172179#1117940, 10), ENSURE_REQUIREMENTS, [plan_id=628202]

Project [date#1116024 AS JOURS_FERIES_ME_172178_DATE_172179#1117940, departement#1116028 AS JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, nom_jour_ferie#1116027 AS JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]

Filter isnotnull(date#1116024)

WholeStageCodegen (3)

FileScan csv [date#1116024,nom_jour_ferie#1116027,departement#1116028] Batched: false, DataFilters: [isnotnull(date#1116024)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/JOURS_FERIES_ME_172099/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=792.8 KiB, rowCount=5.64E+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=861.5 KiB, rowCount=8.48E+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=2.1 MiB, rowCount=2.41E+4)
               :                 :                                      :     :        +- Exchange (4)
               :                 :                                      :     :           +- * Project (3)
               :                 :                                      :     :              +- * Filter (2)
               :                 :                                      :     :                 +- Scan csv  (1)
               :                 :                                      :     +- * Sort (15)
               :                 :                                      :        +- AQEShuffleRead (14)
               :                 :                                      :           +- ShuffleQueryStage (13), Statistics(sizeInBytes=136.0 B, rowCount=2)
               :                 :                                      :              +- 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#1117043, Date soins#1117046, Spécialité exécutant#1117047]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/03_ACTES_PATIEN_172093/Horodatage_actes_Patient_Aigle_M122025.csv]
ReadSchema: struct<Numéro Séjour:string,Date soins:string,Spécialité exécutant:string>

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

(3) Project [codegen id : 1]
Output [3]: [Numéro Séjour#1117043 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, Date soins#1117046 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1117047, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Input [3]: [Numéro Séjour#1117043, Date soins#1117046, Spécialité exécutant#1117047]

(4) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345, 10), ENSURE_REQUIREMENTS, [plan_id=628142]

(5) ShuffleQueryStage
Output [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: 0

(6) AQEShuffleRead
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345 ASC NULLS FIRST], false, 0

(8) Scan parquet 
Output [3]: [Sp%C3%A9cialit%C3%A9+etab#1114170, Codes+officiels#1114172, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/LISTE_UF_SUN_SU_172126_8d3497e2cde4d461defb9dcbd5bde5a7/Info_Etab_init_v1.1 Aigle.xlsx_84426ddf990e659b3ac846a87f234586]
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#1114170, Codes+officiels#1114172, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173]

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

(11) Project [codegen id : 2]
Output [3]: [Codes+officiels#1114172 AS LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1114170, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173 AS LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1114170, Codes+officiels#1114172, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173]

(12) Exchange
Input [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, 10), ENSURE_REQUIREMENTS, [plan_id=628162]

(13) ShuffleQueryStage
Output [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: 1

(14) AQEShuffleRead
Input [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: coalesced

(15) Sort [codegen id : 5]
Input [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397 ASC NULLS FIRST], false, 0

(16) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Right keys [1]: [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397]
Join type: Inner
Join condition: None

(17) Project [codegen id : 6]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]

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

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

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

(22) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_split(LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]

(23) Generate [codegen id : 8]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478]

(24) Project [codegen id : 8]
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478]

(25) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, 10), ENSURE_REQUIREMENTS, [plan_id=628579]

(26) ShuffleQueryStage
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: 3

(27) AQEShuffleRead
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

(29) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

(30) Sort [codegen id : 10]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

(31) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

(32) Filter [codegen id : 11]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560 <=> 1))

(33) Project [codegen id : 11]
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560]

(34) Scan parquet 
Output [1]: [Finess#1113867]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__172105_6dc53a8b1c80c8069b989a1e191431ce/Info_Etab_init_v1.1 Aigle.xlsx_91a713d6dcf5ec82e6f422891111c0df]
ReadSchema: struct<Finess:string>

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

(36) Project [codegen id : 12]
Output [1]: [str_extract(Finess#1113867, LEFT, 2) AS 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829]
Input [1]: [Finess#1113867]

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

(38) Project [codegen id : 13]
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829]

(39) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 10), ENSURE_REQUIREMENTS, [plan_id=628743]

(40) ShuffleQueryStage
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: 4

(41) AQEShuffleRead
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: coalesced

(42) Sort [codegen id : 14]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806 ASC NULLS FIRST], false, 0

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

(45) Project [codegen id : 3]
Output [3]: [date#1116024 AS JOURS_FERIES_ME_172178_DATE_172179#1117940, departement#1116028 AS JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, nom_jour_ferie#1116027 AS JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Input [3]: [date#1116024, nom_jour_ferie#1116027, departement#1116028]

(46) Exchange
Input [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: hashpartitioning(JOURS_FERIES_ME_172178_DATE_172179#1117940, 10), ENSURE_REQUIREMENTS, [plan_id=628202]

(47) ShuffleQueryStage
Output [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: 2

(48) AQEShuffleRead
Input [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: coalesced

(49) Sort [codegen id : 15]
Input [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: [JOURS_FERIES_ME_172178_DATE_172179#1117940 ASC NULLS FIRST], false, 0

(50) SortMergeJoin [codegen id : 16]
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806]
Right keys [1]: [JOURS_FERIES_ME_172178_DATE_172179#1117940]
Join type: LeftOuter
Join condition: None

(51) Project [codegen id : 16]
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917, JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]

(52) Project [codegen id : 16]
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1118105, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034]

(53) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1118105, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993]

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

(56) Project
Output [3]: [Numéro Séjour#1117043 AS COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, Date soins#1117046 AS COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, str_transform_case(str_remove_accent(str_replace_extend(str_remove_space(Spécialité exécutant#1117047, ONLY_ONE), [ ], [-])), UPPER) AS COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Input [3]: [Numéro Séjour#1117043, Date soins#1117046, Spécialité exécutant#1117047]

(57) Exchange
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: hashpartitioning(COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345, 10), ENSURE_REQUIREMENTS, [plan_id=628049]

(58) Sort
Input [3]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Arguments: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345 ASC NULLS FIRST], false, 0

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

(60) Project
Output [3]: [Codes+officiels#1114172 AS LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, str_replace_extend(str_transform_case(str_remove_accent(str_remove_space(Sp%C3%A9cialit%C3%A9+etab#1114170, ONLY_ONE)), UPPER), [ ], [-]) AS LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173 AS LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Input [3]: [Sp%C3%A9cialit%C3%A9+etab#1114170, Codes+officiels#1114172, Sp%C3%A9cialit%C3%A9+urgentiste+UF#1114173]

(61) Exchange
Input [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: hashpartitioning(LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, 10), ENSURE_REQUIREMENTS, [plan_id=628050]

(62) Sort
Input [3]: [LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Arguments: [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397 ASC NULLS FIRST], false, 0

(63) SortMergeJoin
Left keys [1]: [COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345]
Right keys [1]: [LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397]
Join type: Inner
Join condition: None

(64) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_9F4D6058_F196_4B17_B4B5_2C7706DF82DC#1117345, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_ETAB_172247#1117397, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]

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

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

(67) Project
Output: []
Input [2]: [REGLES#1117246, APPLICABLE#1117247]

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

(69) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395 AS COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_split(LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398, ;) AS COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458, str_to_datez(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467]
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LISTE_UF_SUN_SU_172246_CODES_OFFICIELS_172249#1117395, LISTE_UF_SUN_SU_172246_SPECIALITE_URGE_172250#1117398]

(70) Generate
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467]
Arguments: explode(COL_9E049AD5_127E_4665_A135_38C7D69F0524#1117458), [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467], false, [COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478]

(71) Project
Output [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, str_join(array(COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478), -) AS COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_19DEA476_4B65_4C26_8AEB_401B1148E80D#1117478]

(72) Exchange
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: hashpartitioning(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, 10), ENSURE_REQUIREMENTS, [plan_id=628060]

(73) Sort
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

(74) Window
Input [5]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

(75) Sort
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643]
Arguments: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341 ASC NULLS FIRST, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534 ASC NULLS FIRST, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST], false, 0

(76) Window
Input [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643]
Arguments: [row_number() windowspecdefinition(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560], [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534], [COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467 ASC NULLS LAST]

(77) Filter
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560]
Condition : ((COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643 <=> 1) AND (COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560 <=> 1))

(78) Project
Output [6]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, date_time_to_str(COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, EEEE, Europe/Paris, fr_FR) AS COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, int_sum(array(int_mult(array(str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 12, 2)), 60)), str_to_integer(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 15, 2)))) AS COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, str_extract(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, LEFT, 10) AS COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_3A2979C4_F4DD_45B2_8C27_4218F75C10B1#1117467, COL_435E98B6_DA51_4289_8368_EA8C7F331B2A#1117534, COL_610F71AD_0BEE_4815_A433_7501DF9C0776#1117643, COL_44FF6557_5C57_4AEC_98D4_082EF1B2C87D#1117560]

(79) Scan parquet 
Output [1]: [Finess#1113867]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__172105_6dc53a8b1c80c8069b989a1e191431ce/Info_Etab_init_v1.1 Aigle.xlsx_91a713d6dcf5ec82e6f422891111c0df]
ReadSchema: struct<Finess:string>

(80) Project
Output [1]: [str_extract(Finess#1113867, LEFT, 2) AS 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829]
Input [1]: [Finess#1113867]

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

(82) Project
Output [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829 AS COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 09_INFORMATION__172241_DEPARTEMENTETAB_172245#1117829]

(83) Exchange
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: hashpartitioning(COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, 10), ENSURE_REQUIREMENTS, [plan_id=628074]

(84) Sort
Input [7]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917]
Arguments: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806 ASC NULLS FIRST], false, 0

(85) Filter
Input [3]: [date#1116024, nom_jour_ferie#1116027, departement#1116028]
Condition : isnotnull(date#1116024)

(86) Project
Output [3]: [date#1116024 AS JOURS_FERIES_ME_172178_DATE_172179#1117940, departement#1116028 AS JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, nom_jour_ferie#1116027 AS JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Input [3]: [date#1116024, nom_jour_ferie#1116027, departement#1116028]

(87) Exchange
Input [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: hashpartitioning(JOURS_FERIES_ME_172178_DATE_172179#1117940, 10), ENSURE_REQUIREMENTS, [plan_id=628075]

(88) Sort
Input [3]: [JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]
Arguments: [JOURS_FERIES_ME_172178_DATE_172179#1117940 ASC NULLS FIRST], false, 0

(89) SortMergeJoin
Left keys [1]: [COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806]
Right keys [1]: [JOURS_FERIES_ME_172178_DATE_172179#1117940]
Join type: LeftOuter
Join condition: None

(90) Project
Output [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942 AS COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941 AS COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993, str_join(array(str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 9, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 6, 2), str_extract_middle(COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, 1, 4)), ) AS COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013, size(str_list_intersect_fixed(str_split(JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, ;), array(COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917)), true) AS COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034]
Input [10]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_23CBC939_FED9_4CC5_BEE3_E6916C516674#1117344, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_0130D8F7_83F5_4ECD_BC24_EF3A22F79DCB#1117806, COL_8330A4D3_703F_4741_8827_E8B6EF1D0A11#1117917, JOURS_FERIES_ME_172178_DATE_172179#1117940, JOURS_FERIES_ME_172178_DEPARTEMENT_172183#1117941, JOURS_FERIES_ME_172178_NOM_JOUR_FERIE_172182#1117942]

(91) Project
Output [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, str_if_with_rule((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 480) END OR CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1320) END), str_join(array(SUN, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), str_if_with_rule(((((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 480) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1200) END) AND ((str_if_with_rule((isnotnull(COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992) AND ((COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993 <=> ALL) OR (COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034 > 0))), O, N) <=> O) OR (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> dimanche))) OR ((CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 840) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END) AND (COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804 <=> samedi))) OR (CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 >= 1200) END AND CASE WHEN isnull(COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805) THEN false ELSE (COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805 < 1320) END)), str_join(array(SUF, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013), !), null)) AS COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1118105, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993]
Input [8]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_0800C6E2_2344_4C16_98C3_67CBAB0BC282#1117804, COL_8FA6C274_8955_4E8D_A9D6_8F485A619639#1117805, COL_03B3D15D_8E3E_438D_B0D8_0D942310F2CD#1117992, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993, COL_1B07D227_CF34_4B2A_865D_B789AD1EAC0A#1118013, COL_FD9DB577_C4FA_45F0_B0D8_2E091E673A2C#1118034]

(92) WriteFiles
Input [4]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1117341, COL_D8510192_8A92_4D8A_9C8C_D1728884D9D1#1117450, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1118105, COL_42D822AC_CD49_4DAB_8F3D_CC2A1176E7F8#1117993]

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