SP1 - Details for Query 5022

Submitted Time: 2026/10/21 10:07:04
Duration: 0.3 s
Succeeded Jobs: 7683 7684

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 (2)\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 15222.0: task 19404)) 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 15222.0: task 19398)) 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 15222.0: task 19400))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n882 ms (39 ms, 89 ms, 109 ms (stage 15222.0: task 19400))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 878 ms (38 ms, 89 ms, 109 ms (stage 15222.0: task 19400)) number of output rows: 10"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 6,253 number of input batches: 10"]; } 9 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 141 ms (6 ms, 13 ms, 21 ms (stage 15222.0: task 19399)) metadata time: 0 ms size of files read: 1383.2 KiB number of output rows: 6,253"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 9->8; }

AdaptiveSparkPlan isFinalPlan=true

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

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=713023]

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

Project

Filter ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492)) THEN false ELSE Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855,COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856,COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857,COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858,COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859,COL_351EE403_0229_4432_B273_A1F41BC78672#1093860,COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864,COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866,COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867,COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868,COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869,COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870,COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871,COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872,COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875] Batched: true, DataFilters: [((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_..., 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...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=160.0 B, rowCount=10)
      +- Exchange (6)
         +- * HashAggregate (5)
            +- * Project (4)
               +- * Filter (3)
                  +- * ColumnarToRow (2)
                     +- Scan parquet  (1)
+- == Initial Plan ==
   HashAggregate (13)
   +- Exchange (12)
      +- HashAggregate (11)
         +- Project (10)
            +- Filter (9)
               +- Scan parquet  (1)


(1) Scan parquet 
Output [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]
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#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]

(3) Filter [codegen id : 1]
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492)) THEN false ELSE Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0) END)

(4) Project [codegen id : 1]
Output: []
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]

(5) HashAggregate [codegen id : 1]
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1094107L]
Results [1]: [count#1094108L]

(6) Exchange
Input [1]: [count#1094108L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=713023]

(7) ShuffleQueryStage
Output [1]: [count#1094108L]
Arguments: 0

(8) HashAggregate [codegen id : 2]
Input [1]: [count#1094108L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1094104L]
Results [1]: [count(1)#1094104L AS count#1094105L]

(9) Filter
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855)), 001503492) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492)) THEN false ELSE Contains(cast(COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857 as string), 1503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_351EE403_0229_4432_B273_A1F41BC78672#1093860)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866 as string), 1503492.0) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871)), 001503492) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492)) THEN false ELSE Contains(str_remove_accent(upper(COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872)), 001503492) END) OR CASE WHEN isnull(Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0)) THEN false ELSE Contains(cast(COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875 as string), 1503492.0) END)

(10) Project
Output: []
Input [19]: [COL_B0A29476_8712_4938_9AAA_2B3FED3AA843#1093855, COL_2C57AE56_072C_4967_B155_3BCF550AC929#1093856, COL_1856697C_8DD2_425F_AA61_054524CA3E4B#1093857, COL_CC27206E_3AE7_4822_B5CA_6AFE91FF041F#1093858, COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1093859, COL_351EE403_0229_4432_B273_A1F41BC78672#1093860, COL_12B44094_B64E_4779_A967_D983CDAB1370#1093861, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#1093862, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1093863, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#1093864, COL_3B226ACB_AA4E_47E6_BD93_5023DCAC91B8#1093865, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#1093866, COL_FEC0DD4A_81C8_43C0_839B_6C467192AD00#1093867, COL_F59EBD3D_6145_41E4_8527_CC67B7C9A720#1093868, COL_43523D61_1E4B_4377_998B_7E898D87B867#1093869, COL_5B5B1560_CF55_4AC4_BCE9_7B7950215A94#1093870, COL_60F7C888_9836_4535_A22F_D43D2994E019#1093871, COL_6D75D92E_6F3C_4FDD_9F7E_C7DF90A88506#1093872, COL_0319BDA3_7106_4508_AF3E_C32CDF2C0BC2#1093875]

(11) HashAggregate
Input: []
Keys: []
Functions [1]: [partial_count(1)]
Aggregate Attributes [1]: [count#1094107L]
Results [1]: [count#1094108L]

(12) Exchange
Input [1]: [count#1094108L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=713003]

(13) HashAggregate
Input [1]: [count#1094108L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#1094104L]
Results [1]: [count(1)#1094104L AS count#1094105L]

(14) AdaptiveSparkPlan
Output [1]: [count#1094105L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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