DC2 - Details for Query 90

Details for Query 90

Submitted Time: 2025/11/07 08:58:40
Duration: 1 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                    +- Filter true
                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                    +- Filter true
                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
   +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
      +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
         +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
            +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                           +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                 +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                    +- Filter true
                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                          +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                   +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                      +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                         +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                            +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                               +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                  +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                     +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
         +- Project [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25352, COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25353, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25354, COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25355, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25356, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25357, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25358, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25359, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25360, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25361]
            +- Filter CASE WHEN isnull((COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int))) THEN false ELSE (COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340 > cast(1 as int)) END
               +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, size(COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329, true) AS COL_978EDAC2_DE0D_4390_8C2A_7F86578E4C05#25340]
                  +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25320, COL_529A2CDA_302D_4393_8996_A08E791644E5#25303 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25321, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25322, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25323, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25324, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25325, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25326, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25327, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25328, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280 AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25329]
                     +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25302, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25303, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25304, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25305, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25306, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25307, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25308, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25309, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                        +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                           +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                              +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280, COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280]
                                 +- Window [collect_set(COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 0, 0) windowspecdefinition(COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, CONST#25268 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_8E35C1B7_0AF5_4404_9ABF_980A8FB74ED7#25280], [COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257], [CONST#25268 DESC NULLS LAST]
                                    +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, CONST#25268]
                                       +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS CONST#25268]
                                          +- Filter true
                                             +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25250, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25251, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25252, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25253, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25254, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25255, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25256, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25257, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                   +- Project [COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191]
                                                      +- Aggregate [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106], [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097 AS COL_D31CB402_92FE_41EA_AC94_379B7FF5986D#25183, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098 AS COL_529A2CDA_302D_4393_8996_A08E791644E5#25184, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105 AS COL_5DE12B1C_BF1A_4ED5_8C6A_9931B37487C1#25185, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099 AS COL_9E4B1E4C_0B68_44AC_A70B_1FC85132AF04#25186, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100 AS COL_69540D23_5653_4BEC_BB6C_68B1B52522D4#25187, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101 AS COL_CCF603B3_4639_4427_A26E_A0C6E2E8FA77#25188, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102 AS COL_FDBB3A16_1AED_4EC9_B823_8A8A2EEA948C#25189, COL_B2029A17_E2E6_4E9A_958F_6DEF3A26E10A#25153 AS COL_F4E7D2F4_2F2D_43EC_BEF1_9A90F48FD2FF#25190, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106 AS COL_DB4C56D7_62D8_4AB7_824A_29AC7D7DBADF#25191, 1 AS NULL_1#25221]
                                                         +- Filter (((isnotnull(str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107))) AND NOT (str_remove_accent(upper(COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107)) <=> )) AND isnotnull(str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)))) AND NOT (str_remove_accent(upper(COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108)) <=> ))
                                                            +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 5 more fields]
                                                               +- Project [COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041 AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25097, COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042 AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25098, COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043 AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25099, COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044 AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25100, COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045 AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25101, COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046 AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25102, COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047 AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25103, COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048 AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25104, COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049 AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25105, COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050 AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25106, COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051 AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25107, COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052 AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25108, COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053 AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25109, COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054 AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25110, COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055 AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25111, COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056 AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25112, COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057 AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25113, COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058 AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25114, COL_4604B800_0378_4F8E_B957_D2F501925904#25059 AS COL_4604B800_0378_4F8E_B957_D2F501925904#25115, COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060 AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25116, COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061 AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25117, COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062 AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25118, COL_060F546C_380E_4202_B15D_53872F48E65E#25063 AS COL_060F546C_380E_4202_B15D_53872F48E65E#25119, COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064 AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25120, ... 4 more fields]
                                                                  +- Project [cast(UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935 as string) AS COL_FD0FB8EC_184F_4188_98FB_566EE0DC3888#25041, cast(UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936 as string) AS COL_372E2D8E_C261_4BC7_9445_8B434F78D40C#25042, cast(UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937 as string) AS COL_59ECE9A5_6132_4DDE_8EDC_7B1708894C02#25043, cast(UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938 as string) AS COL_82185564_82DA_483F_B132_4BC5C2F9A912#25044, cast(UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939 as string) AS COL_F91FC147_2F9D_4162_8442_194EDD33AC47#25045, cast(UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940 as string) AS COL_A1F94612_AF0B_4C2C_82B0_F7F4A362E97C#25046, cast(UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941 as string) AS COL_DFDB7EEE_D35B_48F8_B151_D5C0CF6BE870#25047, cast(UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942 as string) AS COL_19527334_C1A9_4AB0_A0C3_AFD9A02964F6#25048, cast(UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943 as string) AS COL_4FB2E663_F3C9_45CD_9FA8_DDCEF8A456C6#25049, cast(UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944 as string) AS COL_E2BE01B5_67EC_4691_8938_0F8DE7ACE804#25050, cast(UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945 as string) AS COL_150B0931_34AC_4D78_8109_D4EBA65241F1#25051, cast(UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946 as string) AS COL_00BEC462_2347_490F_8A34_44A7472FB8C1#25052, cast(UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947 as int) AS COL_666F09A9_4BF3_46EC_B1C5_CCE60367D79B#25053, cast(UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948 as string) AS COL_99968DEB_76D0_4970_B3A1_21F74FF5DD9B#25054, cast(UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949 as string) AS COL_DF4DAB41_B707_483C_BE53_A85E9704D94B#25055, cast(UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950 as string) AS COL_E21C1546_9516_44C2_BCF7_C2B429B44A98#25056, cast(UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951 as string) AS COL_DC6C893F_7144_4966_8B19_EDEC5AAD300B#25057, cast(UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952 as string) AS COL_9B776B1C_0E0C_4BD1_BA71_802501DE645E#25058, cast(UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953 as string) AS COL_4604B800_0378_4F8E_B957_D2F501925904#25059, cast(UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954 as string) AS COL_78634BBE_FCBE_4706_A0E5_6CC766FF07FF#25060, cast(UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955 as string) AS COL_70CC34A0_D3F4_4382_BD4D_B2736BAC9D64#25061, cast(UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956 as string) AS COL_B8026311_6449_4D27_9203_5E7E60E6927C#25062, cast(UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957 as string) AS COL_060F546C_380E_4202_B15D_53872F48E65E#25063, cast(UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958 as string) AS COL_63899E38_4B58_4DDA_9D20_7787132CE3B9#25064, ... 4 more fields]
                                                                     +- Project [COL_59E3B457_6564_4E84_B090_99EAA1987944#24818 AS UNION_CONSOLIDA_32798_COL_59E3B457_6564_4E84_B090_99EAA1987944#24935, COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819 AS UNION_CONSOLIDA_32798_COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24936, COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820 AS UNION_CONSOLIDA_32798_COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24937, COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821 AS UNION_CONSOLIDA_32798_COL_413BE7B8_1BFE_4393_A802_209E3937124C#24938, COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822 AS UNION_CONSOLIDA_32798_COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24939, COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823 AS UNION_CONSOLIDA_32798_COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24940, COL_F472560C_DB99_41F2_9279_7069140A9D65#24824 AS UNION_CONSOLIDA_32798_COL_F472560C_DB99_41F2_9279_7069140A9D65#24941, COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825 AS UNION_CONSOLIDA_32798_COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24942, COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826 AS UNION_CONSOLIDA_32798_COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24943, COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827 AS UNION_CONSOLIDA_32798_COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24944, COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828 AS UNION_CONSOLIDA_32798_COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24945, COL_135AAA37_5078_4633_9560_24643D2CFC87#24829 AS UNION_CONSOLIDA_32798_COL_135AAA37_5078_4633_9560_24643D2CFC87#24946, COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830 AS UNION_CONSOLIDA_32798_COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24947, COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831 AS UNION_CONSOLIDA_32798_COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24948, COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832 AS UNION_CONSOLIDA_32798_COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24949, COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833 AS UNION_CONSOLIDA_32798_COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24950, COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834 AS UNION_CONSOLIDA_32798_COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24951, COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835 AS UNION_CONSOLIDA_32798_COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24952, COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836 AS UNION_CONSOLIDA_32798_COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24953, COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837 AS UNION_CONSOLIDA_32798_COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24954, COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838 AS UNION_CONSOLIDA_32798_COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24955, COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839 AS UNION_CONSOLIDA_32798_COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24956, COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840 AS UNION_CONSOLIDA_32798_COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24957, COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841 AS UNION_CONSOLIDA_32798_COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24958, ... 15 more fields]
                                                                        +- SubqueryAlias UNION_CONSOLIDA_32798116
                                                                           +- Relation[COL_59E3B457_6564_4E84_B090_99EAA1987944#24818,COL_0F23AEDF_BAD8_4E26_B826_E8AA3ABF2AB7#24819,COL_2502BA3F_08DB_4BB9_B6E5_A7A52A13C0F7#24820,COL_413BE7B8_1BFE_4393_A802_209E3937124C#24821,COL_3E7D7A54_60D3_4C7F_8108_D6154F039403#24822,COL_F8B56ACB_AF4D_4416_A0CE_02542D87F168#24823,COL_F472560C_DB99_41F2_9279_7069140A9D65#24824,COL_60F30E2C_D2CE_467C_904C_9EBA89EBEC26#24825,COL_73CF393B_334E_4D3A_B9C0_D20AE71624A7#24826,COL_38D9CA2C_BD87_4605_94E4_86B424A96909#24827,COL_ED782DEA_98D7_422B_924C_9886EC161B9C#24828,COL_135AAA37_5078_4633_9560_24643D2CFC87#24829,COL_0028B527_C922_4E5A_A3AB_F054F9B2965E#24830,COL_F0C5E910_B077_41E9_B46F_01655F2E9C97#24831,COL_F5768BC5_E831_4C13_9267_16652B1D0E08#24832,COL_75234846_3AEC_4734_AD7E_5E1D67C6736A#24833,COL_E10C23BC_532B_4DF2_B90A_F93A9688D565#24834,COL_BE661BBD_FD35_4104_A0B0_82CEA3D32045#24835,COL_67A3CC20_0152_4521_AEF7_3322F80015B9#24836,COL_563097F6_D634_4F07_AC9C_1AFBABE98DE7#24837,COL_B34E98F1_C011_49A8_9374_74FC7AF927E5#24838,COL_240FC9A7_5D69_4A0B_81A6_1A452A1120B4#24839,COL_B8C2FB3B_6ADD_4042_B47F_8B496BB19202#24840,COL_978D010A_8A92_4D56_ACC1_D7982AEE90AE#24841,... 15 more fields] parquet