SP1 - Details for Query 557

Submitted Time: 2026/06/25 16:37:50
Duration: 0.5 s
Succeeded Jobs: 764 765

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: 135 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 135 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: 8 ms metadata time: 0 ms size of files read: 312.5 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=30953]

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

Project

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263,COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267,COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270,COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275,COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277,COL_98B2878A_418E_4331_B333_2493994BB807#236278,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282,COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283,COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285,COL_D897344F_9AC3_429E_A95D_88390F445758#236286,... 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_405366], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63: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_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366]
ReadSchema: struct<COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399:string,COL_956F91E2_2027_457F_A229_B9CF20D9FF63:string,COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3:string,COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3:string,COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C:string,COL_FB65F162_1AB6_4971_99DA_F8A943944A66:string,COL_04BFCB87_D14B_4364_A366_6B179BF9CD20:string,COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C:string,COL_573E3A58_7401_4F3F_9EFA_058729D28B72:string,COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF:string,COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159:string,COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9:string,COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084:string,COL_C42F735E_237B_4569_996D_76FF5A4A65DF:string,COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214:string,COL_98B2878A_418E_4331_B333_2493994BB807:string,COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C:string,COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF:string,COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE:string,COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63:string,COL_E722B691_2CA2_4160_A578_D9CD4920A842:string,COL_D600764E_8D81_4891_BF21_ACC3F0938E57:string,COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5:string,COL_D897344F_9AC3_429E_A95D_88390F445758:string,COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9:string,COL_52167438_70F6_4E26_B5CD_17C5990F8948:string,COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17:string,COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3:string,COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539:string,COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9:string,COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6:string,COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9:string,COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49:string,COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7:string,COL_D0A8A26A_A602_4462_BBB1_8286F0724054:string,COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30:string,COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3:string,COL_1FF33786_C88A_4789_B428_364FF98B1905:string,COL_5CDC74F0_3D28_463C_9042_237BDAB52540:string,COL_8068E186_2734_4730_8D2C_A788B2226179:string,COL_DA667933_29E5_49E1_8724_A537DCE9735F:string,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4:string,COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7:string,COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458:string>

(2) ColumnarToRow [codegen id : 1]
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]

(3) Filter [codegen id : 1]
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS) END)

(4) Project [codegen id : 1]
Output: []
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#236762L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#236758L]
Results [1]: [count(1)#236758L AS count#236759L]

(9) Filter
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263)), MAISOSNS) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#236278)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#236286)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#236300)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_8068E186_2734_4730_8D2C_A788B2226179#236313)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316)), MAISOSNS) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS)) THEN false ELSE Contains(str_remove_accent(upper(COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317)), MAISOSNS) END)

(10) Project
Output: []
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#236263, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#236264, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#236265, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#236266, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#236267, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#236268, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#236269, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#236270, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#236271, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#236272, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#236273, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#236274, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#236275, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#236276, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#236277, COL_98B2878A_418E_4331_B333_2493994BB807#236278, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#236279, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#236280, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#236281, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#236282, COL_E722B691_2CA2_4160_A578_D9CD4920A842#236283, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#236284, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#236285, COL_D897344F_9AC3_429E_A95D_88390F445758#236286, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#236287, COL_52167438_70F6_4E26_B5CD_17C5990F8948#236288, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#236289, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#236290, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#236291, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#236292, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#236293, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#236294, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#236295, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#236296, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#236297, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#236298, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#236299, COL_1FF33786_C88A_4789_B428_364FF98B1905#236300, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#236311, COL_8068E186_2734_4730_8D2C_A788B2226179#236313, COL_DA667933_29E5_49E1_8724_A537DCE9735F#236314, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#236315, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#236316, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#236317]

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

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

(13) HashAggregate
Input [1]: [count#236762L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#236758L]
Results [1]: [count(1)#236758L AS count#236759L]

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

SQL / DataFrame Properties

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