SP1 - Details for Query 5028

Submitted Time: 2026/10/21 10:07:20
Duration: 0.3 s
Succeeded Jobs: 7691 7692

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)) 2 ms (0 ms, 0 ms, 0 ms (stage 15231.0: task 19428)) 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 15231.0: task 19423)) 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 15231.0: task 19424))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n698 ms (63 ms, 69 ms, 82 ms (stage 15231.0: task 19428))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 697 ms (62 ms, 69 ms, 82 ms (stage 15231.0: task 19428)) number of output rows: 10"]; 6 [labelType="html" label=" Project "]; } 7 [labelType="html" label="CartesianProduct number of output rows: 1"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (120 ms, 127 ms, 140 ms (stage 15231.0: task 19428))"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="ColumnarToRow number of output rows: 6,253 number of input batches: 10"]; } 11 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 86 ms (4 ms, 8 ms, 12 ms (stage 15231.0: task 19424)) metadata time: 0 ms size of files read: 1383.2 KiB number of output rows: 6,253"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n183 ms (15 ms, 18 ms, 22 ms (stage 15231.0: task 19425))"; 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: 175.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=713188]

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

Project

WholeStageCodegen (3)

CartesianProduct (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492)) THEN false ELSE Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492) END)

Project [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465 AS COL_6D461599_696B_4415_9E1E_62284656C432#1094693, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461,COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462,COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465,COL_351EE403_0229_4432_B273_A1F41BC78672#1094466,COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474,COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476,COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481] 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#1094443 AS REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733]

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

WholeStageCodegen (2)

FileScan csv [REGLES#1094442,APPLICABLE#1094443] Batched: false, DataFilters: [isnotnull(REGLES#1094442), (RC-FU-PE = REGLES#1094442), (APPLICABLE#1094443 <=> 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 ==
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 [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481]
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_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2:double>

(2) ColumnarToRow [codegen id : 1]
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481]

(3) Project [codegen id : 1]
Output [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465 AS COL_6D461599_696B_4415_9E1E_62284656C432#1094693, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709]
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481]

(4) Scan csv 
Output [2]: [REGLES#1094442, APPLICABLE#1094443]
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#1094442, APPLICABLE#1094443]
Condition : ((isnotnull(REGLES#1094442) AND (RC-FU-PE = REGLES#1094442)) AND (APPLICABLE#1094443 <=> O))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#1094443 AS REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733]
Input [2]: [REGLES#1094442, APPLICABLE#1094443]

(7) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492)) THEN false ELSE Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492) END)

(8) Project [codegen id : 3]
Output: []
Input [20]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692, COL_6D461599_696B_4415_9E1E_62284656C432#1094693, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709, REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733]

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

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

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

(12) HashAggregate [codegen id : 4]
Input [1]: [count#1094853L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1094849L]
Results [1]: [count(1)#1094849L AS count#1094850L]

(13) Project
Output [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461 AS COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462 AS COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463 AS COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464 AS COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465 AS COL_6D461599_696B_4415_9E1E_62284656C432#1094693, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466 AS COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467 AS COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468 AS COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469 AS COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470 AS COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471 AS COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472 AS COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473 AS COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474 AS COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475 AS COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476 AS COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477 AS COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478 AS COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481 AS COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709]
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1094461, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1094462, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1094463, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1094464, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1094465, COL_351EE403_0229_4432_B273_A1F41BC78672#1094466, COL_12B44094_B64E_4779_A967_D983CDAB1370#1094467, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1094468, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1094469, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1094470, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1094471, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1094472, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1094473, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1094474, COL_43523D61_1E4B_4377_998B_7E898D87B867#1094475, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1094476, COL_60F7C888_9836_4535_A22F_D43D2994E019#1094477, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1094478, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1094481]

(14) Filter
Input [2]: [REGLES#1094442, APPLICABLE#1094443]
Condition : ((isnotnull(REGLES#1094442) AND (RC-FU-PE = REGLES#1094442)) AND (APPLICABLE#1094443 <=> O))

(15) Project
Output [1]: [APPLICABLE#1094443 AS REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733]
Input [2]: [REGLES#1094442, APPLICABLE#1094443]

(16) CartesianProduct
Join type: Inner
Join condition: (((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492)) THEN false ELSE Contains(cast(COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D461599_696B_4415_9E1E_62284656C432#1094693)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733)), 001503492) END)

(17) Project
Output: []
Input [20]: [COL_670BD5F8_8FF3_4A87_9CC7_41AD9AC92524#1094689, COL_3A40B1E5_6781_455C_B509_208BA8315A16#1094690, COL_3F88B9EA_3CB1_48FB_AD59_6CC81EDF9C89#1094691, COL_C551D51C_8A61_40B9_B761_9B94AE581610#1094692, COL_6D461599_696B_4415_9E1E_62284656C432#1094693, COL_D097B4EB_8D0B_4A47_915A_35CC5794FFF3#1094694, COL_3DA82DBD_A752_4FDA_A937_1A06171197EB#1094695, COL_0412F2BB_43C5_44D8_87E4_C43F7913B8EB#1094696, COL_DEC4495A_C38C_4364_B7A1_EF07FEB8BEC5#1094697, COL_71F36117_4F3A_446C_B978_FE6D78D62A69#1094698, COL_D1360279_4E1E_4060_B245_4A6A57FC041D#1094699, COL_2AF2C839_8859_4238_92E4_A3CDEF747947#1094700, COL_ED73C7EF_56AF_4423_8A86_91DA8541A376#1094701, COL_57372C49_2788_408D_878A_0AF263D7F6B9#1094702, COL_01D58AD8_90BC_40E3_8D20_4066A2AE9093#1094703, COL_85DD7047_2EC5_4E35_9FE0_BCDC970DEAB9#1094704, COL_DF65571D_C940_49F3_A33A_3E824FF8DFB3#1094705, COL_A6DB27C1_EE25_4974_A766_B7906E2FA4C1#1094706, COL_85AF5B84_A52D_49E6_AF68_75B3BC042707#1094709, REGLES_A_APPLIQ_232846_APPLICABLE_232848#1094733]

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

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

(20) HashAggregate
Input [1]: [count#1094853L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1094849L]
Results [1]: [count(1)#1094849L AS count#1094850L]

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

SQL / DataFrame Properties

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