SP1 - Details for Query 469

Submitted Time: 2026/06/25 16:31:27
Duration: 0.6 s
Succeeded Jobs: 647 648

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: 1 local merged chunks fetched: 0 shuffle write time: 0 ms 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: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 16.0 B 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: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 131 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 131 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 1"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 10 ms metadata time: 0 ms size of files read: 276.8 KiB number of output rows: 1,455"]; 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=26485]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782,COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790,COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792,COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798,COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804,COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805,... 20 more fields] Batched: true, DataFilters: [(((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=16.0 B, rowCount=1)
      +- 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 [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206]
ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:string,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB:string,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA:string,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929:string,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B:string,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E:string,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93:string,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355:string,COL_D4E1F01A_72C8_4621_905A_881FB0249F81:string,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED:string,COL_871E0000_AA32_4679_83B0_C8AA49007BCF:string,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8:string,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C:string,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7:string,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB:string,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC:string,COL_0DB61D05_5348_40DB_8F16_C7916849A669:string,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96:string,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C:string,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38:string,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB:string,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A:string,COL_33CEA792_75B9_44A1_896B_B422BD28B923:string,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48:string,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25:string,COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5:string,COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267:string,COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27:string,COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2:string,COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23:string,COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC:string,COL_924860D6_14C4_4F33_B84C_E428E89E2817:string,COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C:string,COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF:string,COL_730C7D9D_95B5_4388_983E_C4F260C553BD:string,COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D:string,COL_90791789_DD87_40BC_92F0_F5FB1BD5126F:string,COL_FB26292A_034B_4B72_8403_8A7AE83CFC56:string,COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E:string,COL_FC403537_BB94_4C83_AC18_B668C51A4E0A:string,COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142:string,COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4:string,COL_0798550D_6632_4F18_8CE3_72BAF75D68CC:string>

(2) ColumnarToRow [codegen id : 1]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]

(3) Filter [codegen id : 1]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS) END)

(4) Project [codegen id : 1]
Output: []
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#207182L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#207178L]
Results [1]: [count(1)#207178L AS count#207179L]

(9) Filter
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825)), MAISOSNS) END)

(10) Project
Output: []
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#206782, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#206783, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#206784, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#206785, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#206786, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#206787, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#206788, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#206789, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#206790, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#206791, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#206792, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#206793, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#206794, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#206795, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#206796, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#206797, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#206798, COL_0DB61D05_5348_40DB_8F16_C7916849A669#206799, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#206800, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#206801, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#206802, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#206803, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#206804, COL_33CEA792_75B9_44A1_896B_B422BD28B923#206805, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#206806, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#206807, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#206808, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#206809, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#206810, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#206811, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#206812, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#206813, COL_924860D6_14C4_4F33_B84C_E428E89E2817#206814, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#206815, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#206816, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#206817, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#206818, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#206819, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#206820, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#206821, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#206822, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#206823, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#206824, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#206825]

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

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

(13) HashAggregate
Input [1]: [count#207182L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#207178L]
Results [1]: [count(1)#207178L AS count#207179L]

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

SQL / DataFrame Properties

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