SP1 - Details for Query 17586

Submitted Time: 2026/06/10 16:03:24
Duration: 1.3 min
Failed Jobs: 23926

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" HashAggregate "]; 2 [labelType="html" label="Exchange shuffle records written: 9 shuffle write time total (min, med, max (stageId: taskId)) 13 ms (0 ms, 0 ms, 7 ms (stage 45084.0: task 64478)) data size total (min, med, max (stageId: taskId)) 144.0 B (0.0 B, 16.0 B, 16.0 B (stage 45084.0: task 64483)) number of partitions: 1 shuffle bytes written total (min, med, max (stageId: taskId)) 507.0 B (0.0 B, 56.0 B, 59.0 B (stage 45084.0: task 64486))"]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n50.6 s (0 ms, 9 ms, 50.5 s (stage 45084.0: task 64486))"; 4 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 50.6 s (0 ms, 8 ms, 50.5 s (stage 45084.0: task 64486)) number of output rows: 9"]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="Filter number of output rows: 354"]; 7 [labelType="html" label="ColumnarToRow number of output rows: 2,493,718 number of input batches: 609"]; } 8 [labelType="html" label="Scan parquet number of files read: 1 scan time total (min, med, max (stageId: taskId)) 1.5 s (5 ms, 8 ms, 883 ms (stage 45084.0: task 64481)) metadata time: 0 ms size of files read: 192.7 MiB number of output rows: 2,493,718"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; }

AdaptiveSparkPlan isFinalPlan=false

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

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=1826020]

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

Project

Filter ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS N) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478,COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479,COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480,COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481,COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492,COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495,COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496,COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497,COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498,COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499,COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500,COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501,COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502,COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503,COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505,COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506] Batched: true, DataFilters: [((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_..., 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)
+- == Current Plan ==
   HashAggregate (8)
   +- ShuffleQueryStage (7)
      +- 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 [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
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_410747F2_ADCB_4C39_B9B9_C56104DAC484:string,COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5: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 [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]

(3) Filter [codegen id : 1]
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS  N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS  N) END)

(4) Project [codegen id : 1]
Output: []
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]

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

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

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

(8) HashAggregate
Input [1]: [count#3888898L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888894L]
Results [1]: [count(1)#3888894L AS count#3888895L]

(9) Filter
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]
Condition : ((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478)), CS  N) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505)), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE))), CS  N) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS  N)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(((((str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS N)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> CS F)) OR (str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE) <=> APC)), str_join(array(str_remove_space(str_if_with_rule((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> M), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 75, 13), str_if_with_rule(((COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> B) OR (COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481 <=> C)), str_extract_middle(COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, 78, 5), )), ONLY_ONE), COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492), -), null))), CS  N) END)

(10) Project
Output: []
Input [17]: [COL_E76BCE3C_BF78_45B5_AC59_423A3A530FDF#3888478, COL_BE49822F_A205_4FD0_A5F5_1ABDFCD80730#3888479, COL_D16817E6_135B_4508_A082_6C19AC9542DE#3888480, COL_2EE853AF_4512_4E8D_ABAE_19143D81E357#3888481, COL_410747F2_ADCB_4C39_B9B9_C56104DAC484#3888491, COL_5B3AE451_2124_43B3_BCB6_E3909D1A82B5#3888492, COL_4C51DBB4_9E17_4325_B57F_BB66A8D4447A#3888495, COL_07AE9250_614D_4D42_854B_0EDF3D549B40#3888496, COL_E47A29D8_B894_4EA7_9704_C8925EA0E40A#3888497, COL_06D0B7A1_9E5A_4504_BE77_E30488C56572#3888498, COL_CEE56FBE_FB43_4BFA_8BC4_DDC4884936F7#3888499, COL_F76740BC_E84C_42AE_9492_D66CDA0E9344#3888500, COL_D2CE76B4_5970_4784_AE1B_4D590C2D5F9B#3888501, COL_BFA8E75B_6083_4911_8D50_3443279CCEC8#3888502, COL_86734EEA_482B_4537_86F3_6ACCB97C98E9#3888503, COL_119C9448_3C3F_46EA_80E7_062422A2830D#3888505, COL_06CB38F0_2321_426B_AA44_D37094826BC3#3888506]

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

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

(13) HashAggregate
Input [1]: [count#3888898L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#3888894L]
Results [1]: [count(1)#3888894L AS count#3888895L]

(14) AdaptiveSparkPlan
Output [1]: [count#3888895L]
Arguments: isFinalPlan=false

SQL / DataFrame Properties

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