SP1 - Details for Query 309

Submitted Time: 2026/02/20 09:26:16
Duration: 5 s
Succeeded Jobs: 443 453

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: 12 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 6 ms (0 ms, 0 ms, 0 ms (stage 593.0: task 856)) 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: 12 local bytes read: 708.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 12 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 192.0 B (16.0 B, 16.0 B, 16.0 B (stage 593.0: task 849)) local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 708.0 B (59.0 B, 59.0 B, 59.0 B (stage 593.0: task 849))"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n22.4 s (1.5 s, 1.9 s, 2.2 s (stage 593.0: task 857))"; 5 [labelType="html" label="HashAggregate time in aggregation build total (min, med, max (stageId: taskId)) 22.4 s (1.5 s, 1.9 s, 2.2 s (stage 593.0: task 857)) number of output rows: 12"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Filter number of output rows: 392,640"]; 8 [labelType="html" label="ColumnarToRow number of output rows: 392,884 number of input batches: 105"]; } 9 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 2.0 s (129 ms, 163 ms, 214 ms (stage 593.0: task 865)) metadata time: 0 ms size of files read: 37.5 MiB number of output rows: 392,884"]; 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=8983]

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

Project

Filter (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME) END)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065,COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066,COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067,COL_1753177C_310F_459F_B60F_D8279F254200#119068,COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069,COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070,COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071,COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072,COL_1A3D273D_5254_4898_803A_58E3623B835C#119073,COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074,COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075,COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076,COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077,COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078,COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079,COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080,COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081,COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082,COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083,COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084,COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085,COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086] Batched: true, DataFilters: [(((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A3..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/ADRESSES_BAN_CA_10435], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1:string,COL_5E5563FF_B70D_4AE7_9FED_D955CD414044:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
   * HashAggregate (8)
   +- ShuffleQueryStage (7), Statistics(sizeInBytes=192.0 B, rowCount=12)
      +- 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 [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/ADRESSES_BAN_CA_10435]
ReadSchema: struct<COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1:string,COL_5E5563FF_B70D_4AE7_9FED_D955CD414044:string,COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC:string,COL_1753177C_310F_459F_B60F_D8279F254200:string,COL_22C0BEEF_4622_472B_AF77_07C46E292915:string,COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0:string,COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D:string,COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF:string,COL_1A3D273D_5254_4898_803A_58E3623B835C:string,COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529:string,COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75:string,COL_4B38A300_F098_4F2A_9B89_7711DA0D809C:string,COL_FF30885E_08C8_4017_816C_3AFBE4E0E000:string,COL_A520CA67_7BF8_46BB_A4C4_3F940B189677:string,COL_757DB42B_A9EA_4B45_9974_BF3565574C1F:string,COL_6B25E25C_0F27_42CC_B16C_41A847361BBD:string,COL_DE290784_EE6E_4779_9AE7_112E03D12C20:string,COL_23F143BB_910A_4C97_ABE3_9107559239E4:string,COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647:string,COL_C799B90B_489B_43AB_A532_5026AAF71CBD:string,COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2:string,COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7:string>

(2) ColumnarToRow [codegen id : 1]
Input [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]

(3) Filter [codegen id : 1]
Input [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME) END)

(4) Project [codegen id : 1]
Output: []
Input [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]

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

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

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

(8) HashAggregate [codegen id : 2]
Input [1]: [count#119476L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#119363L]
Results [1]: [count(1)#119363L AS COL_396a9aba-a1b2-4f41-891c-e701e90b4fc1#119366L]

(9) Filter
Input [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]
Condition : (((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065)), ME) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1753177C_310F_459F_B60F_D8279F254200#119068)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_1A3D273D_5254_4898_803A_58E3623B835C#119073)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085)), ME) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME)) THEN false ELSE Contains(str_remove_accent(upper(COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086)), ME) END)

(10) Project
Output: []
Input [22]: [COL_48DEBBC3_307E_4CC1_A351_0D7C63E872F1#119065, COL_5E5563FF_B70D_4AE7_9FED_D955CD414044#119066, COL_2A62444E_76E1_4CC8_A223_EE9B22F027BC#119067, COL_1753177C_310F_459F_B60F_D8279F254200#119068, COL_22C0BEEF_4622_472B_AF77_07C46E292915#119069, COL_25DEAD41_6DAD_4907_8D12_4CD14E4F8AB0#119070, COL_63F205EF_59F6_43C2_93C8_DB1852A9E60D#119071, COL_2B1EBDFE_0C2E_4200_80DA_ECB41262B3FF#119072, COL_1A3D273D_5254_4898_803A_58E3623B835C#119073, COL_E8BAA0C1_0F7D_4B24_945C_02D86B3B4529#119074, COL_27CCC6A9_6108_4E23_BCCA_1FEFCF98BE75#119075, COL_4B38A300_F098_4F2A_9B89_7711DA0D809C#119076, COL_FF30885E_08C8_4017_816C_3AFBE4E0E000#119077, COL_A520CA67_7BF8_46BB_A4C4_3F940B189677#119078, COL_757DB42B_A9EA_4B45_9974_BF3565574C1F#119079, COL_6B25E25C_0F27_42CC_B16C_41A847361BBD#119080, COL_DE290784_EE6E_4779_9AE7_112E03D12C20#119081, COL_23F143BB_910A_4C97_ABE3_9107559239E4#119082, COL_0C786D7E_12E6_4DF3_8B7C_B7D8C54E4647#119083, COL_C799B90B_489B_43AB_A532_5026AAF71CBD#119084, COL_3026230D_4C48_41F3_A3CF_CDD069A2E7F2#119085, COL_922A7D75_BAD7_4E19_AEA0_958410E42DC7#119086]

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

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

(13) HashAggregate
Input [1]: [count#119476L]
Keys: []
Functions [1]: [count(1)]
Aggregate Attributes [1]: [count(1)#119363L]
Results [1]: [count(1)#119363L AS COL_396a9aba-a1b2-4f41-891c-e701e90b4fc1#119366L]

(14) AdaptiveSparkPlan
Output [1]: [COL_396a9aba-a1b2-4f41-891c-e701e90b4fc1#119366L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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