DC2 - Details for Query 46

Details for Query 46

Submitted Time: 2026/03/05 07:13:46
Duration: 0.9 s
Succeeded Jobs: 79 80 81 82 83

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))\n3 ms (0 ms, 0 ms, 2 ms (stage 135.0: task 386))"; 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))\n142 ms (4 ms, 8 ms, 50 ms (stage 135.0: task 386))"; 6 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 138.0: task 390)) peak memory total (min, med, max (stageId: taskId)) 768.8 MiB (64.0 KiB, 64.1 MiB, 64.1 MiB (stage 138.0: task 390)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 138.0: task 390))"]; 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))\n262 ms (8 ms, 14 ms, 92 ms (stage 135.0: task 386))"; 11 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 9 ms (0 ms, 1 ms, 2 ms (stage 141.0: task 396)) peak memory total (min, med, max (stageId: taskId)) 832.8 MiB (64.1 MiB, 64.1 MiB, 64.1 MiB (stage 138.0: task 390)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 138.0: task 390))"]; } 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.4 s (35 ms, 118 ms, 174 ms (stage 132.0: task 381)) 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 141.0: task 394)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 138.0: task 390)) 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 132.0: task 376)) 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 132.0: task 376))"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n1.4 s (37 ms, 114 ms, 155 ms (stage 132.0: task 383))"; 15 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 23 ms (1 ms, 2 ms, 2 ms (stage 132.0: task 384)) peak memory total (min, med, max (stageId: taskId)) 835.3 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 132.0: task 384)) number of output rows: 4,109 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 132.0: task 384))"]; } 16 [labelType="html" label=" CustomShuffleReader "]; 17 [labelType="html" label="Exchange shuffle records written: 4,109 shuffle write time total (min, med, max (stageId: taskId)) 269 ms (17 ms, 40 ms, 57 ms (stage 130.0: task 366)) 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 132.0: task 379)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 132.0: task 384)) 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 130.0: task 367)) 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 130.0: task 367))"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n638 ms (74 ms, 94 ms, 115 ms (stage 130.0: task 371))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 202 ms (12 ms, 24 ms, 55 ms (stage 130.0: task 371)) peak memory total (min, med, max (stageId: taskId)) 449.8 MiB (64.3 MiB, 64.3 MiB, 64.3 MiB (stage 130.0: task 372)) number of output rows: 4,109 avg hash probe bucket list iters (min, med, max (stageId: taskId)): (1, 1, 1 (stage 130.0: task 372))"]; 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)) 64 ms (7 ms, 8 ms, 12 ms (stage 130.0: task 367)) 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#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8921]

WholeStageCodegen (5)

Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711], [1 DESC NULLS LAST]

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

Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720]

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

WholeStageCodegen (4)

Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430], [1 DESC NULLS LAST]

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

WholeStageCodegen (3)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, 200), true, [id=#2246]

HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], functions=[])

WholeStageCodegen (2)

CustomShuffleReader coalesced

Exchange hashpartitioning(COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, 200), true, [id=#2183]

Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#8069), : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393]

Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)) <=> ))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060,COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068,COL_135AAA37_5078_4633_9560_24643D2CFC87#8069] Batched: true, DataFilters: [isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068))), NOT (str_rem..., 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#8889 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8911, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8890 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8912, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8891 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8913, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8892 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8914, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8893 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8915, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8894 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8916, COL_6E479219_3B64_4571_823A_81F623246F9D#8895 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8917, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8896 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8918, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8897 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8919, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8898 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8920, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8899 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8921]
      +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8867 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8889, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8868 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8890, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8869 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8891, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8870 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8892, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8871 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8893, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8872 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8894, COL_6E479219_3B64_4571_823A_81F623246F9D#8873 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8895, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8874 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8896, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8875 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8897, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8876 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8898, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8877 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8899]
         +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8867, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8868, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8869, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8870, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8871, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8872, COL_6E479219_3B64_4571_823A_81F623246F9D#8838 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8873, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8874, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8875, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8876, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8854 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8877]
            +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837, COL_6E479219_3B64_4571_823A_81F623246F9D#8838, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842), struct(col1, cast([ as string), col2, cast(" as string), col3, cast(] as string))) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8854]
               +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8810 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8811 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8812 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8813 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8814 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8815 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837, COL_6E479219_3B64_4571_823A_81F623246F9D#8816 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8838, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8817 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8818 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8819 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8820 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842]
                  +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8810, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8811, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8812, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8813, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8814, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8815, COL_6E479219_3B64_4571_823A_81F623246F9D#8717 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8816, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8817, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8818, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8819, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8820]
                     +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                        +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                           +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                              +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, CONST#8771 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711], [CONST#8771 DESC NULLS LAST]
                                 +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771]
                                    +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, 1 AS CONST#8771]
                                       +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8691 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8692 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8693 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8694 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8695 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8696 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8697 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8698 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8699 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8700 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720]
                                          +- Project [cast(RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8622 as string) AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8691, cast(RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8623 as int) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8692, cast(RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8624 as string) AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8693, cast(RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8625 as string) AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8694, cast(RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#8626 as string) AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8695, cast(RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8627 as string) AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8696, cast(RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8628 as string) AS COL_6E479219_3B64_4571_823A_81F623246F9D#8697, cast(RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8629 as string) AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8698, cast(RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8630 as string) AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8699, cast(RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8631 as string) AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8700]
                                             +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8592 AS RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8622, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8593 AS RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8623, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8594 AS RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8624, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8595 AS RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8625, COL_529A2CDA_302D_4393_8996_A08E791644E5#8596 AS RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#8626, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8597 AS RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8627, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8598 AS RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8628, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8599 AS RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8629, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8600 AS RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8630, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8601 AS RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8631]
                                                +- SubqueryAlias RESTITUTION_INT_36630116
                                                   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8592, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8593, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8594, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8595, COL_529A2CDA_302D_4393_8996_A08E791644E5#8561 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8596, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8597, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8598, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8599, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8600, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8601]
                                                      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 > cast(1 as int)) END
                                                         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560, COL_529A2CDA_302D_4393_8996_A08E791644E5#8561, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580]
                                                            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8542 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560, COL_529A2CDA_302D_4393_8996_A08E791644E5#8543 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8561, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8544 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8545 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8546 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8547 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8548 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8549 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569]
                                                               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8542, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8543, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8544, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8545, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8546, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8547, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8548, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8549, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, CONST#8508 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497], [CONST#8508 DESC NULLS LAST]
                                                                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508]
                                                                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 1 AS CONST#8508]
                                                                                    +- Filter true
                                                                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 1 AS NULL_1#8461]
                                                                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348)) <=> ))
                                                                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8343, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8344, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8349, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8350, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8351, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8352, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8353, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8354, COL_4604B800_0378_4F8E_B957_D2F501925904#8355, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8356, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8357, COL_B8026311_6449_4D27_9203_5E7E60E6927C#8358, COL_060F546C_380E_4202_B15D_53872F48E65E#8359, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8360, ... 5 more fields]
                                                                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8281 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8282 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8283 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8284 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8285 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8286 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8287 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8343, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8288 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8344, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8289 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8290 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8291 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8292 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8293 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8349, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8294 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8350, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8295 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8351, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8296 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8352, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8297 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8353, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8298 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8354, COL_4604B800_0378_4F8E_B957_D2F501925904#8299 AS COL_4604B800_0378_4F8E_B957_D2F501925904#8355, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8300 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8356, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8301 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8357, COL_B8026311_6449_4D27_9203_5E7E60E6927C#8302 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#8358, COL_060F546C_380E_4202_B15D_53872F48E65E#8303 AS COL_060F546C_380E_4202_B15D_53872F48E65E#8359, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8304 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8360, ... 4 more fields]
                                                                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#8175 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8281, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8176 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8282, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8177 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8283, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#8178 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8284, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8179 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8285, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8180 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8286, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#8181 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8287, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8182 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8288, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8183 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8289, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8184 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8290, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8185 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8291, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#8186 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8292, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8187 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8293, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8188 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8294, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8189 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8295, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8190 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8296, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8191 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8297, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8192 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8298, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8193 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#8299, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8194 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8300, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8195 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8301, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8196 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#8302, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8197 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#8303, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8198 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8304, ... 4 more fields]
                                                                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#8175, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8176, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8177, COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#8178, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8179, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8180, COL_F472560C_DB99_41F2_9279_7069140A9D65#8064 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#8181, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8065 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8182, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8183, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8184, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8185, COL_135AAA37_5078_4633_9560_24643D2CFC87#8069 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#8186, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8070 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8187, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8071 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8188, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8072 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8189, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8073 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8190, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8074 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8191, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8075 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8192, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8076 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8193, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8077 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8194, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8078 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8195, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8079 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8196, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8080 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8197, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8081 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8198, ... 15 more fields]
                                                                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#8058,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060,COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063,COL_F472560C_DB99_41F2_9279_7069140A9D65#8064,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8065,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068,COL_135AAA37_5078_4633_9560_24643D2CFC87#8069,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8070,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8071,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8072,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8073,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8074,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8075,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8076,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8077,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8078,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8079,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8080,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8081,... 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#8889 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8911, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8890 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8912, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8891 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8913, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8892 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8914, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8893 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8915, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8894 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8916, COL_6E479219_3B64_4571_823A_81F623246F9D#8895 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8917, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8896 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8918, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8897 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8919, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8898 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8920, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8899 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8921]
      +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8867 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8889, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8868 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8890, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8869 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8891, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8870 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8892, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8871 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8893, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8872 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8894, COL_6E479219_3B64_4571_823A_81F623246F9D#8873 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8895, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8874 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8896, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8875 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8897, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8876 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8898, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8877 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8899]
         +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8867, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8868, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8869, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8870, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8871, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8872, COL_6E479219_3B64_4571_823A_81F623246F9D#8838 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8873, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8874, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8875, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8876, COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8854 AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8877]
            +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837, COL_6E479219_3B64_4571_823A_81F623246F9D#8838, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842), struct(col1, cast([ as string), col2, cast(" as string), col3, cast(] as string))) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8854]
               +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8810 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8832, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8811 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8833, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8812 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8834, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8813 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8835, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8814 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8836, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8815 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8837, COL_6E479219_3B64_4571_823A_81F623246F9D#8816 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8838, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8817 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8839, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8818 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8840, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8819 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8841, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8820 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8842]
                  +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8810, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8811, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8812, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8813, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8814, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8815, COL_6E479219_3B64_4571_823A_81F623246F9D#8717 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8816, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8817, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8818, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8819, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784 AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8820]
                     +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                        +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                           +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784, COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784]
                              +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, CONST#8771 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711], [CONST#8771 DESC NULLS LAST]
                                 +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, CONST#8771]
                                    +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, 1 AS CONST#8771]
                                       +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8691 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8692 AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8693 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8694 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8695 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8696 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8697 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8698 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8699 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8700 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720]
                                          +- Project [cast(RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8622 as string) AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8691, cast(RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8623 as int) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8692, cast(RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8624 as string) AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8693, cast(RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8625 as string) AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8694, cast(RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#8626 as string) AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8695, cast(RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8627 as string) AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8696, cast(RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8628 as string) AS COL_6E479219_3B64_4571_823A_81F623246F9D#8697, cast(RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8629 as string) AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8698, cast(RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8630 as string) AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8699, cast(RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8631 as string) AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8700]
                                             +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8592 AS RESTITUTION_INT_36630_COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8622, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8593 AS RESTITUTION_INT_36630_COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8623, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8594 AS RESTITUTION_INT_36630_COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8624, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8595 AS RESTITUTION_INT_36630_COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8625, COL_529A2CDA_302D_4393_8996_A08E791644E5#8596 AS RESTITUTION_INT_36630_COL_529A2CDA_302D_4393_8996_A08E791644E5#8626, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8597 AS RESTITUTION_INT_36630_COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8627, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8598 AS RESTITUTION_INT_36630_COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8628, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8599 AS RESTITUTION_INT_36630_COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8629, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8600 AS RESTITUTION_INT_36630_COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8630, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8601 AS RESTITUTION_INT_36630_COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8631]
                                                +- SubqueryAlias RESTITUTION_INT_36630116
                                                   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8592, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8593, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8594, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8595, COL_529A2CDA_302D_4393_8996_A08E791644E5#8561 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8596, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8597, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8598, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8599, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8600, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8601]
                                                      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580 > cast(1 as int)) END
                                                         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560, COL_529A2CDA_302D_4393_8996_A08E791644E5#8561, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#8580]
                                                            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8542 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8560, COL_529A2CDA_302D_4393_8996_A08E791644E5#8543 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8561, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8544 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8562, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8545 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8563, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8546 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8564, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8547 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8565, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8548 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8566, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8549 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8567, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8568, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8569]
                                                               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8542, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8543, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8544, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8545, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8546, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8547, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8548, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8549, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520]
                                                                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, CONST#8508 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497], [CONST#8508 DESC NULLS LAST]
                                                                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, CONST#8508]
                                                                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 1 AS CONST#8508]
                                                                                    +- Filter true
                                                                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8490, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8491, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8492, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8493, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8494, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8495, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8496, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8497, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                                                                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 1 AS NULL_1#8461]
                                                                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348)) <=> ))
                                                                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8343, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8344, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8349, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8350, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8351, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8352, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8353, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8354, COL_4604B800_0378_4F8E_B957_D2F501925904#8355, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8356, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8357, COL_B8026311_6449_4D27_9203_5E7E60E6927C#8358, COL_060F546C_380E_4202_B15D_53872F48E65E#8359, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8360, ... 5 more fields]
                                                                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8281 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8282 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8283 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8284 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8285 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8286 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8287 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8343, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8288 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8344, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8289 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8290 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8291 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8347, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8292 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8348, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8293 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8349, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8294 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8350, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8295 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8351, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8296 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8352, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8297 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8353, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8298 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8354, COL_4604B800_0378_4F8E_B957_D2F501925904#8299 AS COL_4604B800_0378_4F8E_B957_D2F501925904#8355, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8300 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8356, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8301 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8357, COL_B8026311_6449_4D27_9203_5E7E60E6927C#8302 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#8358, COL_060F546C_380E_4202_B15D_53872F48E65E#8303 AS COL_060F546C_380E_4202_B15D_53872F48E65E#8359, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8304 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8360, ... 4 more fields]
                                                                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#8175 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8281, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8176 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8282, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8177 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8283, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#8178 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8284, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8179 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8285, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8180 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8286, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#8181 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#8287, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8182 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#8288, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8183 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8289, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8184 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8290, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8185 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#8291, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#8186 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#8292, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8187 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#8293, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8188 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#8294, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8189 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#8295, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8190 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#8296, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8191 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#8297, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8192 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#8298, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8193 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#8299, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8194 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#8300, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8195 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#8301, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8196 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#8302, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8197 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#8303, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8198 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#8304, ... 4 more fields]
                                                                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#8175, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8176, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8177, COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#8178, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8179, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8180, COL_F472560C_DB99_41F2_9279_7069140A9D65#8064 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#8181, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8065 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8182, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8183, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8184, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8185, COL_135AAA37_5078_4633_9560_24643D2CFC87#8069 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#8186, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8070 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8187, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8071 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8188, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8072 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8189, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8073 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8190, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8074 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8191, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8075 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8192, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8076 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8193, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8077 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8194, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8078 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8195, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8079 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8196, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8080 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8197, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8081 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8198, ... 15 more fields]
                                                                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#8058,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060,COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063,COL_F472560C_DB99_41F2_9279_7069140A9D65#8064,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8065,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068,COL_135AAA37_5078_4633_9560_24643D2CFC87#8069,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8070,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8071,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8072,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8073,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8074,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8075,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8076,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8077,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8078,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8079,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8080,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8081,... 15 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 500000
+- LocalLimit 500000
   +- Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8921]
      +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711], [1 DESC NULLS LAST]
         +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720]
            +- Filter (size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, true) > 1)
               +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430], [1 DESC NULLS LAST]
                  +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431]
                     +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#8069),  : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393]
                        +- Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)) <=> ))
                           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#8058,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060,COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063,COL_F472560C_DB99_41F2_9279_7069140A9D65#8064,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#8065,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068,COL_135AAA37_5078_4633_9560_24643D2CFC87#8069,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#8070,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#8071,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#8072,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#8073,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#8074,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#8075,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#8076,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#8077,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#8078,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#8079,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#8080,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#8081,... 15 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 500000
   +- *(5) Project [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720, str_remove_extend(str_list_as_str(COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784), [[,",]]) AS COL_C55223A2_5C14_46A7_9942_94CAD3BC5A01#8921]
      +- Window [collect_set(COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, 0, 0) windowspecdefinition(COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_0F04856A_106D_4375_A052_2C7D5BEACBCD#8784], [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711], [1 DESC NULLS LAST]
         +- *(4) Sort [COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
            +- *(4) Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 AS COL_885EF2A8_66E7_4326_BC5E_56A777137354#8711, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, true) AS COL_58BE9AE4_AA80_4182_8C74_38919733E869#8712, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431 AS COL_84042027_4CA3_42C5_A638_BF439A4B4C18#8713, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423 AS COL_73E296BB_1DB1_4159_BC67_F809779950FD#8714, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424 AS COL_5F9AC82F_7F24_4854_85AC_6D257CA58589#8715, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425 AS COL_FC81C657_1EC1_43EB_9D44_E9AA470EDF0E#8716, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426 AS COL_6E479219_3B64_4571_823A_81F623246F9D#8717, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427 AS COL_FCF7F65D_907E_4A19_BD9A_1388AD94C2C4#8718, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428 AS COL_B4A236FE_ACA5_4BB2_B88D_B9D4614A9B3A#8719, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429 AS COL_2139BBE5_81B3_4254_AEF8_1E5E0E0FE9C3#8720]
               +- *(4) Filter (size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520, true) > 1)
                  +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#8520], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430], [1 DESC NULLS LAST]
                     +- *(3) Sort [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
                        +- CustomShuffleReader coalesced
                           +- ShuffleQueryStage 1
                              +- Exchange hashpartitioning(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, 200), true, [id=#2246]
                                 +- *(2) HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], functions=[], output=[COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#8423, COL_529A2CDA_302D_4393_8996_A08E791644E5#8424, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#8425, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#8426, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#8427, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#8428, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#8429, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#8430, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#8431])
                                    +- CustomShuffleReader coalesced
                                       +- ShuffleQueryStage 0
                                          +- Exchange hashpartitioning(COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, 200), true, [id=#2183]
                                             +- *(1) HashAggregate(keys=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346], functions=[], output=[COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346])
                                                +- *(1) Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#8337, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#8338, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#8339, COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#8340, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#8341, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#8342, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#8345, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#8346, str_join(struct(COL_150B0931_34AC_4D78_8109_D4EBA65241F1, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068, COL_00BEC462_2347_490F_8A34_44A7472FB8C1, COL_135AAA37_5078_4633_9560_24643D2CFC87#8069),  : ) AS COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#8393]
                                                   +- *(1) Filter (((isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068))) AND NOT (str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068)) <=> )) AND isnotnull(str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)))) AND NOT (str_remove_accent(upper(COL_135AAA37_5078_4633_9560_24643D2CFC87#8069)) <=> ))
                                                      +- *(1) ColumnarToRow
                                                         +- FileScan parquet [COL_59E3B457_6564_4E84_B090_99EAA1987944#8058,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#8059,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#8060,COL_413BE7B8_1BFE_4393_A802_209E3937124C#8061,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#8062,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#8063,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#8066,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#8067,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068,COL_135AAA37_5078_4633_9560_24643D2CFC87#8069] Batched: true, DataFilters: [isnotnull(str_remove_accent(upper(COL_ED782DEA_98D7_422B_924C_9886EC161B9C#8068))), NOT (str_rem..., 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...