SP1 - Details for Query 5032

Submitted Time: 2026/10/21 10:07:21
Duration: 0.5 s
Succeeded Jobs: 7695 7696 7697

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))\n545 ms (36 ms, 55 ms, 123 ms (stage 15236.0: task 19435))"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="CartesianProduct number of output rows: 1"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n748 ms (49 ms, 71 ms, 180 ms (stage 15236.0: task 19435))"; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="ColumnarToRow number of output rows: 6,253 number of input batches: 10"]; } 7 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 41 ms (3 ms, 4 ms, 5 ms (stage 15236.0: task 19435)) metadata time: 0 ms size of files read: 1383.2 KiB number of output rows: 6,253"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n73 ms (3 ms, 5 ms, 27 ms (stage 15236.0: task 19435))"; 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: 175.0 B"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->3; 10->9; 11->10; }

CollectLimit 1500

Project [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175, REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#1095226]

WholeStageCodegen (3)

CartesianProduct (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157 as string), 1503492)) THEN false ELSE Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1095159)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1095159)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199)), 001503492) END)

Project [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931 AS COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_351EE403_0229_4432_B273_A1F41BC78672#1094932 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945 AS COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946 AS COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927,COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928,COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931,COL_351EE403_0229_4432_B273_A1F41BC78672#1094932,COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940,COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942,COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_232867], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_2C57AE56_072C_4967_B155_3BCF550AC929:s...

Project [APPLICABLE#1094909 AS REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199]

Filter ((isnotnull(REGLES#1094908) AND (RC-FU-PE = REGLES#1094908)) AND (APPLICABLE#1094909 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#1094908,APPLICABLE#1094909] Batched: false, DataFilters: [isnotnull(REGLES#1094908), (RC-FU-PE = REGLES#1094908), (APPLICABLE#1094909 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_232719/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FU-PE), 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 [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931, COL_351EE403_0229_4432_B273_A1F41BC78672#1094932, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_232867]
ReadSchema: struct<COL_B0A29476_8712_4938_9AAA_2B3FED3AA843:string,COL_2C57AE56_072C_4967_B155_3BCF550AC929:string,COL_1856697C_8DD2_425F_AA61_054524CA3E4B:int,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F:string,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_351EE403_0229_4432_B273_A1F41BC78672:string,COL_12B44094_B64E_4779_A967_D983CDAB1370:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00:string,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720:string,COL_43523D61_1E4B_4377_998B_7E898D87B867:string,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94:string,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506:string,COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB:array<string>,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2:double>

(2) ColumnarToRow [codegen id : 1]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931, COL_351EE403_0229_4432_B273_A1F41BC78672#1094932, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947]

(3) Project [codegen id : 1]
Output [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931 AS COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_351EE403_0229_4432_B273_A1F41BC78672#1094932 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945 AS COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946 AS COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175]
Input [21]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094927, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094928, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094929, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094930, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094931, COL_351EE403_0229_4432_B273_A1F41BC78672#1094932, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094933, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094934, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094935, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094936, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094937, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094938, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094939, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094940, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094941, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094942, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094943, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094944, COL_F32292CE_571F_40F2_88B1_7D25A50B5BBB#1094945, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#1094946, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094947]

(4) Scan csv 
Output [2]: [REGLES#1094908, APPLICABLE#1094909]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_232719/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-FU-PE), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(5) Filter [codegen id : 2]
Input [2]: [REGLES#1094908, APPLICABLE#1094909]
Condition : ((isnotnull(REGLES#1094908) AND (RC-FU-PE = REGLES#1094908)) AND (APPLICABLE#1094909 <=> O))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#1094909 AS REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199]
Input [2]: [REGLES#1094908, APPLICABLE#1094909]

(7) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157 as string), 1503492)) THEN false ELSE Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1095159)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1095159)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199)), 001503492) END)

(8) Project [codegen id : 3]
Output [22]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175, REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199 AS COL_5276B642_7FD3_4362_A102_7091D784BB77#1095226]
Input [22]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175, REGLES_A_APPLIQ_232846_APPLICABLE_232848#1095199]

(9) CollectLimit
Input [22]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1095155, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1095156, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1095157, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1095158, COL_6D461599_696B_4415_9E1E_62284656C432#1095159, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1095160, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1095161, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1095162, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1095163, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1095164, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1095165, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1095166, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1095167, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1095168, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1095169, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1095170, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1095171, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1095172, COL_FA4C9871_A66B_4A6A_B1CA_5BD2B9E657E2#1095173, COL_B567B242_E9FB_477C_9A17_BDEE4FCB4902#1095174, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1095175, COL_5276B642_7FD3_4362_A102_7091D784BB77#1095226]
Arguments: 1500

SQL / DataFrame Properties

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