== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (66)
+- Project (65)
+- Project (64)
+- Project (63)
+- Project (62)
+- Project (61)
+- Aggregate (60)
+- Project (59)
+- Project (58)
+- Project (57)
+- Project (56)
+- Join (55)
:- Project (39)
: +- Project (38)
: +- Project (37)
: +- Project (36)
: +- Join (35)
: :- Project (19)
: : +- Project (18)
: : +- Filter (17)
: : +- Project (16)
: : +- Project (15)
: : +- Project (14)
: : +- Project (13)
: : +- Project (12)
: : +- Project (11)
: : +- Project (10)
: : +- SubqueryAlias (9)
: : +- View (8)
: : +- Project (7)
: : +- Project (6)
: : +- Project (5)
: : +- Project (4)
: : +- LogicalRelation (3)
: +- Project (34)
: +- SubqueryAlias (33)
: +- View (32)
: +- Project (31)
: +- Project (30)
: +- Project (29)
: +- Project (28)
: +- Project (27)
: +- Project (26)
: +- Project (25)
: +- Project (24)
: +- Project (23)
: +- Project (22)
: +- Project (21)
: +- LogicalRelation (20)
+- Project (54)
+- SubqueryAlias (53)
+- View (52)
+- Project (51)
+- Project (50)
+- Project (49)
+- Project (48)
+- Project (47)
+- Project (46)
+- Project (45)
+- Project (44)
+- Project (43)
+- Project (42)
+- Project (41)
+- LogicalRelation (40)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `00_E_DIAGNOSTIC_172712169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1149709, code_Cim10#1149710], false
(4) Project
Arguments: [Numéro Séjour#1149709 AS Numéro Séjour#1149715, code_Cim10#1149710 AS code_Cim10#1149716]
(5) Project
Arguments: [Numéro Séjour#1149715, code_Cim10#1149716]
(6) Project
Arguments: [code_Cim10#1149716 AS CODE_CIM10_172217#1149738, Numéro Séjour#1149715 AS NUMEROSEJOUR_172216#1149739]
(7) Project
Arguments: [CODE_CIM10_172217#1149738, NUMEROSEJOUR_172216#1149739, str_remove_space(str_remove_extend(CODE_CIM10_172217#1149738, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_172218#1149758]
(8) View
Arguments: `04_DIAGNOSTICS__172215169`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__172215169
(10) Project
Arguments: [CODE_CIM10_172217#1149738 AS 04_DIAGNOSTICS__172215_CODE_CIM10_172217#1153911, NUMEROSEJOUR_172216#1149739 AS 04_DIAGNOSTICS__172215_NUMEROSEJOUR_172216#1153912, CODECIM10_NORM_172218#1149758 AS 04_DIAGNOSTICS__172215_CODECIM10_NORM_172218#1153913]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__172215_NUMEROSEJOUR_172216#1153912 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153919, cast(04_DIAGNOSTICS__172215_CODE_CIM10_172217#1153911 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153920]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153919 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153944, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153920 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153945]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153944 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153948, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153945 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153949]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153948 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153952, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153949 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153953]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153952, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153953, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153952, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1153956]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1153952, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153953, COL_A188B73D_4933_4923_828E_687FE72CE189#1153956, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153953, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153960]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1153953)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1153956 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1153965, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153960 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153966]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1153965 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1153969, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153966 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153970, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#1153971]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#1151893, Libell%C3%A9+long#1151894, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899], false
(21) Project
Arguments: [Code+CIM+10#1151893 AS Code CIM 10#1151940, Libell%C3%A9+long#1151894, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(22) Project
Arguments: [Code CIM 10#1151940, Libell%C3%A9+long#1151894 AS Libellé long#1151949, Date_effet#1151895, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(23) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151895 AS Date_effet#1151957, Date_r%C3%A9vocation#1151896, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(24) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_r%C3%A9vocation#1151896 AS Date_révocation#1151965, Responsable+MAJ#1151897, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(25) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable+MAJ#1151897 AS Responsable MAJ#1151973, Source#1151898, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(26) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable MAJ#1151973, Source#1151898 AS Source#1151981, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899]
(27) Project
Arguments: [Code CIM 10#1151940, Libellé long#1151949, Date_effet#1151957, Date_révocation#1151965, Responsable MAJ#1151973, Source#1151981, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151899 AS DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151989]
(28) Project
Arguments: [Code CIM 10#1151940 AS Code CIM 10#1151997, Libellé long#1151949 AS Libellé long#1151998, Date_effet#1151957 AS Date_effet#1151999, Date_révocation#1151965 AS Date_révocation#1152000, Responsable MAJ#1151973 AS Responsable MAJ#1152001, Source#1151981 AS Source#1152002, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1151989 AS DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1152003]
(29) Project
Arguments: [Code CIM 10#1151997, Libellé long#1151998, Date_effet#1151999, Date_révocation#1152000, Responsable MAJ#1152001, Source#1152002, DIAGNOSTIC_PE1__172113HEADER_COL_DETAIL_DEPOT#1152003]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1151997, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_172151#1152058, str_to_datez(Date_effet#1151999, M/d/yy, null, null) AS DATE_EFFET_172153#1152053, str_to_datez(Date_révocation#1152000, M/d/yy, null, null) AS DATE_REVOCATION_172154#1152054, Libellé long#1151998 AS LIBELLE_LONG_172152#1152055, Responsable MAJ#1152001 AS RESPONSABLE_MAJ_172155#1152056, Source#1152002 AS SOURCE_172156#1152057]
(31) Project
Arguments: [CODE_CIM_10_172151#1152058, DATE_EFFET_172153#1152053, DATE_REVOCATION_172154#1152054, LIBELLE_LONG_172152#1152055, RESPONSABLE_MAJ_172155#1152056, SOURCE_172156#1152057, str_remove_space(str_remove_extend(CODE_CIM_10_172151#1152058, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_172157#1152065]
(32) View
Arguments: `DIAGNOSTIC_PE1__172150169`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__172150169
(34) Project
Arguments: [CODE_CIM_10_172151#1152058 AS DIAGNOSTIC_PE1__172150_CODE_CIM_10_172151#1154004, DATE_EFFET_172153#1152053 AS DIAGNOSTIC_PE1__172150_DATE_EFFET_172153#1154005, DATE_REVOCATION_172154#1152054 AS DIAGNOSTIC_PE1__172150_DATE_REVOCATION_172154#1154006, LIBELLE_LONG_172152#1152055 AS DIAGNOSTIC_PE1__172150_LIBELLE_LONG_172152#1154007, RESPONSABLE_MAJ_172155#1152056 AS DIAGNOSTIC_PE1__172150_RESPONSABLE_MAJ_172155#1154008, SOURCE_172156#1152057 AS DIAGNOSTIC_PE1__172150_SOURCE_172156#1154009, CODE_CIM10_NORM_172157#1152065 AS DIAGNOSTIC_PE1__172150_CODE_CIM10_NORM_172157#1154010]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153970 = DIAGNOSTIC_PE1__172150_CODE_CIM10_NORM_172157#1154010)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1153969, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153970, COL_63526921_A0EA_4239_B888_806A810EA728#1153971, DIAGNOSTIC_PE1__172150_CODE_CIM_10_172151#1154004 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154038]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1153969, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153970, COL_63526921_A0EA_4239_B888_806A810EA728#1153971, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154038, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154038), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154043]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1153969 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1154049, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1153970 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154050, COL_63526921_A0EA_4239_B888_806A810EA728#1153971 AS COL_63526921_A0EA_4239_B888_806A810EA728#1154051, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154038 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154052, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154043 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154053]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154049 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1154059, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154050 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154060, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154053 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154061, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154052 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154062, COL_63526921_A0EA_4239_B888_806A810EA728#1154051 AS COL_63526921_A0EA_4239_B888_806A810EA728#1154063]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#1153629, Libell%C3%A9+long#1153630, Responsable+MAJ#1153631, Source#1153632, Date_effet#1153633, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635], false
(41) Project
Arguments: [Code+CIM+10#1153629 AS Code CIM 10#1153770, Libell%C3%A9+long#1153630, Responsable+MAJ#1153631, Source#1153632, Date_effet#1153633, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(42) Project
Arguments: [Code CIM 10#1153770, Libell%C3%A9+long#1153630 AS Libellé long#1153779, Responsable+MAJ#1153631, Source#1153632, Date_effet#1153633, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(43) Project
Arguments: [Code CIM 10#1153770, Libellé long#1153779, Responsable+MAJ#1153631 AS Responsable MAJ#1153787, Source#1153632, Date_effet#1153633, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(44) Project
Arguments: [Code CIM 10#1153770, Libellé long#1153779, Responsable MAJ#1153787, Source#1153632 AS Source#1153814, Date_effet#1153633, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(45) Project
Arguments: [Code CIM 10#1153770, Libellé long#1153779, Responsable MAJ#1153787, Source#1153814, Date_effet#1153633 AS Date_effet#1153822, Date_r%C3%A9vocation#1153634, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(46) Project
Arguments: [Code CIM 10#1153770, Libellé long#1153779, Responsable MAJ#1153787, Source#1153814, Date_effet#1153822, Date_r%C3%A9vocation#1153634 AS Date_révocation#1153830, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635]
(47) Project
Arguments: [Code CIM 10#1153770, Libellé long#1153779, Responsable MAJ#1153787, Source#1153814, Date_effet#1153822, Date_révocation#1153830, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153635 AS DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153838]
(48) Project
Arguments: [Code CIM 10#1153770 AS Code CIM 10#1153846, Libellé long#1153779 AS Libellé long#1153847, Responsable MAJ#1153787 AS Responsable MAJ#1153848, Source#1153814 AS Source#1153849, Date_effet#1153822 AS Date_effet#1153850, Date_révocation#1153830 AS Date_révocation#1153851, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153838 AS DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153852]
(49) Project
Arguments: [Code CIM 10#1153846, Libellé long#1153847, Responsable MAJ#1153848, Source#1153849, Date_effet#1153850, Date_révocation#1153851, DIAGNOSTIC_PE2__172115HEADER_COL_DETAIL_DEPOT#1153852]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1153846, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_172234#1153893, Date_effet#1153850 AS DATE_EFFET_172236#1153868, Date_révocation#1153851 AS DATE_REVOCATION_172237#1153869, Libellé long#1153847 AS LIBELLE_LONG_172235#1153870, Responsable MAJ#1153848 AS RESPONSABLE_MAJ_172238#1153871, Source#1153849 AS SOURCE_172239#1153872]
(51) Project
Arguments: [CODE_CIM_10_172234#1153893, DATE_EFFET_172236#1153868, DATE_REVOCATION_172237#1153869, LIBELLE_LONG_172235#1153870, RESPONSABLE_MAJ_172238#1153871, SOURCE_172239#1153872, str_remove_space(str_remove_extend(CODE_CIM_10_172234#1153893, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_172240#1153900]
(52) View
Arguments: `DIAGNOSTIC_PE2__172233169`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__172233169
(54) Project
Arguments: [CODE_CIM_10_172234#1153893 AS DIAGNOSTIC_PE2__172233_CODE_CIM_10_172234#1154076, DATE_EFFET_172236#1153868 AS DIAGNOSTIC_PE2__172233_DATE_EFFET_172236#1154077, DATE_REVOCATION_172237#1153869 AS DIAGNOSTIC_PE2__172233_DATE_REVOCATION_172237#1154078, LIBELLE_LONG_172235#1153870 AS DIAGNOSTIC_PE2__172233_LIBELLE_LONG_172235#1154079, RESPONSABLE_MAJ_172238#1153871 AS DIAGNOSTIC_PE2__172233_RESPONSABLE_MAJ_172238#1154080, SOURCE_172239#1153872 AS DIAGNOSTIC_PE2__172233_SOURCE_172239#1154081, CODE_CIM10_NORM_172240#1153900 AS DIAGNOSTIC_PE2__172233_CODE_CIM10_NORM_172240#1154082]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154060 = DIAGNOSTIC_PE2__172233_CODE_CIM10_NORM_172240#1154082)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154059, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154060, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154061, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154062, COL_63526921_A0EA_4239_B888_806A810EA728#1154063, DIAGNOSTIC_PE2__172233_CODE_CIM_10_172234#1154076 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154136]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154059, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154060, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154061, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154062, COL_63526921_A0EA_4239_B888_806A810EA728#1154063, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154136, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154136), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154143]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154059 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1154169, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154060 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154170, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154061 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154171, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154062 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154172, COL_63526921_A0EA_4239_B888_806A810EA728#1154063 AS COL_63526921_A0EA_4239_B888_806A810EA728#1154173, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154136 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154174, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154143 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154175]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154169 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1154183, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154170 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154184, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154171 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154185, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154175 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154186, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154174 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154187, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154172 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154188, COL_63526921_A0EA_4239_B888_806A810EA728#1154173 AS COL_63526921_A0EA_4239_B888_806A810EA728#1154189]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1154183], [COL_A188B73D_4933_4923_828E_687FE72CE189#1154183 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154197, 1 AS NULL_1#1154221, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1154185) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154206, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1154186) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154208, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1154184), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@77bbe691, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154212, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1154188), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3d3d25ca, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154216, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1154187), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@2db4f03e, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154220]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154197, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154206, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154208, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154212, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154216, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154220]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154197 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154329, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154206 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154330, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154208 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154331, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154212 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154332, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154216 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154333, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154220 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154334]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154329 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154341, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154330 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154342, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154331 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154343, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154332 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154344, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154333 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154345, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154334 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154346]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154341 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154353, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154342 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154354, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154343 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154355, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154344 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154356, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154345 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154357, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154346 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154358]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154353 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154365, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154354 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154366, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154355 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154367, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154356 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154368, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154357 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154369, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154358 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154370]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154365 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1154377, COL_22F494F7_741E_40CC_932F_1428DA298F77#1154366 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1154378, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154367 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1154379, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154368 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1154380, COL_7F63CD51_FF18_434B_926C_8420A0519999#1154369 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1154381, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154370 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1154382]