== 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_203296167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1060146, code_Cim10#1060147], false
(4) Project
Arguments: [Numéro Séjour#1060146 AS Numéro Séjour#1060152, code_Cim10#1060147 AS code_Cim10#1060153]
(5) Project
Arguments: [Numéro Séjour#1060152, code_Cim10#1060153]
(6) Project
Arguments: [code_Cim10#1060153 AS CODE_CIM10_202964#1060159, Numéro Séjour#1060152 AS NUMEROSEJOUR_202963#1060160]
(7) Project
Arguments: [CODE_CIM10_202964#1060159, NUMEROSEJOUR_202963#1060160, str_remove_space(str_remove_extend(CODE_CIM10_202964#1060159, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_202965#1060163]
(8) View
Arguments: `04_DIAGNOSTICS__202962167`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__202962167
(10) Project
Arguments: [CODE_CIM10_202964#1060159 AS 04_DIAGNOSTICS__202962_CODE_CIM10_202964#1060396, NUMEROSEJOUR_202963#1060160 AS 04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1060397, CODECIM10_NORM_202965#1060163 AS 04_DIAGNOSTICS__202962_CODECIM10_NORM_202965#1060398]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1060397 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060404, cast(04_DIAGNOSTICS__202962_CODE_CIM10_202964#1060396 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060405]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060404 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060408, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060405 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060409]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060408 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060412, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060409 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060413]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060412 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060416, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060413 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060417]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060416, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060417, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060416, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060420]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1060416, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060417, COL_A188B73D_4933_4923_828E_687FE72CE189#1060420, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060417, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060424]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1060417)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060420 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060429, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060424 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060430]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060429 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060433, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060430 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060434, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#1060435]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#1060167, Libell%C3%A9+long#1060168, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173], false
(21) Project
Arguments: [Code+CIM+10#1060167 AS Code CIM 10#1060181, Libell%C3%A9+long#1060168, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(22) Project
Arguments: [Code CIM 10#1060181, Libell%C3%A9+long#1060168 AS Libellé long#1060190, Date_effet#1060169, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(23) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060169 AS Date_effet#1060198, Date_r%C3%A9vocation#1060170, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(24) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_r%C3%A9vocation#1060170 AS Date_révocation#1060206, Responsable+MAJ#1060171, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(25) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable+MAJ#1060171 AS Responsable MAJ#1060214, Source#1060172, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(26) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable MAJ#1060214, Source#1060172 AS Source#1060222, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173]
(27) Project
Arguments: [Code CIM 10#1060181, Libellé long#1060190, Date_effet#1060198, Date_révocation#1060206, Responsable MAJ#1060214, Source#1060222, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060173 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060230]
(28) Project
Arguments: [Code CIM 10#1060181 AS Code CIM 10#1060238, Libellé long#1060190 AS Libellé long#1060239, Date_effet#1060198 AS Date_effet#1060240, Date_révocation#1060206 AS Date_révocation#1060241, Responsable MAJ#1060214 AS Responsable MAJ#1060242, Source#1060222 AS Source#1060243, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060230 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060244]
(29) Project
Arguments: [Code CIM 10#1060238, Libellé long#1060239, Date_effet#1060240, Date_révocation#1060241, Responsable MAJ#1060242, Source#1060243, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1060244]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1060238, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202898#1060265, str_to_datez(Date_effet#1060240, M/d/yy, null, null) AS DATE_EFFET_202900#1060260, str_to_datez(Date_révocation#1060241, M/d/yy, null, null) AS DATE_REVOCATION_202901#1060261, Libellé long#1060239 AS LIBELLE_LONG_202899#1060262, Responsable MAJ#1060242 AS RESPONSABLE_MAJ_202902#1060263, Source#1060243 AS SOURCE_202903#1060264]
(31) Project
Arguments: [CODE_CIM_10_202898#1060265, DATE_EFFET_202900#1060260, DATE_REVOCATION_202901#1060261, LIBELLE_LONG_202899#1060262, RESPONSABLE_MAJ_202902#1060263, SOURCE_202903#1060264, str_remove_space(str_remove_extend(CODE_CIM_10_202898#1060265, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202904#1060272]
(32) View
Arguments: `DIAGNOSTIC_PE1__202897167`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__202897167
(34) Project
Arguments: [CODE_CIM_10_202898#1060265 AS DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1060446, DATE_EFFET_202900#1060260 AS DIAGNOSTIC_PE1__202897_DATE_EFFET_202900#1060447, DATE_REVOCATION_202901#1060261 AS DIAGNOSTIC_PE1__202897_DATE_REVOCATION_202901#1060448, LIBELLE_LONG_202899#1060262 AS DIAGNOSTIC_PE1__202897_LIBELLE_LONG_202899#1060449, RESPONSABLE_MAJ_202902#1060263 AS DIAGNOSTIC_PE1__202897_RESPONSABLE_MAJ_202902#1060450, SOURCE_202903#1060264 AS DIAGNOSTIC_PE1__202897_SOURCE_202903#1060451, CODE_CIM10_NORM_202904#1060272 AS DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1060452]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060434 = DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1060452)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060433, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060434, COL_63526921_A0EA_4239_B888_806A810EA728#1060435, DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1060446 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060480]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060433, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060434, COL_63526921_A0EA_4239_B888_806A810EA728#1060435, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060480, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060480), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060485]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060433 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060491, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060434 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060492, COL_63526921_A0EA_4239_B888_806A810EA728#1060435 AS COL_63526921_A0EA_4239_B888_806A810EA728#1060493, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060480 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060494, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060485 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060495]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060491 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060501, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060492 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060502, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060495 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060503, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060494 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060504, COL_63526921_A0EA_4239_B888_806A810EA728#1060493 AS COL_63526921_A0EA_4239_B888_806A810EA728#1060505]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#1060280, Libell%C3%A9+long#1060281, Responsable+MAJ#1060282, Source#1060283, Date_effet#1060284, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286], false
(41) Project
Arguments: [Code+CIM+10#1060280 AS Code CIM 10#1060294, Libell%C3%A9+long#1060281, Responsable+MAJ#1060282, Source#1060283, Date_effet#1060284, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(42) Project
Arguments: [Code CIM 10#1060294, Libell%C3%A9+long#1060281 AS Libellé long#1060303, Responsable+MAJ#1060282, Source#1060283, Date_effet#1060284, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(43) Project
Arguments: [Code CIM 10#1060294, Libellé long#1060303, Responsable+MAJ#1060282 AS Responsable MAJ#1060311, Source#1060283, Date_effet#1060284, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(44) Project
Arguments: [Code CIM 10#1060294, Libellé long#1060303, Responsable MAJ#1060311, Source#1060283 AS Source#1060319, Date_effet#1060284, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(45) Project
Arguments: [Code CIM 10#1060294, Libellé long#1060303, Responsable MAJ#1060311, Source#1060319, Date_effet#1060284 AS Date_effet#1060327, Date_r%C3%A9vocation#1060285, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(46) Project
Arguments: [Code CIM 10#1060294, Libellé long#1060303, Responsable MAJ#1060311, Source#1060319, Date_effet#1060327, Date_r%C3%A9vocation#1060285 AS Date_révocation#1060335, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286]
(47) Project
Arguments: [Code CIM 10#1060294, Libellé long#1060303, Responsable MAJ#1060311, Source#1060319, Date_effet#1060327, Date_révocation#1060335, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060286 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060343]
(48) Project
Arguments: [Code CIM 10#1060294 AS Code CIM 10#1060351, Libellé long#1060303 AS Libellé long#1060352, Responsable MAJ#1060311 AS Responsable MAJ#1060353, Source#1060319 AS Source#1060354, Date_effet#1060327 AS Date_effet#1060355, Date_révocation#1060335 AS Date_révocation#1060356, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060343 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060357]
(49) Project
Arguments: [Code CIM 10#1060351, Libellé long#1060352, Responsable MAJ#1060353, Source#1060354, Date_effet#1060355, Date_révocation#1060356, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1060357]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1060351, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202981#1060378, Date_effet#1060355 AS DATE_EFFET_202983#1060373, Date_révocation#1060356 AS DATE_REVOCATION_202984#1060374, Libellé long#1060352 AS LIBELLE_LONG_202982#1060375, Responsable MAJ#1060353 AS RESPONSABLE_MAJ_202985#1060376, Source#1060354 AS SOURCE_202986#1060377]
(51) Project
Arguments: [CODE_CIM_10_202981#1060378, DATE_EFFET_202983#1060373, DATE_REVOCATION_202984#1060374, LIBELLE_LONG_202982#1060375, RESPONSABLE_MAJ_202985#1060376, SOURCE_202986#1060377, str_remove_space(str_remove_extend(CODE_CIM_10_202981#1060378, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202987#1060385]
(52) View
Arguments: `DIAGNOSTIC_PE2__202980167`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__202980167
(54) Project
Arguments: [CODE_CIM_10_202981#1060378 AS DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1060518, DATE_EFFET_202983#1060373 AS DIAGNOSTIC_PE2__202980_DATE_EFFET_202983#1060519, DATE_REVOCATION_202984#1060374 AS DIAGNOSTIC_PE2__202980_DATE_REVOCATION_202984#1060520, LIBELLE_LONG_202982#1060375 AS DIAGNOSTIC_PE2__202980_LIBELLE_LONG_202982#1060521, RESPONSABLE_MAJ_202985#1060376 AS DIAGNOSTIC_PE2__202980_RESPONSABLE_MAJ_202985#1060522, SOURCE_202986#1060377 AS DIAGNOSTIC_PE2__202980_SOURCE_202986#1060523, CODE_CIM10_NORM_202987#1060385 AS DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1060524]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060502 = DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1060524)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060501, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060502, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060503, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060504, COL_63526921_A0EA_4239_B888_806A810EA728#1060505, DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1060518 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060556]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060501, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060502, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060503, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060504, COL_63526921_A0EA_4239_B888_806A810EA728#1060505, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060556, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060556), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060563]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060501 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060571, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060502 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060572, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060503 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060573, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060504 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060574, COL_63526921_A0EA_4239_B888_806A810EA728#1060505 AS COL_63526921_A0EA_4239_B888_806A810EA728#1060575, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060556 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060576, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060563 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060577]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060571 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1060585, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060572 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060586, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060573 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060587, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060577 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060588, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060576 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060589, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060574 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060590, COL_63526921_A0EA_4239_B888_806A810EA728#1060575 AS COL_63526921_A0EA_4239_B888_806A810EA728#1060591]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1060585], [COL_A188B73D_4933_4923_828E_687FE72CE189#1060585 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060599, 1 AS NULL_1#1060623, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1060587) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060608, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1060588) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060610, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1060586), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@2f56041, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060614, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1060590), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@4a9b0f7, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060618, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1060589), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@63b914c6, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060622]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060599, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060608, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060610, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060614, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060618, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060622]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060599 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060676, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060608 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060677, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060610 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060678, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060614 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060679, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060618 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060680, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060622 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060681]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060676 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060688, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060677 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060689, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060678 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060690, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060679 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060691, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060680 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060692, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060681 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060693]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060688 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060700, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060689 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060701, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060690 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060702, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060691 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060703, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060692 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060704, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060693 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060705]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060700 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060712, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060701 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060713, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060702 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060714, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060703 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060715, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060704 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060716, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060705 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060717]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060712 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1060724, COL_22F494F7_741E_40CC_932F_1428DA298F77#1060713 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1060725, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060714 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1060726, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060715 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1060727, COL_7F63CD51_FF18_434B_926C_8420A0519999#1060716 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1060728, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060717 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1060729]