DC2 - Details for Query 91

Details for Query 91

Submitted Time: 2025/11/07 08:58:40
Duration: 0.9 s
Succeeded Jobs: 142 143 144 145 146

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n2 ms (0 ms, 0 ms, 2 ms (stage 203.0: task 521))"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label=" Window "]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n148 ms (5 ms, 9 ms, 44 ms (stage 203.0: task 521))"; 6 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 206.0: task 524)) peak memory total (min, med, max (stageId: taskId)) 768.8 MiB (64.0 KiB, 64.1 MiB, 64.1 MiB (stage 206.0: task 524)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 206.0: task 524))"]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="Filter number of output rows: 72"]; } 9 [labelType="html" label=" Window "]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n260 ms (8 ms, 15 ms, 85 ms (stage 203.0: task 521))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 4 ms (0 ms, 0 ms, 4 ms (stage 209.0: task 529)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 206.0: task 524)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 206.0: task 524))"]; } 12 [labelType="html" label=" CustomShuffleReader "]; 13 [labelType="html" label="Exchange shuffle records written: 4,109 shuffle write time total (min, med, max (stageId: taskId)) 1.6 s (36 ms, 126 ms, 180 ms (stage 200.0: task 510)) records read: 4,109 local bytes read total (min, med, max (stageId: taskId)) 738.5 KiB (24.2 KiB, 59.5 KiB, 61.4 KiB (stage 209.0: task 529)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 206.0: task 524)) remote bytes read: 0.0 B local blocks read: 169 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 812.1 KiB (27.1 KiB, 65.5 KiB, 67.3 KiB (stage 200.0: task 511)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 738.5 KiB (27.7 KiB, 59.4 KiB, 60.5 KiB (stage 200.0: task 511))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n957 ms (16 ms, 84 ms, 106 ms (stage 200.0: task 508))"; 15 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 38 ms (1 ms, 2 ms, 16 ms (stage 200.0: task 508)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 200.0: task 514)) number of output rows: 4,109 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 200.0: task 514))"]; } 16 [labelType="html" label=" CustomShuffleReader "]; 17 [labelType="html" label="Exchange shuffle records written: 4,109 shuffle write time total (min, med, max (stageId: taskId)) 358 ms (20 ms, 46 ms, 73 ms (stage 198.0: task 504)) records read: 4,109 local bytes read total (min, med, max (stageId: taskId)) 665.4 KiB (22.2 KiB, 53.6 KiB, 55.0 KiB (stage 200.0: task 514)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 200.0: task 514)) remote bytes read: 0.0 B local blocks read: 91 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 812.1 KiB (23.4 KiB, 131.0 KiB, 135.2 KiB (stage 198.0: task 502)) remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 665.4 KiB (23.9 KiB, 106.4 KiB, 109.7 KiB (stage 198.0: task 502))"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n669 ms (49 ms, 102 ms, 124 ms (stage 198.0: task 506))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 208 ms (6 ms, 32 ms, 46 ms (stage 198.0: task 503)) peak memory total (min, med, max (stageId: taskId)) 449.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 198.0: task 507)) number of output rows: 4,109 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 198.0: task 507))"]; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label="Filter number of output rows: 5,670"]; 22 [labelType="html" label="ColumnarToRow number of output rows: 9,747 number of input batches: 13"]; } 23 [labelType="html" label="Scan parquet number of files read: 13 scan time total (min, med, max (stageId: taskId)) 122 ms (5 ms, 17 ms, 34 ms (stage 198.0: task 506)) metadata time: 0 ms size of files read: 1661.7 KiB number of output rows: 9,747"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 15->13; 16->15; 17->16; 19->17; 20->19; 21->20; 22->21; 23->22; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25681]

WholeStageCodegen (5)

Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512], [1 DESC NULLS LAST]

Sort [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521]

Filter (size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) > 1)

WholeStageCodegen (4)

Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190], [1 DESC NULLS LAST]

Sort [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, 200), true, [id=#3763]

HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, 200), true, [id=#3700]

Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829), : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153]

Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)) <=> ))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829] Batched: true, DataFilters: [isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828))), NOT (str_re..., Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_59E3B457_6564_4E84_B090_99EAA1987944:string,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7:s...

Details

== Parsed Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25649 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25671, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25650 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25672, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25651 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25673, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25652 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25674, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25653 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25675, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25654 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25676, COL_6E479219_3B64_4571_823A_81F623246F9D#25655 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25677, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25656 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25678, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25657 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25679, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25658 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25680, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25659 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25681]
      +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25627 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25649, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25628 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25650, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25629 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25651, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25630 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25652, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25631 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25653, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25632 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25654, COL_6E479219_3B64_4571_823A_81F623246F9D#25633 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25655, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25634 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25656, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25635 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25657, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25636 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25658, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25637 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25659]
         +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25627, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25628, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25629, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25630, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25631, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25632, COL_6E479219_3B64_4571_823A_81F623246F9D#25598 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25633, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25634, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25635, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25636, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25614 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25637]
            +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597, COL_6E479219_3B64_4571_823A_81F623246F9D#25598, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602), struct(col1, cast([ as string), col2, cast(" as string), col3, cast(] as string))) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25614]
               +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25570 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25571 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25572 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25573 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25574 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25575 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597, COL_6E479219_3B64_4571_823A_81F623246F9D#25576 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25598, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25577 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25578 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25579 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25580 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602]
                  +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25570, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25571, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25572, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25573, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25574, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25575, COL_6E479219_3B64_4571_823A_81F623246F9D#25518 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25576, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25577, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25578, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25579, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25580]
                     +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                        +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                           +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                              +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, CONST#25533 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512], [CONST#25533 DESC NULLS LAST]
                                 +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533]
                                    +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, 1 AS CONST#25533]
                                       +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25492 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25493 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25494 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25495 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25496 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25497 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25498 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25499 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25500 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25501 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521]
                                          +- Project [cast(RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25421 as string) AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25492, cast(RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25422 as int) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25493, cast(RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25423 as string) AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25494, cast(RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25424 as string) AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25495, cast(RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#25425 as string) AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25496, cast(RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25426 as string) AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25497, cast(RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25427 as string) AS COL_6E479219_3B64_4571_823A_81F623246F9D#25498, cast(RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25428 as string) AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25499, cast(RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25429 as string) AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25500, cast(RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25430 as string) AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25501]
                                             +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352 AS RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25421, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353 AS RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25422, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354 AS RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25423, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355 AS RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25424, COL_529A2CDA_302D_4393_8996_A08E791644E5#25356 AS RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#25425, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357 AS RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25426, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358 AS RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25427, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359 AS RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25428, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360 AS RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25429, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361 AS RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25430]
                                                +- SubqueryAlias RESTITUTION_INT_36630116
                                                   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
                                                      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
                                                         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
                                                            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
                                                               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                                                                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                                                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                                                                    +- Filter true
                                                                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Analyzed Logical Plan ==
COL_885EF2A8_66E7_4326_BC5E_56A777137354: string, COL_58BE9AE4_AA80_4182_8C74_38919733E869: int, COL_84042027_4CA3_42C5_A638_BF439A4B4C18: string, COL_73E296BB_1DB1_4159_BC67_F809779950FD: string, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589: string, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E: string, COL_6E479219_3B64_4571_823A_81F623246F9D: string, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4: string, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A: string, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3: string, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01: string
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25649 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25671, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25650 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25672, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25651 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25673, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25652 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25674, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25653 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25675, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25654 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25676, COL_6E479219_3B64_4571_823A_81F623246F9D#25655 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25677, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25656 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25678, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25657 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25679, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25658 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25680, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25659 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25681]
      +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25627 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25649, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25628 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25650, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25629 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25651, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25630 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25652, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25631 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25653, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25632 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25654, COL_6E479219_3B64_4571_823A_81F623246F9D#25633 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25655, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25634 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25656, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25635 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25657, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25636 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25658, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25637 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25659]
         +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25627, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25628, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25629, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25630, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25631, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25632, COL_6E479219_3B64_4571_823A_81F623246F9D#25598 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25633, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25634, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25635, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25636, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25614 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25637]
            +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597, COL_6E479219_3B64_4571_823A_81F623246F9D#25598, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602), struct(col1, cast([ as string), col2, cast(" as string), col3, cast(] as string))) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25614]
               +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25570 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25592, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25571 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25593, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25572 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25594, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25573 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25595, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25574 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25596, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25575 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25597, COL_6E479219_3B64_4571_823A_81F623246F9D#25576 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25598, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25577 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25599, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25578 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25600, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25579 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25601, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25580 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25602]
                  +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25570, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25571, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25572, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25573, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25574, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25575, COL_6E479219_3B64_4571_823A_81F623246F9D#25518 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25576, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25577, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25578, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25579, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25580]
                     +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                        +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                           +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546]
                              +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, CONST#25533 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512], [CONST#25533 DESC NULLS LAST]
                                 +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, CONST#25533]
                                    +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, 1 AS CONST#25533]
                                       +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25492 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25493 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25494 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25495 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25496 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25497 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25498 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25499 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25500 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25501 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521]
                                          +- Project [cast(RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25421 as string) AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25492, cast(RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25422 as int) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25493, cast(RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25423 as string) AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25494, cast(RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25424 as string) AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25495, cast(RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#25425 as string) AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25496, cast(RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25426 as string) AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25497, cast(RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25427 as string) AS COL_6E479219_3B64_4571_823A_81F623246F9D#25498, cast(RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25428 as string) AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25499, cast(RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25429 as string) AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25500, cast(RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25430 as string) AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25501]
                                             +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352 AS RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25421, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353 AS RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25422, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354 AS RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25423, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355 AS RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25424, COL_529A2CDA_302D_4393_8996_A08E791644E5#25356 AS RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#25425, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357 AS RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25426, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358 AS RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25427, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359 AS RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25428, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360 AS RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25429, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361 AS RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25430]
                                                +- SubqueryAlias RESTITUTION_INT_36630116
                                                   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
                                                      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
                                                         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
                                                            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
                                                               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                                                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                                                                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                                                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                                                                    +- Filter true
                                                                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25681]
      +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512], [1 DESC NULLS LAST]
         +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521]
            +- Filter (size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) > 1)
               +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190], [1 DESC NULLS LAST]
                  +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                     +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829),  : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153]
                        +- Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)) <=> ))
                           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(5) Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#25681]
      +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#25546], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512], [1 DESC NULLS LAST]
         +- *(4) Sort [COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
            +- *(4) Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#25512, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#25513, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#25514, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#25515, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#25516, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#25517, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_6E479219_3B64_4571_823A_81F623246F9D#25518, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#25519, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#25520, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#25521]
               +- *(4) Filter (size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, true) > 1)
                  +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190], [1 DESC NULLS LAST]
                     +- *(3) Sort [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
                        +- CustomShuffleReader coalesced
                           +- ShuffleQueryStage 1
                              +- Exchange hashpartitioning(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, 200), true, [id=#3763]
                                 +- *(2) HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], functions=[], output=[COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191])
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 0
                                          +- Exchange hashpartitioning(COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, 200), true, [id=#3700]
                                             +- *(1) HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], functions=[], output=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106])
                                                +- *(1) Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829),  : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153]
                                                   +- *(1) Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#24829)) <=> ))
                                                      +- *(1) ColumnarToRow
                                                         +- FileScan parquet [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829] Batched: true, DataFilters: [isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828))), NOT (str_re..., Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/UNION_CONSOLIDA_32798], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_59E3B457_6564_4E84_B090_99EAA1987944:string,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7:s...