SP1 - Details for Query 2023

Submitted Time: 2026/11/05 12:24:25
Duration: 8 s
Succeeded Jobs: 2863 2867

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 10 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (0 ms, 0 ms, 0 ms (stage 5415.0: task 5994)) 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: 10 local bytes read: 563.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 160.0 B (16.0 B, 16.0 B, 16.0 B (stage 5415.0: task 5994)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 563.0 B (56.0 B, 56.0 B, 59.0 B (stage 5415.0: task 5985))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n1.2 m (7.1 s, 7.2 s, 7.6 s (stage 5415.0: task 5989))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 1.2 m (7.1 s, 7.2 s, 7.6 s (stage 5415.0: task 5989)) number of output rows: 10"]; 6 [labelType="html" label=" Project "]; } 7 [labelType="html" label="CartesianProduct number of output rows: 32"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.2 m (7.1 s, 7.3 s, 7.6 s (stage 5415.0: task 5989))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="ColumnarToRow number of output rows: 2,199,023 number of input batches: 541"]; } 11 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 1.5 s (135 ms, 147 ms, 168 ms (stage 5415.0: task 5985)) metadata time: 0 ms size of files read: 146.8 MiB number of output rows: 2,199,023"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n68 ms (4 ms, 7 ms, 10 ms (stage 5415.0: task 5992))"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 10"]; } 15 [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->7; 10->9; 11->10; 13->7; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (4)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194560]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

WholeStageCodegen (3)

CartesianProduct (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795)) THEN false ELSE Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795)) THEN false ELSE Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795)) THEN false ELSE Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795) END)

Project [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194 AS COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195 AS COL_9480E143_A685_4832_9473_E708AFF737C8#475391, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196 AS COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197 AS COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198 AS COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201 AS COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202 AS COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203 AS COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204 AS COL_19E260A7_142A_4650_8879_2276837C890C#475400, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205 AS COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208 AS COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209 AS COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194,COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195,COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196,COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197,COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198,COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199,COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200,COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201,COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202,COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203,COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204,COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205,COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206,COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207,COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208,COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209,COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210,COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L,COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212,COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213,COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216] 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#475176 AS REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436]

Filter ((isnotnull(REGLES#475175) AND (MCS = REGLES#475175)) AND (APPLICABLE#475176 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#475175,APPLICABLE#475176] Batched: false, DataFilters: [isnotnull(REGLES#475175), (MCS = REGLES#475175), (APPLICABLE#475176 <=> 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 ==
AdaptiveSparkPlan (21)
+- == Final Plan ==
   * HashAggregate (12)
   +- ShuffleQueryStage (11), Statistics(sizeInBytes=160.0 B, rowCount=10)
      +- Exchange (10)
         +- * HashAggregate (9)
            +- * Project (8)
               +- CartesianProduct Inner (7)
                  :- * Project (3)
                  :  +- * ColumnarToRow (2)
                  :     +- Scan parquet  (1)
                  +- * Project (6)
                     +- * Filter (5)
                        +- Scan csv  (4)
+- == Initial Plan ==
   HashAggregate (20)
   +- Exchange (19)
      +- HashAggregate (18)
         +- Project (17)
            +- CartesianProduct Inner (16)
               :- Project (13)
               :  +- Scan parquet  (1)
               +- Project (15)
                  +- Filter (14)
                     +- Scan csv  (4)


(1) Scan parquet 
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216]
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_D986422B_41E3_4D4B_9F25_9D68ED522BE6:int>

(2) ColumnarToRow [codegen id : 1]
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216]

(3) Project [codegen id : 1]
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194 AS COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195 AS COL_9480E143_A685_4832_9473_E708AFF737C8#475391, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196 AS COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197 AS COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198 AS COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201 AS COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202 AS COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203 AS COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204 AS COL_19E260A7_142A_4650_8879_2276837C890C#475400, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205 AS COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208 AS COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209 AS COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411]
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216]

(4) Scan csv 
Output [2]: [REGLES#475175, APPLICABLE#475176]
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#475175, APPLICABLE#475176]
Condition : ((isnotnull(REGLES#475175) AND (MCS = REGLES#475175)) AND (APPLICABLE#475176 <=> O))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#475176 AS REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436]
Input [2]: [REGLES#475175, APPLICABLE#475176]

(7) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795)) THEN false ELSE Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795)) THEN false ELSE Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795)) THEN false ELSE Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795) END)

(8) Project [codegen id : 3]
Output: []
Input [22]: [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390, COL_9480E143_A685_4832_9473_E708AFF737C8#475391, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399, COL_19E260A7_142A_4650_8879_2276837C890C#475400, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411, REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436]

(9) HashAggregate [codegen id : 3]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#475560L]
Results [1]: [count#475561L]

(10) Exchange
Input [1]: [count#475561L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194560]

(11) ShuffleQueryStage
Output [1]: [count#475561L]
Arguments: 0

(12) HashAggregate [codegen id : 4]
Input [1]: [count#475561L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#475557L]
Results [1]: [count(1)#475557L AS count#475558L]

(13) Project
Output [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194 AS COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195 AS COL_9480E143_A685_4832_9473_E708AFF737C8#475391, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196 AS COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197 AS COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198 AS COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199 AS COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200 AS COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201 AS COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202 AS COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203 AS COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204 AS COL_19E260A7_142A_4650_8879_2276837C890C#475400, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205 AS COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206 AS COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207 AS COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208 AS COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209 AS COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210 AS COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L AS COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212 AS COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213 AS COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216 AS COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411]
Input [21]: [COL_29AA6B1F_3CE6_452C_A510_6ACDBA5CD243#475194, COL_6F5E8886_D62F_4949_8CEA_F222954BFC84#475195, COL_0CE644FE_8E6B_4581_A639_58227BF2A7A2#475196, COL_16E424CE_9B54_4F68_B514_607D2B496B5E#475197, COL_76DBABA9_CE78_451B_9E43_031763A13C92#475198, COL_7153B3F6_7E41_45CB_84CC_CF466AE1BE86#475199, COL_4587DB83_72BD_4F2D_BA18_AAD14178DC7F#475200, COL_622B74E9_F71D_4E3E_8627_51C1F0B6BE50#475201, COL_C0EF5B3D_DEDA_4CC7_8660_3B6BFF3A2690#475202, COL_90F030B1_798F_4717_B816_BB1AEBEAAF8D#475203, COL_90F15518_AEAA_468F_80BE_4F4773EFDA05#475204, COL_EDC5FAFE_825C_4EC7_A31E_66183BA64839#475205, COL_346C27DC_6D06_4FCF_A022_7FF177053D81#475206, COL_75DE8325_2CC3_4E7A_A718_80AA4F2A9D62#475207, COL_B41CF42C_004D_4F47_A1D6_C923097E3079#475208, COL_6A5227D7_4C1F_4F63_9444_9FF29ADC5BCE#475209, COL_A5765544_357B_4395_B6BC_21D7D5C2D0E0#475210, COL_969EAFA1_AD39_4285_AD05_6146CD6F9342#475211L, COL_19CE074B_1F54_459C_ABA2_D9FCF9DC7487#475212, COL_A4AF3049_C967_4B58_9D36_40EE5D79F6AC#475213, COL_D986422B_41E3_4D4B_9F25_9D68ED522BE6#475216]

(14) Filter
Input [2]: [REGLES#475175, APPLICABLE#475176]
Condition : ((isnotnull(REGLES#475175) AND (MCS = REGLES#475175)) AND (APPLICABLE#475176 <=> O))

(15) Project
Output [1]: [APPLICABLE#475176 AS REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436]
Input [2]: [REGLES#475175, APPLICABLE#475176]

(16) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390)), 030027795) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_9480E143_A685_4832_9473_E708AFF737C8#475391)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795)) THEN false ELSE Contains(cast(COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_19E260A7_142A_4650_8879_2276837C890C#475400)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795)) THEN false ELSE Contains(cast(COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408)), 030027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409)), 030027795) END) OR CASE WHEN isnull(Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795)) THEN false ELSE Contains(cast(COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411 as string), 30027795) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436)), 030027795) END)

(17) Project
Output: []
Input [22]: [COL_F87CB311_CF5C_4911_B860_9BB49B3D440C#475390, COL_9480E143_A685_4832_9473_E708AFF737C8#475391, COL_13D47E8A_C252_476A_A128_C55AB39855C5#475392, COL_EB09DDB9_08EE_4793_9CD3_9D80907FF7DF#475393, COL_AD53CF7B_8F18_4F38_A923_1ED9E4E7FF33#475394, COL_131C1042_88F0_40B5_A05D_6AC9BF440E17#475395, COL_3931E036_315E_4AC8_A56D_37AE79FDF6B7#475396, COL_83CEA3C4_98AE_4085_BA51_A7D51697E4AF#475397, COL_16A79522_4FB0_4DD8_8106_1DC34B491378#475398, COL_3F6460EB_279E_43A3_9792_7975EFEBFCB7#475399, COL_19E260A7_142A_4650_8879_2276837C890C#475400, COL_E293F83B_26B7_4C10_B21B_B8700F76F826#475401, COL_E43C6574_A3E3_4056_BB55_EA935E04502C#475402, COL_10A975F7_B67F_438C_B8DE_9E0F00F273DC#475403, COL_5109D3F4_1A1B_4667_B1F5_D38D774A6E63#475404, COL_CCA8CF13_2F95_4589_9EFD_5B1903758B44#475405, COL_F65F0EE2_FCC8_4E9F_B23F_0D97C40F54FD#475406, COL_414BA164_8DC3_4834_BDD7_434B2278858B#475407L, COL_085E5798_40D8_4726_B01C_7D83841C9C25#475408, COL_B9A76B6D_E3EA_49F5_A0E9_DE474A8CE2B4#475409, COL_318510CA_23E7_4678_9FCA_D34FF51ADC39#475411, REGLES_APPLIQUE_231452_A_EFFECTUER_231454#475436]

(18) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#475560L]
Results [1]: [count#475561L]

(19) Exchange
Input [1]: [count#475561L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=194525]

(20) HashAggregate
Input [1]: [count#475561L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#475557L]
Results [1]: [count(1)#475557L AS count#475558L]

(21) AdaptiveSparkPlan
Output [1]: [count#475558L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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