== 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_203296168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1057762, code_Cim10#1057763], false
(4) Project
Arguments: [Numéro Séjour#1057762 AS Numéro Séjour#1057768, code_Cim10#1057763 AS code_Cim10#1057769]
(5) Project
Arguments: [Numéro Séjour#1057768, code_Cim10#1057769]
(6) Project
Arguments: [code_Cim10#1057769 AS CODE_CIM10_202964#1057775, Numéro Séjour#1057768 AS NUMEROSEJOUR_202963#1057776]
(7) Project
Arguments: [CODE_CIM10_202964#1057775, NUMEROSEJOUR_202963#1057776, str_remove_space(str_remove_extend(CODE_CIM10_202964#1057775, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_202965#1057779]
(8) View
Arguments: `04_DIAGNOSTICS__202962168`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__202962168
(10) Project
Arguments: [CODE_CIM10_202964#1057775 AS 04_DIAGNOSTICS__202962_CODE_CIM10_202964#1058012, NUMEROSEJOUR_202963#1057776 AS 04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1058013, CODECIM10_NORM_202965#1057779 AS 04_DIAGNOSTICS__202962_CODECIM10_NORM_202965#1058014]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1058013 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058020, cast(04_DIAGNOSTICS__202962_CODE_CIM10_202964#1058012 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058021]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058020 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058024, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058021 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058025]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058024 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058028, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058025 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058029]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058028 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058032, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058029 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058033]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058032, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058033, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058032, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058036]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1058032, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058033, COL_A188B73D_4933_4923_828E_687FE72CE189#1058036, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058033, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058040]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1058033)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058036 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058045, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058040 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058046]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058045 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058049, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058046 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058050, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#1058051]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#1057783, Libell%C3%A9+long#1057784, Date_effet#1057785, Date_r%C3%A9vocation#1057786, Responsable+MAJ#1057787, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789], false
(21) Project
Arguments: [Code+CIM+10#1057783 AS Code CIM 10#1057797, Libell%C3%A9+long#1057784, Date_effet#1057785, Date_r%C3%A9vocation#1057786, Responsable+MAJ#1057787, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(22) Project
Arguments: [Code CIM 10#1057797, Libell%C3%A9+long#1057784 AS Libellé long#1057806, Date_effet#1057785, Date_r%C3%A9vocation#1057786, Responsable+MAJ#1057787, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(23) Project
Arguments: [Code CIM 10#1057797, Libellé long#1057806, Date_effet#1057785 AS Date_effet#1057814, Date_r%C3%A9vocation#1057786, Responsable+MAJ#1057787, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(24) Project
Arguments: [Code CIM 10#1057797, Libellé long#1057806, Date_effet#1057814, Date_r%C3%A9vocation#1057786 AS Date_révocation#1057822, Responsable+MAJ#1057787, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(25) Project
Arguments: [Code CIM 10#1057797, Libellé long#1057806, Date_effet#1057814, Date_révocation#1057822, Responsable+MAJ#1057787 AS Responsable MAJ#1057830, Source#1057788, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(26) Project
Arguments: [Code CIM 10#1057797, Libellé long#1057806, Date_effet#1057814, Date_révocation#1057822, Responsable MAJ#1057830, Source#1057788 AS Source#1057838, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789]
(27) Project
Arguments: [Code CIM 10#1057797, Libellé long#1057806, Date_effet#1057814, Date_révocation#1057822, Responsable MAJ#1057830, Source#1057838, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057789 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057846]
(28) Project
Arguments: [Code CIM 10#1057797 AS Code CIM 10#1057854, Libellé long#1057806 AS Libellé long#1057855, Date_effet#1057814 AS Date_effet#1057856, Date_révocation#1057822 AS Date_révocation#1057857, Responsable MAJ#1057830 AS Responsable MAJ#1057858, Source#1057838 AS Source#1057859, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057846 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057860]
(29) Project
Arguments: [Code CIM 10#1057854, Libellé long#1057855, Date_effet#1057856, Date_révocation#1057857, Responsable MAJ#1057858, Source#1057859, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1057860]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1057854, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202898#1057881, str_to_datez(Date_effet#1057856, M/d/yy, null, null) AS DATE_EFFET_202900#1057876, str_to_datez(Date_révocation#1057857, M/d/yy, null, null) AS DATE_REVOCATION_202901#1057877, Libellé long#1057855 AS LIBELLE_LONG_202899#1057878, Responsable MAJ#1057858 AS RESPONSABLE_MAJ_202902#1057879, Source#1057859 AS SOURCE_202903#1057880]
(31) Project
Arguments: [CODE_CIM_10_202898#1057881, DATE_EFFET_202900#1057876, DATE_REVOCATION_202901#1057877, LIBELLE_LONG_202899#1057878, RESPONSABLE_MAJ_202902#1057879, SOURCE_202903#1057880, str_remove_space(str_remove_extend(CODE_CIM_10_202898#1057881, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202904#1057888]
(32) View
Arguments: `DIAGNOSTIC_PE1__202897168`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__202897168
(34) Project
Arguments: [CODE_CIM_10_202898#1057881 AS DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1058062, DATE_EFFET_202900#1057876 AS DIAGNOSTIC_PE1__202897_DATE_EFFET_202900#1058063, DATE_REVOCATION_202901#1057877 AS DIAGNOSTIC_PE1__202897_DATE_REVOCATION_202901#1058064, LIBELLE_LONG_202899#1057878 AS DIAGNOSTIC_PE1__202897_LIBELLE_LONG_202899#1058065, RESPONSABLE_MAJ_202902#1057879 AS DIAGNOSTIC_PE1__202897_RESPONSABLE_MAJ_202902#1058066, SOURCE_202903#1057880 AS DIAGNOSTIC_PE1__202897_SOURCE_202903#1058067, CODE_CIM10_NORM_202904#1057888 AS DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1058068]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058050 = DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1058068)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058049, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058050, COL_63526921_A0EA_4239_B888_806A810EA728#1058051, DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1058062 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058096]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058049, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058050, COL_63526921_A0EA_4239_B888_806A810EA728#1058051, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058096, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058096), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058101]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058049 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058107, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058050 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058108, COL_63526921_A0EA_4239_B888_806A810EA728#1058051 AS COL_63526921_A0EA_4239_B888_806A810EA728#1058109, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058096 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058110, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058101 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058111]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058107 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058117, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058108 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058118, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058111 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058119, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058110 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058120, COL_63526921_A0EA_4239_B888_806A810EA728#1058109 AS COL_63526921_A0EA_4239_B888_806A810EA728#1058121]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#1057896, Libell%C3%A9+long#1057897, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902], false
(41) Project
Arguments: [Code+CIM+10#1057896 AS Code CIM 10#1057910, Libell%C3%A9+long#1057897, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(42) Project
Arguments: [Code CIM 10#1057910, Libell%C3%A9+long#1057897 AS Libellé long#1057919, Responsable+MAJ#1057898, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(43) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable+MAJ#1057898 AS Responsable MAJ#1057927, Source#1057899, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(44) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057899 AS Source#1057935, Date_effet#1057900, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(45) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057900 AS Date_effet#1057943, Date_r%C3%A9vocation#1057901, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(46) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057943, Date_r%C3%A9vocation#1057901 AS Date_révocation#1057951, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902]
(47) Project
Arguments: [Code CIM 10#1057910, Libellé long#1057919, Responsable MAJ#1057927, Source#1057935, Date_effet#1057943, Date_révocation#1057951, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057902 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057959]
(48) Project
Arguments: [Code CIM 10#1057910 AS Code CIM 10#1057967, Libellé long#1057919 AS Libellé long#1057968, Responsable MAJ#1057927 AS Responsable MAJ#1057969, Source#1057935 AS Source#1057970, Date_effet#1057943 AS Date_effet#1057971, Date_révocation#1057951 AS Date_révocation#1057972, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057959 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057973]
(49) Project
Arguments: [Code CIM 10#1057967, Libellé long#1057968, Responsable MAJ#1057969, Source#1057970, Date_effet#1057971, Date_révocation#1057972, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1057973]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1057967, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202981#1057994, Date_effet#1057971 AS DATE_EFFET_202983#1057989, Date_révocation#1057972 AS DATE_REVOCATION_202984#1057990, Libellé long#1057968 AS LIBELLE_LONG_202982#1057991, Responsable MAJ#1057969 AS RESPONSABLE_MAJ_202985#1057992, Source#1057970 AS SOURCE_202986#1057993]
(51) Project
Arguments: [CODE_CIM_10_202981#1057994, DATE_EFFET_202983#1057989, DATE_REVOCATION_202984#1057990, LIBELLE_LONG_202982#1057991, RESPONSABLE_MAJ_202985#1057992, SOURCE_202986#1057993, str_remove_space(str_remove_extend(CODE_CIM_10_202981#1057994, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202987#1058001]
(52) View
Arguments: `DIAGNOSTIC_PE2__202980168`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__202980168
(54) Project
Arguments: [CODE_CIM_10_202981#1057994 AS DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1058134, DATE_EFFET_202983#1057989 AS DIAGNOSTIC_PE2__202980_DATE_EFFET_202983#1058135, DATE_REVOCATION_202984#1057990 AS DIAGNOSTIC_PE2__202980_DATE_REVOCATION_202984#1058136, LIBELLE_LONG_202982#1057991 AS DIAGNOSTIC_PE2__202980_LIBELLE_LONG_202982#1058137, RESPONSABLE_MAJ_202985#1057992 AS DIAGNOSTIC_PE2__202980_RESPONSABLE_MAJ_202985#1058138, SOURCE_202986#1057993 AS DIAGNOSTIC_PE2__202980_SOURCE_202986#1058139, CODE_CIM10_NORM_202987#1058001 AS DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1058140]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058118 = DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1058140)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058117, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058118, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058119, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058120, COL_63526921_A0EA_4239_B888_806A810EA728#1058121, DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1058134 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058172]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058117, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058118, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058119, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058120, COL_63526921_A0EA_4239_B888_806A810EA728#1058121, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058172, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058172), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058179]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058117 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058187, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058118 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058188, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058119 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058189, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058120 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058190, COL_63526921_A0EA_4239_B888_806A810EA728#1058121 AS COL_63526921_A0EA_4239_B888_806A810EA728#1058191, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058172 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058192, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058179 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058193]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058187 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1058201, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058188 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058202, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058189 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058203, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058193 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058204, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058192 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058205, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058190 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058206, COL_63526921_A0EA_4239_B888_806A810EA728#1058191 AS COL_63526921_A0EA_4239_B888_806A810EA728#1058207]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1058201], [COL_A188B73D_4933_4923_828E_687FE72CE189#1058201 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058215, 1 AS NULL_1#1058239, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1058203) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058224, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1058204) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058226, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1058202), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3462fd3c, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058230, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1058206), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6e549eb4, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058234, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1058205), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@176c3b2e, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058238]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058215, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058224, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058226, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058230, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058234, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058238]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058215 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058292, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058224 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058293, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058226 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058294, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058230 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058295, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058234 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058296, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058238 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058297]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058292 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058304, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058293 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058305, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058294 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058306, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058295 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058307, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058296 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058308, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058297 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058309]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058304 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058316, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058305 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058317, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058306 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058318, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058307 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058319, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058308 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058320, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058309 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058321]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058316 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058328, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058317 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058329, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058318 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058330, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058319 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058331, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058320 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058332, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058321 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058333]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058328 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1058340, COL_22F494F7_741E_40CC_932F_1428DA298F77#1058329 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1058341, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058330 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1058342, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058331 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1058343, COL_7F63CD51_FF18_434B_926C_8420A0519999#1058332 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1058344, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058333 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1058345]