== 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_330467171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#363619, code_Cim10#363620], false
(4) Project
Arguments: [Numéro Séjour#363619 AS Numéro Séjour#363625, code_Cim10#363620 AS code_Cim10#363626]
(5) Project
Arguments: [Numéro Séjour#363625, code_Cim10#363626]
(6) Project
Arguments: [code_Cim10#363626 AS CODE_CIM10_330179#363632, Numéro Séjour#363625 AS NUMEROSEJOUR_330178#363633]
(7) Project
Arguments: [CODE_CIM10_330179#363632, NUMEROSEJOUR_330178#363633, str_remove_space(str_remove_extend(CODE_CIM10_330179#363632, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_330180#363636]
(8) View
Arguments: `04_DIAGNOSTICS__330177171`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__330177171
(10) Project
Arguments: [CODE_CIM10_330179#363632 AS 04_DIAGNOSTICS__330177_CODE_CIM10_330179#363643, NUMEROSEJOUR_330178#363633 AS 04_DIAGNOSTICS__330177_NUMEROSEJOUR_330178#363644, CODECIM10_NORM_330180#363636 AS 04_DIAGNOSTICS__330177_CODECIM10_NORM_330180#363645]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__330177_NUMEROSEJOUR_330178#363644 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363651, cast(04_DIAGNOSTICS__330177_CODE_CIM10_330179#363643 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363652]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363651 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363655, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363652 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363656]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363655 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363659, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363656 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363660]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363659 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363663, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363660 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363664]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363663, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363664, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363663, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#363667]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#363663, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363664, COL_A188B73D_4933_4923_828E_687FE72CE189#363667, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363664, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363671]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#363664)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363667 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363676, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363671 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363677]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363676 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363680, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363677 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363681, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#363682]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#363376, Libell%C3%A9+long#363377, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382], false
(21) Project
Arguments: [Code+CIM+10#363376 AS Code CIM 10#363390, Libell%C3%A9+long#363377, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(22) Project
Arguments: [Code CIM 10#363390, Libell%C3%A9+long#363377 AS Libellé long#363399, Date_effet#363378, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(23) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363378 AS Date_effet#363407, Date_r%C3%A9vocation#363379, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(24) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_r%C3%A9vocation#363379 AS Date_révocation#363415, Responsable+MAJ#363380, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(25) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable+MAJ#363380 AS Responsable MAJ#363423, Source#363381, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(26) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable MAJ#363423, Source#363381 AS Source#363431, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382]
(27) Project
Arguments: [Code CIM 10#363390, Libellé long#363399, Date_effet#363407, Date_révocation#363415, Responsable MAJ#363423, Source#363431, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363382 AS DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363439]
(28) Project
Arguments: [Code CIM 10#363390 AS Code CIM 10#363447, Libellé long#363399 AS Libellé long#363448, Date_effet#363407 AS Date_effet#363449, Date_révocation#363415 AS Date_révocation#363450, Responsable MAJ#363423 AS Responsable MAJ#363451, Source#363431 AS Source#363452, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363439 AS DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363453]
(29) Project
Arguments: [Code CIM 10#363447, Libellé long#363448, Date_effet#363449, Date_révocation#363450, Responsable MAJ#363451, Source#363452, DIAGNOSTIC_PE1__330070HEADER_COL_DETAIL_DEPOT#363453]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#363447, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_330093#363474, str_to_datez(Date_effet#363449, M/d/yy, null, null) AS DATE_EFFET_330095#363469, str_to_datez(Date_révocation#363450, M/d/yy, null, null) AS DATE_REVOCATION_330096#363470, Libellé long#363448 AS LIBELLE_LONG_330094#363471, Responsable MAJ#363451 AS RESPONSABLE_MAJ_330097#363472, Source#363452 AS SOURCE_330098#363473]
(31) Project
Arguments: [CODE_CIM_10_330093#363474, DATE_EFFET_330095#363469, DATE_REVOCATION_330096#363470, LIBELLE_LONG_330094#363471, RESPONSABLE_MAJ_330097#363472, SOURCE_330098#363473, str_remove_space(str_remove_extend(CODE_CIM_10_330093#363474, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_330099#363481]
(32) View
Arguments: `DIAGNOSTIC_PE1__330092171`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__330092171
(34) Project
Arguments: [CODE_CIM_10_330093#363474 AS DIAGNOSTIC_PE1__330092_CODE_CIM_10_330093#363693, DATE_EFFET_330095#363469 AS DIAGNOSTIC_PE1__330092_DATE_EFFET_330095#363694, DATE_REVOCATION_330096#363470 AS DIAGNOSTIC_PE1__330092_DATE_REVOCATION_330096#363695, LIBELLE_LONG_330094#363471 AS DIAGNOSTIC_PE1__330092_LIBELLE_LONG_330094#363696, RESPONSABLE_MAJ_330097#363472 AS DIAGNOSTIC_PE1__330092_RESPONSABLE_MAJ_330097#363697, SOURCE_330098#363473 AS DIAGNOSTIC_PE1__330092_SOURCE_330098#363698, CODE_CIM10_NORM_330099#363481 AS DIAGNOSTIC_PE1__330092_CODE_CIM10_NORM_330099#363699]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363681 = DIAGNOSTIC_PE1__330092_CODE_CIM10_NORM_330099#363699)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363680, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363681, COL_63526921_A0EA_4239_B888_806A810EA728#363682, DIAGNOSTIC_PE1__330092_CODE_CIM_10_330093#363693 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363727]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363680, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363681, COL_63526921_A0EA_4239_B888_806A810EA728#363682, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363727, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363727), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363732]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363680 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363738, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363681 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363739, COL_63526921_A0EA_4239_B888_806A810EA728#363682 AS COL_63526921_A0EA_4239_B888_806A810EA728#363740, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363727 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363741, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363732 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363742]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363738 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363748, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363739 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363749, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363742 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363750, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363741 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363751, COL_63526921_A0EA_4239_B888_806A810EA728#363740 AS COL_63526921_A0EA_4239_B888_806A810EA728#363752]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#363489, Libell%C3%A9+long#363490, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495], false
(41) Project
Arguments: [Code+CIM+10#363489 AS Code CIM 10#363503, Libell%C3%A9+long#363490, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(42) Project
Arguments: [Code CIM 10#363503, Libell%C3%A9+long#363490 AS Libellé long#363512, Responsable+MAJ#363491, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(43) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable+MAJ#363491 AS Responsable MAJ#363520, Source#363492, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(44) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363492 AS Source#363528, Date_effet#363493, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(45) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363493 AS Date_effet#363536, Date_r%C3%A9vocation#363494, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(46) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363536, Date_r%C3%A9vocation#363494 AS Date_révocation#363544, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495]
(47) Project
Arguments: [Code CIM 10#363503, Libellé long#363512, Responsable MAJ#363520, Source#363528, Date_effet#363536, Date_révocation#363544, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363495 AS DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363552]
(48) Project
Arguments: [Code CIM 10#363503 AS Code CIM 10#363560, Libellé long#363512 AS Libellé long#363561, Responsable MAJ#363520 AS Responsable MAJ#363562, Source#363528 AS Source#363563, Date_effet#363536 AS Date_effet#363564, Date_révocation#363544 AS Date_révocation#363565, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363552 AS DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363566]
(49) Project
Arguments: [Code CIM 10#363560, Libellé long#363561, Responsable MAJ#363562, Source#363563, Date_effet#363564, Date_révocation#363565, DIAGNOSTIC_PE2__330072HEADER_COL_DETAIL_DEPOT#363566]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#363560, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_330196#363587, Date_effet#363564 AS DATE_EFFET_330198#363582, Date_révocation#363565 AS DATE_REVOCATION_330199#363583, Libellé long#363561 AS LIBELLE_LONG_330197#363584, Responsable MAJ#363562 AS RESPONSABLE_MAJ_330200#363585, Source#363563 AS SOURCE_330201#363586]
(51) Project
Arguments: [CODE_CIM_10_330196#363587, DATE_EFFET_330198#363582, DATE_REVOCATION_330199#363583, LIBELLE_LONG_330197#363584, RESPONSABLE_MAJ_330200#363585, SOURCE_330201#363586, str_remove_space(str_remove_extend(CODE_CIM_10_330196#363587, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_330202#363594]
(52) View
Arguments: `DIAGNOSTIC_PE2__330195171`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__330195171
(54) Project
Arguments: [CODE_CIM_10_330196#363587 AS DIAGNOSTIC_PE2__330195_CODE_CIM_10_330196#363765, DATE_EFFET_330198#363582 AS DIAGNOSTIC_PE2__330195_DATE_EFFET_330198#363766, DATE_REVOCATION_330199#363583 AS DIAGNOSTIC_PE2__330195_DATE_REVOCATION_330199#363767, LIBELLE_LONG_330197#363584 AS DIAGNOSTIC_PE2__330195_LIBELLE_LONG_330197#363768, RESPONSABLE_MAJ_330200#363585 AS DIAGNOSTIC_PE2__330195_RESPONSABLE_MAJ_330200#363769, SOURCE_330201#363586 AS DIAGNOSTIC_PE2__330195_SOURCE_330201#363770, CODE_CIM10_NORM_330202#363594 AS DIAGNOSTIC_PE2__330195_CODE_CIM10_NORM_330202#363771]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363749 = DIAGNOSTIC_PE2__330195_CODE_CIM10_NORM_330202#363771)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363748, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363749, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363750, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363751, COL_63526921_A0EA_4239_B888_806A810EA728#363752, DIAGNOSTIC_PE2__330195_CODE_CIM_10_330196#363765 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363803]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363748, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363749, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363750, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363751, COL_63526921_A0EA_4239_B888_806A810EA728#363752, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363803, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363803), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363810]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363748 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363818, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363749 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363819, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363750 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363820, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363751 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363821, COL_63526921_A0EA_4239_B888_806A810EA728#363752 AS COL_63526921_A0EA_4239_B888_806A810EA728#363822, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363803 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363823, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363810 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363824]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363818 AS COL_A188B73D_4933_4923_828E_687FE72CE189#363832, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363819 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363833, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363820 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363834, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363824 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363835, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363823 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363836, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363821 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363837, COL_63526921_A0EA_4239_B888_806A810EA728#363822 AS COL_63526921_A0EA_4239_B888_806A810EA728#363838]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#363832], [COL_A188B73D_4933_4923_828E_687FE72CE189#363832 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363846, 1 AS NULL_1#363870, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#363834) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363855, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#363835) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363857, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#363833), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6ef84f95, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363861, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#363837), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@75eef31e, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363865, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#363836), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@2f6f66b5, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363869]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363846, COL_22F494F7_741E_40CC_932F_1428DA298F77#363855, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363857, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363861, COL_7F63CD51_FF18_434B_926C_8420A0519999#363865, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363869]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363846 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363923, COL_22F494F7_741E_40CC_932F_1428DA298F77#363855 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363924, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363857 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363925, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363861 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363926, COL_7F63CD51_FF18_434B_926C_8420A0519999#363865 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363927, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363869 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363928]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363923 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363935, COL_22F494F7_741E_40CC_932F_1428DA298F77#363924 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363936, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363925 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363937, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363926 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363938, COL_7F63CD51_FF18_434B_926C_8420A0519999#363927 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363939, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363928 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363940]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363935 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363947, COL_22F494F7_741E_40CC_932F_1428DA298F77#363936 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363948, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363937 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363949, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363938 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363950, COL_7F63CD51_FF18_434B_926C_8420A0519999#363939 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363951, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363940 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363952]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363947 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363959, COL_22F494F7_741E_40CC_932F_1428DA298F77#363948 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363960, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363949 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363961, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363950 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363962, COL_7F63CD51_FF18_434B_926C_8420A0519999#363951 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363963, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363952 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363964]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363959 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#363971, COL_22F494F7_741E_40CC_932F_1428DA298F77#363960 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#363972, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363961 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#363973, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363962 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#363974, COL_7F63CD51_FF18_434B_926C_8420A0519999#363963 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#363975, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363964 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#363976]