SP1 - Details for Query 2027

Submitted Time: 2026/11/05 12:24:27
Duration: 21 s
Succeeded Jobs: 2866 2868 2869

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

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 m (6.3 s, 6.5 s, 7.2 s (stage 5418.0: task 5997))"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="CartesianProduct number of output rows: 32"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.1 m (6.3 s, 6.5 s, 7.3 s (stage 5418.0: task 5997))"; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="ColumnarToRow number of output rows: 2,199,023 number of input batches: 541"]; } 7 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 1.4 s (122 ms, 131 ms, 176 ms (stage 5418.0: task 5997)) metadata time: 0 ms size of files read: 146.8 MiB number of output rows: 2,199,023"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n41 ms (3 ms, 4 ms, 5 ms (stage 5421.0: task 5999))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 10"]; } 11 [labelType="html" label="Scan csv number of output rows: 10 number of files read: 1 metadata time: 0 ms size of files read: 110.0 B"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->3; 10->9; 11->10; }

CollectLimit 1500

Project [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817, REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842 AS COL_9BD2828D_83E1_428A_824D_6EB983239B9E#475870]

WholeStageCodegen (3)

CartesianProduct (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475797)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475797)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800 as string), 30027795)) THEN false ELSE Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475806)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475806)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L as string), 30027795)) THEN false ELSE Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817 as string), 30027795)) THEN false ELSE Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842)), 030027795) END)

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600 AS COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601 AS COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602 AS COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603 AS COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604 AS COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607 AS COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608 AS COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609 AS COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610 AS COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611 AS COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614 AS COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615 AS COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601,COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602,COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603,COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604,COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606,COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607,COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608,COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609,COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610,COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613,COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614,COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_231581], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243:string,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84:s...

Project [APPLICABLE#475582 AS REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842]

Filter ((isnotnull(REGLES#475581) AND (MCS = REGLES#475581)) AND (APPLICABLE#475582 <=> O))

WholeStageCodegen (2)

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

Details

== Physical Plan ==
CollectLimit (9)
+- * Project (8)
   +- CartesianProduct Inner (7)
      :- * Project (3)
      :  +- * ColumnarToRow (2)
      :     +- Scan parquet  (1)
      +- * Project (6)
         +- * Filter (5)
            +- Scan csv  (4)


(1) Scan parquet 
Output [22]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/01_A_STEP_1_RSF_231581]
ReadSchema: struct<COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243:string,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84:string,COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2:string,COL_16E424CE_9B54_4F68_B514_607D2B496B5E:string,COL_76DBABA9_CE78_451B_9E43_031763A13C92:int,COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86:string,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F:string,COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50:string,COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690:string,COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D:string,COL_90F15518_AEAA_468F_80BE_4F4773EFDA05:string,COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839:string,COL_346C27DC_6D06_4FCF_A022_7FF177053D81:string,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62:string,COL_B41CF42C_004D_4F47_A1D6_C923097E3079:string,COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE:string,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0:string,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342:bigint,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487:string,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC:string,COL_714AB906_7002_4ADC_AA1A_38467A3EDE10:array<string>,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6:int>

(2) ColumnarToRow [codegen id : 1]
Input [22]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622]

(3) Project [codegen id : 1]
Output [22]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600 AS COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601 AS COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602 AS COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603 AS COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604 AS COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607 AS COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608 AS COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609 AS COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610 AS COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611 AS COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614 AS COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615 AS COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620 AS COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817]
Input [22]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475600, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475601, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475602, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475603, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475604, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475605, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475606, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475607, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475608, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475609, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475610, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475611, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475612, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475613, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475614, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475615, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475616, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475617L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475618, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475619, COL_714AB906_7002_4ADC_AA1A_38467A3EDE10#475620, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475622]

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

(5) Filter [codegen id : 2]
Input [2]: [REGLES#475581, APPLICABLE#475582]
Condition : ((isnotnull(REGLES#475581) AND (MCS = REGLES#475581)) AND (APPLICABLE#475582 <=> O))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#475582 AS REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842]
Input [2]: [REGLES#475581, APPLICABLE#475582]

(7) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475797)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475797)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800 as string), 30027795)) THEN false ELSE Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475806)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475806)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L as string), 30027795)) THEN false ELSE Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817 as string), 30027795)) THEN false ELSE Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842)), 030027795) END)

(8) Project [codegen id : 3]
Output [23]: [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817, REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842 AS COL_9BD2828D_83E1_428A_824D_6EB983239B9E#475870]
Input [23]: [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817, REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475842]

(9) CollectLimit
Input [23]: [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475796, COL_9480E143_A685_4832_9473_E708AFF737C8#475797, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475798, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475799, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475800, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475801, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475802, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475803, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475804, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475805, COL_19E260A7_142A_4650_8879_2276837C890C#475806, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475807, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475808, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475809, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475810, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475811, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475812, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475813L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475814, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475815, COL_3377534C_2BCD_43B6_853A_869D44C151B3#475816, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475817, COL_9BD2828D_83E1_428A_824D_6EB983239B9E#475870]
Arguments: 1500

SQL / DataFrame Properties

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