DC2 - Details for Query 45

Details for Query 45

Submitted Time: 2026/03/05 07:13:45
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#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 ==

CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
   +- 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 ==
CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
   +- 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

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `RESTITUTION_INT_36630116`, false, true, LocalTempView
         +- 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