SP1 - Details for Query 17582

Submitted Time: 2026/06/10 16:01:01
Duration: 1.3 min
Succeeded Jobs: 23919 23923

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)) 10 ms (0 ms, 0 ms, 3 ms (stage 45076.0: task 64457)) 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: 566.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 45076.0: task 64456)) 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)) 566.0 B (56.0 B, 56.0 B, 59.0 B (stage 45076.0: task 64463))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.9 m (3 ms, 10 ms, 1.3 m (stage 45076.0: task 64458))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 1.9 m (2 ms, 10 ms, 1.3 m (stage 45076.0: task 64458)) number of output rows: 10"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 85"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 2,996,010 number of input batches: 732"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 2.5 s (2 ms, 10 ms, 1.6 s (stage 45076.0: task 64458)) metadata time: 0 ms size of files read: 192.7 MiB number of output rows: 2,996,010"]; 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=1825943]

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

Project

Filter (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS F) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719,COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721,COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723,COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724,COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725,COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726,COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727,COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728,COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729,COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732,COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743,... 2 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730: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 [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_A_RSF_SOURCE_215882]
ReadSchema: struct<COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF:string,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730:string,COL_D16817E6_135B_4508_A082_6C19AC9542DE:string,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357:string,COL_71C73F12_7D79_456A_A833_96D8469F46F2:string,COL_E9867A66_711B_4AA1_A283_E4318900C80F:string,COL_DECBC528_D590_4F99_88FD_C86D82DEF299:string,COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6:string,COL_15227A48_1CE9_407E_A0B2_D27AC3B06473:string,COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1:string,COL_6DFC44EF_67E4_461D_912F_4BA7773246D2:string,COL_553A0519_208D_498B_AEFE_829D7F40180B:string,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5:string,COL_A655765E_D1A6_4D67_8879_F5186F86A670:string,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A:string,COL_07AE9250_614D_4D42_854B_0EDF3D549B40:string,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A:string,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572:string,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7:string,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344:string,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B:string,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8:string,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9:string,COL_119C9448_3C3F_46EA_80E7_062422A2830D:string,COL_06CB38F0_2321_426B_AA44_D37094826BC3:string>

(2) ColumnarToRow [codegen id : 1]
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]

(3) Filter [codegen id : 1]
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Condition : (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS  F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS  F) END)

(4) Project [codegen id : 1]
Output: []
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#3888070L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888066L]
Results [1]: [count(1)#3888066L AS count#3888067L]

(9) Filter
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]
Condition : (((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718)), CS  F) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745)), CS  F) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS  F)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746)), CS  F) END)

(10) Project
Output: []
Input [26]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3887718, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3887719, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3887720, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3887721, COL_71C73F12_7D79_456A_A833_96D8469F46F2#3887723, COL_E9867A66_711B_4AA1_A283_E4318900C80F#3887724, COL_DECBC528_D590_4F99_88FD_C86D82DEF299#3887725, COL_C254B56D_F8F4_4AD3_9C99_13F3169B95F6#3887726, COL_15227A48_1CE9_407E_A0B2_D27AC3B06473#3887727, COL_0C04F325_B8B8_403D_9AC4_801D7096DFF1#3887728, COL_6DFC44EF_67E4_461D_912F_4BA7773246D2#3887729, COL_553A0519_208D_498B_AEFE_829D7F40180B#3887730, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3887731, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3887732, COL_A655765E_D1A6_4D67_8879_F5186F86A670#3887734, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3887735, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3887736, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3887737, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3887738, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3887739, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3887740, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3887741, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3887742, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3887743, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3887745, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3887746]

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

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

(13) HashAggregate
Input [1]: [count#3888070L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888066L]
Results [1]: [count(1)#3888066L AS count#3888067L]

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

SQL / DataFrame Properties

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