== 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_152349171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2307981, code_Cim10#2307982], false
(4) Project
Arguments: [Numéro Séjour#2307981 AS Numéro Séjour#2307987, code_Cim10#2307982 AS code_Cim10#2307988]
(5) Project
Arguments: [Numéro Séjour#2307987, code_Cim10#2307988]
(6) Project
Arguments: [code_Cim10#2307988 AS CODE_CIM10_152109#2307994, Numéro Séjour#2307987 AS NUMEROSEJOUR_152108#2307995]
(7) Project
Arguments: [CODE_CIM10_152109#2307994, NUMEROSEJOUR_152108#2307995, str_remove_space(str_remove_extend(CODE_CIM10_152109#2307994, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_152110#2307998]
(8) View
Arguments: `04_DIAGNOSTICS__152107171`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__152107171
(10) Project
Arguments: [CODE_CIM10_152109#2307994 AS 04_DIAGNOSTICS__152107_CODE_CIM10_152109#2308005, NUMEROSEJOUR_152108#2307995 AS 04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2308006, CODECIM10_NORM_152110#2307998 AS 04_DIAGNOSTICS__152107_CODECIM10_NORM_152110#2308007]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2308006 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308013, cast(04_DIAGNOSTICS__152107_CODE_CIM10_152109#2308005 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308014]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308013 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308017, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308014 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308018]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308017 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308021, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308018 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308022]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308021 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308025, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308022 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308026]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308025, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308026, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308025, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308029]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2308025, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308026, COL_A188B73D_4933_4923_828E_687FE72CE189#2308029, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308026, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308033]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2308026)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308029 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308038, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308033 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308039]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308038 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308042, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308039 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308043, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#2308044]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#2307738, Libell%C3%A9+long#2307739, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744], false
(21) Project
Arguments: [Code+CIM+10#2307738 AS Code CIM 10#2307752, Libell%C3%A9+long#2307739, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(22) Project
Arguments: [Code CIM 10#2307752, Libell%C3%A9+long#2307739 AS Libellé long#2307761, Date_effet#2307740, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(23) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307740 AS Date_effet#2307769, Date_r%C3%A9vocation#2307741, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(24) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_r%C3%A9vocation#2307741 AS Date_révocation#2307777, Responsable+MAJ#2307742, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(25) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable+MAJ#2307742 AS Responsable MAJ#2307785, Source#2307743, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(26) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable MAJ#2307785, Source#2307743 AS Source#2307793, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744]
(27) Project
Arguments: [Code CIM 10#2307752, Libellé long#2307761, Date_effet#2307769, Date_révocation#2307777, Responsable MAJ#2307785, Source#2307793, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307744 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307801]
(28) Project
Arguments: [Code CIM 10#2307752 AS Code CIM 10#2307809, Libellé long#2307761 AS Libellé long#2307810, Date_effet#2307769 AS Date_effet#2307811, Date_révocation#2307777 AS Date_révocation#2307812, Responsable MAJ#2307785 AS Responsable MAJ#2307813, Source#2307793 AS Source#2307814, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307801 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307815]
(29) Project
Arguments: [Code CIM 10#2307809, Libellé long#2307810, Date_effet#2307811, Date_révocation#2307812, Responsable MAJ#2307813, Source#2307814, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2307815]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2307809, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152023#2307836, str_to_datez(Date_effet#2307811, M/d/yy, null, null) AS DATE_EFFET_152025#2307831, str_to_datez(Date_révocation#2307812, M/d/yy, null, null) AS DATE_REVOCATION_152026#2307832, Libellé long#2307810 AS LIBELLE_LONG_152024#2307833, Responsable MAJ#2307813 AS RESPONSABLE_MAJ_152027#2307834, Source#2307814 AS SOURCE_152028#2307835]
(31) Project
Arguments: [CODE_CIM_10_152023#2307836, DATE_EFFET_152025#2307831, DATE_REVOCATION_152026#2307832, LIBELLE_LONG_152024#2307833, RESPONSABLE_MAJ_152027#2307834, SOURCE_152028#2307835, str_remove_space(str_remove_extend(CODE_CIM_10_152023#2307836, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152029#2307843]
(32) View
Arguments: `DIAGNOSTIC_PE1__152022171`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__152022171
(34) Project
Arguments: [CODE_CIM_10_152023#2307836 AS DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2308055, DATE_EFFET_152025#2307831 AS DIAGNOSTIC_PE1__152022_DATE_EFFET_152025#2308056, DATE_REVOCATION_152026#2307832 AS DIAGNOSTIC_PE1__152022_DATE_REVOCATION_152026#2308057, LIBELLE_LONG_152024#2307833 AS DIAGNOSTIC_PE1__152022_LIBELLE_LONG_152024#2308058, RESPONSABLE_MAJ_152027#2307834 AS DIAGNOSTIC_PE1__152022_RESPONSABLE_MAJ_152027#2308059, SOURCE_152028#2307835 AS DIAGNOSTIC_PE1__152022_SOURCE_152028#2308060, CODE_CIM10_NORM_152029#2307843 AS DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2308061]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308043 = DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2308061)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308042, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308043, COL_63526921_A0EA_4239_B888_806A810EA728#2308044, DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2308055 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308089]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308042, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308043, COL_63526921_A0EA_4239_B888_806A810EA728#2308044, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308089, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308089), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308094]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308042 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308100, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308043 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308101, COL_63526921_A0EA_4239_B888_806A810EA728#2308044 AS COL_63526921_A0EA_4239_B888_806A810EA728#2308102, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308089 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308103, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308094 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308104]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308100 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308110, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308101 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308111, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308104 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308112, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308103 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308113, COL_63526921_A0EA_4239_B888_806A810EA728#2308102 AS COL_63526921_A0EA_4239_B888_806A810EA728#2308114]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#2307851, Libell%C3%A9+long#2307852, Responsable+MAJ#2307853, Source#2307854, Date_effet#2307855, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857], false
(41) Project
Arguments: [Code+CIM+10#2307851 AS Code CIM 10#2307865, Libell%C3%A9+long#2307852, Responsable+MAJ#2307853, Source#2307854, Date_effet#2307855, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(42) Project
Arguments: [Code CIM 10#2307865, Libell%C3%A9+long#2307852 AS Libellé long#2307874, Responsable+MAJ#2307853, Source#2307854, Date_effet#2307855, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(43) Project
Arguments: [Code CIM 10#2307865, Libellé long#2307874, Responsable+MAJ#2307853 AS Responsable MAJ#2307882, Source#2307854, Date_effet#2307855, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(44) Project
Arguments: [Code CIM 10#2307865, Libellé long#2307874, Responsable MAJ#2307882, Source#2307854 AS Source#2307890, Date_effet#2307855, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(45) Project
Arguments: [Code CIM 10#2307865, Libellé long#2307874, Responsable MAJ#2307882, Source#2307890, Date_effet#2307855 AS Date_effet#2307898, Date_r%C3%A9vocation#2307856, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(46) Project
Arguments: [Code CIM 10#2307865, Libellé long#2307874, Responsable MAJ#2307882, Source#2307890, Date_effet#2307898, Date_r%C3%A9vocation#2307856 AS Date_révocation#2307906, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857]
(47) Project
Arguments: [Code CIM 10#2307865, Libellé long#2307874, Responsable MAJ#2307882, Source#2307890, Date_effet#2307898, Date_révocation#2307906, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307857 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307914]
(48) Project
Arguments: [Code CIM 10#2307865 AS Code CIM 10#2307922, Libellé long#2307874 AS Libellé long#2307923, Responsable MAJ#2307882 AS Responsable MAJ#2307924, Source#2307890 AS Source#2307925, Date_effet#2307898 AS Date_effet#2307926, Date_révocation#2307906 AS Date_révocation#2307927, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307914 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307928]
(49) Project
Arguments: [Code CIM 10#2307922, Libellé long#2307923, Responsable MAJ#2307924, Source#2307925, Date_effet#2307926, Date_révocation#2307927, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2307928]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2307922, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152126#2307949, Date_effet#2307926 AS DATE_EFFET_152128#2307944, Date_révocation#2307927 AS DATE_REVOCATION_152129#2307945, Libellé long#2307923 AS LIBELLE_LONG_152127#2307946, Responsable MAJ#2307924 AS RESPONSABLE_MAJ_152130#2307947, Source#2307925 AS SOURCE_152131#2307948]
(51) Project
Arguments: [CODE_CIM_10_152126#2307949, DATE_EFFET_152128#2307944, DATE_REVOCATION_152129#2307945, LIBELLE_LONG_152127#2307946, RESPONSABLE_MAJ_152130#2307947, SOURCE_152131#2307948, str_remove_space(str_remove_extend(CODE_CIM_10_152126#2307949, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152132#2307956]
(52) View
Arguments: `DIAGNOSTIC_PE2__152125171`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__152125171
(54) Project
Arguments: [CODE_CIM_10_152126#2307949 AS DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2308127, DATE_EFFET_152128#2307944 AS DIAGNOSTIC_PE2__152125_DATE_EFFET_152128#2308128, DATE_REVOCATION_152129#2307945 AS DIAGNOSTIC_PE2__152125_DATE_REVOCATION_152129#2308129, LIBELLE_LONG_152127#2307946 AS DIAGNOSTIC_PE2__152125_LIBELLE_LONG_152127#2308130, RESPONSABLE_MAJ_152130#2307947 AS DIAGNOSTIC_PE2__152125_RESPONSABLE_MAJ_152130#2308131, SOURCE_152131#2307948 AS DIAGNOSTIC_PE2__152125_SOURCE_152131#2308132, CODE_CIM10_NORM_152132#2307956 AS DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2308133]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308111 = DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2308133)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308110, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308111, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308112, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308113, COL_63526921_A0EA_4239_B888_806A810EA728#2308114, DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2308127 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308165]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308110, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308111, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308112, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308113, COL_63526921_A0EA_4239_B888_806A810EA728#2308114, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308165, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308165), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308172]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308110 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308180, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308111 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308181, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308112 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308182, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308113 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308183, COL_63526921_A0EA_4239_B888_806A810EA728#2308114 AS COL_63526921_A0EA_4239_B888_806A810EA728#2308184, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308165 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308185, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308172 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308186]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308180 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2308194, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308181 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308195, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308182 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308196, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308186 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308197, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308185 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308198, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308183 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308199, COL_63526921_A0EA_4239_B888_806A810EA728#2308184 AS COL_63526921_A0EA_4239_B888_806A810EA728#2308200]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2308194], [COL_A188B73D_4933_4923_828E_687FE72CE189#2308194 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308208, 1 AS NULL_1#2308232, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2308196) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308217, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2308197) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308219, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2308195), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@16be2521, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308223, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2308199), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@223eeece, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308227, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2308198), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@7e3d1894, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308231]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308208, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308217, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308219, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308223, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308227, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308231]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308208 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308285, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308217 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308286, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308219 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308287, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308223 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308288, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308227 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308289, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308231 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308290]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308285 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308297, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308286 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308298, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308287 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308299, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308288 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308300, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308289 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308301, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308290 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308302]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308297 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308309, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308298 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308310, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308299 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308311, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308300 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308312, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308301 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308313, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308302 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308314]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308309 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308321, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308310 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308322, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308311 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308323, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308312 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308324, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308313 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308325, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308314 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308326]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308321 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2308333, COL_22F494F7_741E_40CC_932F_1428DA298F77#2308322 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2308334, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308323 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2308335, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308324 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2308336, COL_7F63CD51_FF18_434B_926C_8420A0519999#2308325 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2308337, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308326 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2308338]