SP1 - Details for Query 16528

Submitted Time: 2026/06/10 13:32:31
Duration: 2 s
Succeeded Jobs: 22492 22493 22494

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 total (min, med, max (stageId: taskId)) 1 ms (0 ms, 1 ms, 1 ms (stage 42880.0: task 60595)) number of written files: 2 job commit time: 10 ms number of output rows: 20,213 number of dynamic part: 0 written output: 629.0 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n3.1 s (1.2 s, 1.9 s, 1.9 s (stage 42880.0: task 60595))"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 20,213"]; 8 [labelType="html" label="SortMergeJoin number of output rows: 21,885 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 42880.0: task 60594))"]; } subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n3.3 s (1.3 s, 2.0 s, 2.0 s (stage 42880.0: task 60595))"; 10 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 5 ms (1 ms, 4 ms, 4 ms (stage 42880.0: task 60595)) peak memory total (min, med, max (stageId: taskId)) 32.8 MiB (16.3 MiB, 16.5 MiB, 16.5 MiB (stage 42880.0: task 60595)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 42880.0: task 60594))"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1472.7 KiB (583.2 KiB, 889.4 KiB, 889.4 KiB (driver)) number of coalesced partitions: 2"]; 12 [labelType="html" label="Exchange shuffle records written: 21,885 local merged chunks fetched: 0 shuffle write time: 4 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 21,885 local bytes read total (min, med, max (stageId: taskId)) 1433.7 KiB (574.1 KiB, 859.5 KiB, 859.5 KiB (stage 42880.0: task 60595)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 42880.0: task 60594)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 6.0 MiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 1433.7 KiB"]; 13 [labelType="html" label="CartesianProduct number of output rows: 21,885"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 82 ms"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="ColumnarToRow number of output rows: 21,885 number of input batches: 6"]; } 17 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 600.9 KiB number of output rows: 21,885"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 6 ms"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 1"]; } 21 [labelType="html" label="Scan csv number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 110.0 B"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 0 ms"; 23 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 35 ms (16 ms, 19 ms, 19 ms (stage 42880.0: task 60595)) peak memory total (min, med, max (stageId: taskId)) 34.0 MiB (17.0 MiB, 17.0 MiB, 17.0 MiB (stage 42880.0: task 60594)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 42880.0: task 60594))"]; } 24 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 1603.9 KiB (641.6 KiB, 962.3 KiB, 962.3 KiB (driver)) number of coalesced partitions: 2"]; 25 [labelType="html" label="Exchange shuffle records written: 64,106 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 8 ms (1 ms, 1 ms, 2 ms (stage 42877.0: task 60592)) 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: 64,106 local bytes read total (min, med, max (stageId: taskId)) 1490.8 KiB (594.7 KiB, 896.1 KiB, 896.1 KiB (stage 42880.0: task 60595)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 42880.0: task 60594)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 4.4 MiB (897.3 KiB, 900.4 KiB, 908.2 KiB (stage 42877.0: task 60589)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 1490.8 KiB (296.6 KiB, 298.0 KiB, 300.4 KiB (stage 42877.0: task 60589))"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n292 ms (58 ms, 58 ms, 60 ms (stage 42877.0: task 60592))"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="Filter number of output rows: 64,106"]; 29 [labelType="html" label="ColumnarToRow number of output rows: 64,106 number of input batches: 20"]; } 30 [labelType="html" label="Scan parquet number of files read: 5 scan time total (min, med, max (stageId: taskId)) 32 ms (3 ms, 7 ms, 8 ms (stage 42877.0: task 60589)) metadata time: 0 ms size of files read: 802.9 KiB number of output rows: 64,106"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 13->12; 15->13; 16->15; 17->16; 19->13; 20->19; 21->20; 23->8; 24->23; 25->24; 27->25; 28->27; 29->28; 30->29; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_K_REGLE_APC__209834, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_K_REGLE_APC__209834], Overwrite, [COL_D05A5A65_F564_4122_87B0_3083E0B30F75, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24, COL_71D1488C_6F20_4806_A023_18CFD9159086]

WriteFiles

Project [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L <= 4) END) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L >= -4) END), Non Eligible, str_if_with_rule(isnotnull(COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)), ))), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)), ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) AS COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714422, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

Project [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, bigint_abs(date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253)) AS COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L, date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253) AS COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

Project [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR) AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163 AS COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165 AS COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043]

Filter NOT (str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) <= 4) END) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) >= -4) END), Non Eligible, str_if_with_rule(isnotnull(bigint_abs(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)), ))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)), ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) <=> Non Eligible)

SortMergeJoin [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044], [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164], LeftOuter

WholeStageCodegen (6)

Sort [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041 ASC NULLS FIRST, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 10), ENSURE_REQUIREMENTS, [plan_id=1748678]

CartesianProduct

Project [COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956 AS COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958 AS COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959 AS COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957 AS COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954 AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960 AS COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955 AS COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954,COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955,COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956,COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957,COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958,COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959,COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/AAAA_211836], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315:string,COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84:s...

Project

Filter ((isnotnull(REGLES#3713909) AND (APC-PROP = REGLES#3713909)) AND (APPLICABLE#3713910 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#3713909,APPLICABLE#3713910] Batched: false, DataFilters: [isnotnull(REGLES#3713909), (APC-PROP = REGLES#3713909), (APPLICABLE#3713910 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209650/REGLES-A-TTT_EXT..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,APC-PROP), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Sort [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161 ASC NULLS FIRST, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 10), ENSURE_REQUIREMENTS, [plan_id=1748710]

Project [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940 AS 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942 AS 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943 AS 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944 AS 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]

Filter (isnotnull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940) AND isnotnull(COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943))

ColumnarToRow

WholeStageCodegen (3)

FileScan parquet [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940,COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942,COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943,COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944] Batched: true, DataFilters: [isnotnull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940), isnotnull(COL_6FDAEEF9_D528_4275_AE..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_D_RSF_COMPL__209781], PartitionFilters: [], PushedFilters: [IsNotNull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2), IsNotNull(COL_6FDAEEF9_D528_4275_AEA9_8A03E..., ReadSchema: struct<COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2:string,COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (44)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (26)
   +- WriteFiles (25)
      +- * Project (24)
         +- * Project (23)
            +- * Project (22)
               +- * Filter (21)
                  +- * SortMergeJoin LeftOuter (20)
                     :- * Sort (11)
                     :  +- AQEShuffleRead (10)
                     :     +- ShuffleQueryStage (9), Statistics(sizeInBytes=6.0 MiB, rowCount=2.19E+4)
                     :        +- Exchange (8)
                     :           +- CartesianProduct Inner (7)
                     :              :- * Project (3)
                     :              :  +- * ColumnarToRow (2)
                     :              :     +- Scan parquet  (1)
                     :              +- * Project (6)
                     :                 +- * Filter (5)
                     :                    +- Scan csv  (4)
                     +- * Sort (19)
                        +- AQEShuffleRead (18)
                           +- ShuffleQueryStage (17), Statistics(sizeInBytes=4.4 MiB, rowCount=6.41E+4)
                              +- Exchange (16)
                                 +- * Project (15)
                                    +- * Filter (14)
                                       +- * ColumnarToRow (13)
                                          +- Scan parquet  (12)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (43)
   +- WriteFiles (42)
      +- Project (41)
         +- Project (40)
            +- Project (39)
               +- Filter (38)
                  +- SortMergeJoin LeftOuter (37)
                     :- Sort (32)
                     :  +- Exchange (31)
                     :     +- CartesianProduct Inner (30)
                     :        :- Project (27)
                     :        :  +- Scan parquet  (1)
                     :        +- Project (29)
                     :           +- Filter (28)
                     :              +- Scan csv  (4)
                     +- Sort (36)
                        +- Exchange (35)
                           +- Project (34)
                              +- Filter (33)
                                 +- Scan parquet  (12)


(1) Scan parquet 
Output [7]: [COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955, COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/AAAA_211836]
ReadSchema: struct<COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315:string,COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84:string,COL_99BB8D43_6FEA_434A_AB5C_B7206E869708:string,COL_3A1970B7_49CC_4364_818D_9B8769DAE824:string,COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92:string,COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4:string,COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59:string>

(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955, COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960]

(3) Project [codegen id : 1]
Output [7]: [COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956 AS COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958 AS COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959 AS COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957 AS COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954 AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960 AS COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955 AS COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Input [7]: [COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955, COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960]

(4) Scan csv 
Output [2]: [REGLES#3713909, APPLICABLE#3713910]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209650/REGLES-A-TTT_EXT.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,APC-PROP), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(5) Filter [codegen id : 2]
Input [2]: [REGLES#3713909, APPLICABLE#3713910]
Condition : ((isnotnull(REGLES#3713909) AND (APC-PROP = REGLES#3713909)) AND (APPLICABLE#3713910 <=> O))

(6) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#3713909, APPLICABLE#3713910]

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

(8) Exchange
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: hashpartitioning(COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 10), ENSURE_REQUIREMENTS, [plan_id=1748678]

(9) ShuffleQueryStage
Output [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: 0

(10) AQEShuffleRead
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: coalesced

(11) Sort [codegen id : 4]
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041 ASC NULLS FIRST, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044 ASC NULLS FIRST], false, 0

(12) Scan parquet 
Output [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_D_RSF_COMPL__209781]
PushedFilters: [IsNotNull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2), IsNotNull(COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED)]
ReadSchema: struct<COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2:string,COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037:string,COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED:string,COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C:timestamp>

(13) ColumnarToRow [codegen id : 3]
Input [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]

(14) Filter [codegen id : 3]
Input [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]
Condition : (isnotnull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940) AND isnotnull(COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943))

(15) Project [codegen id : 3]
Output [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940 AS 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942 AS 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943 AS 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944 AS 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Input [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]

(16) Exchange
Input [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: hashpartitioning(00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 10), ENSURE_REQUIREMENTS, [plan_id=1748710]

(17) ShuffleQueryStage
Output [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: 1

(18) AQEShuffleRead
Input [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: coalesced

(19) Sort [codegen id : 5]
Input [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161 ASC NULLS FIRST, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164 ASC NULLS FIRST], false, 0

(20) SortMergeJoin [codegen id : 6]
Left keys [2]: [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Right keys [2]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164]
Join type: LeftOuter
Join condition: None

(21) Filter [codegen id : 6]
Input [11]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Condition : NOT (str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) <= 4) END) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) >= -4) END), Non Eligible, str_if_with_rule(isnotnull(bigint_abs(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)),  ))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)),  ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) <=> Non Eligible)

(22) Project [codegen id : 6]
Output [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR) AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163 AS COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165 AS COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043]
Input [11]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]

(23) Project [codegen id : 6]
Output [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, bigint_abs(date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253)) AS COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L, date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253) AS COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043]

(24) Project [codegen id : 6]
Output [4]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L <= 4) END) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L >= -4) END), Non Eligible, str_if_with_rule(isnotnull(COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)),  ))), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)),  ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) AS COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714422, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

(25) WriteFiles
Input [4]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714422, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

(26) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_K_REGLE_APC__209834, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_K_REGLE_APC__209834], Overwrite, [COL_D05A5A65_F564_4122_87B0_3083E0B30F75, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24, COL_71D1488C_6F20_4806_A023_18CFD9159086]

(27) Project
Output [7]: [COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956 AS COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958 AS COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959 AS COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957 AS COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954 AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960 AS COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955 AS COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Input [7]: [COL_8AB0F46A_1B32_4D2C_9209_5ECA8D455315#3713954, COL_6C1112AF_9A0D_43CC_92AE_9102588A2E84#3713955, COL_99BB8D43_6FEA_434A_AB5C_B7206E869708#3713956, COL_3A1970B7_49CC_4364_818D_9B8769DAE824#3713957, COL_F00ABAED_9DD0_4F7C_94B8_C58521EB4D92#3713958, COL_332D5F4A_A651_4A0A_8790_B5C11405A9C4#3713959, COL_4FD6917E_AA84_4138_AECE_0E5E0EF9FF59#3713960]

(28) Filter
Input [2]: [REGLES#3713909, APPLICABLE#3713910]
Condition : ((isnotnull(REGLES#3713909) AND (APC-PROP = REGLES#3713909)) AND (APPLICABLE#3713910 <=> O))

(29) Project
Output: []
Input [2]: [REGLES#3713909, APPLICABLE#3713910]

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

(31) Exchange
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: hashpartitioning(COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 10), ENSURE_REQUIREMENTS, [plan_id=1748644]

(32) Sort
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Arguments: [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041 ASC NULLS FIRST, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044 ASC NULLS FIRST], false, 0

(33) Filter
Input [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]
Condition : (isnotnull(COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940) AND isnotnull(COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943))

(34) Project
Output [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940 AS 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942 AS 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943 AS 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944 AS 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Input [4]: [COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3713940, COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3713942, COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3713943, COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3713944]

(35) Exchange
Input [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: hashpartitioning(00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 10), ENSURE_REQUIREMENTS, [plan_id=1748645]

(36) Sort
Input [4]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Arguments: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161 ASC NULLS FIRST, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164 ASC NULLS FIRST], false, 0

(37) SortMergeJoin
Left keys [2]: [COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044]
Right keys [2]: [00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164]
Join type: LeftOuter
Join condition: None

(38) Filter
Input [11]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]
Condition : NOT (str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) <= 4) END) AND CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) >= -4) END), Non Eligible, str_if_with_rule(isnotnull(bigint_abs(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)),  ))), str_if_with_rule(CASE WHEN isnull(date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165)) THEN false ELSE (date_diff(MONTH, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR), 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165) < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, LEFT, 2), str_extract_middle(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 3, 2), str_extract(00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, RIGHT, 4)), -)),  ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) <=> Non Eligible)

(39) Project
Output [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, str_to_datez(COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, ddMMyyyy, Europe/Paris, fr_FR) AS COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163 AS COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165 AS COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043]
Input [11]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_1D08ED84_670F_402B_AFA2_A93913A115FA#3714041, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714042, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_56B1A22D_B476_45CF_8CAF_97D2B15C1A77#3714044, 00_D_RSF_COMPL__209781_COL_7B4A7A63_F69F_4594_AE57_2262BB8300F2#3714161, 00_D_RSF_COMPL__209781_COL_7C11C70D_6B13_46E1_9B4C_79A5C09B9037#3714163, 00_D_RSF_COMPL__209781_COL_6FDAEEF9_D528_4275_AEA9_8A03EE432EED#3714164, 00_D_RSF_COMPL__209781_COL_50E60D7B_9F39_4110_8098_1B97C9A38F6C#3714165]

(40) Project
Output [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, bigint_abs(date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253)) AS COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L, date_diff(MONTH, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253) AS COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_82C1F776_3E0F_4FEB_8F53_378335F66E50#3714250, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_74A483A6_51DD_4ADD_BC8C_3E64128082B0#3714253, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043]

(41) Project
Output [4]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, str_if_with_rule((((COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043 <=> 1) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L <= 4) END) AND CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L >= -4) END), Non Eligible, str_if_with_rule(isnotnull(COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L > 4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [Pas de consultation antérieure], array(str_join(array(Consultation antérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)),  ))), str_if_with_rule(CASE WHEN isnull(COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L) THEN false ELSE (COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L < -4) END, str_replace_extend(COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, [pas de consultation postérieure], array(str_join(array(Consultation postérieure le , str_join(array(str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, LEFT, 2), str_extract_middle(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, 3, 2), str_extract(COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, RIGHT, 4)), -)),  ))), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)), COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040)) AS COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714422, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]
Input [7]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_6083ECC9_998B_4C17_AC6E_F2E78B0E3CCA#3714040, COL_5D3E11D4_3F3C_40FD_B75D_C16728076463#3714252, COL_55C55B79_933F_4FF5_9405_26E904C92023#3714043, COL_CFFB8731_F494_46C4_8773_B68A37FB3AD2#3714270L, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

(42) WriteFiles
Input [4]: [COL_D05A5A65_F564_4122_87B0_3083E0B30F75#3714038, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86#3714039, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24#3714422, COL_71D1488C_6F20_4806_A023_18CFD9159086#3714284L]

(43) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_K_REGLE_APC__209834, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_K_REGLE_APC__209834], Overwrite, [COL_D05A5A65_F564_4122_87B0_3083E0B30F75, COL_7DAC64E0_7F05_4D89_B185_C165E42A0B86, COL_986F85E6_D74C_4C0A_8CB3_EF8A8E6A3E24, COL_71D1488C_6F20_4806_A023_18CFD9159086]

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

SQL / DataFrame Properties

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