== 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_225838167`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#522325, code_Cim10#522326], false
(4) Project
Arguments: [Numéro Séjour#522325 AS Numéro Séjour#522331, code_Cim10#522326 AS code_Cim10#522332]
(5) Project
Arguments: [Numéro Séjour#522331, code_Cim10#522332]
(6) Project
Arguments: [code_Cim10#522332 AS CODE_CIM10_225629#522338, Numéro Séjour#522331 AS NUMEROSEJOUR_225628#522339]
(7) Project
Arguments: [CODE_CIM10_225629#522338, NUMEROSEJOUR_225628#522339, str_remove_space(str_remove_extend(CODE_CIM10_225629#522338, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_225630#522342]
(8) View
Arguments: `04_DIAGNOSTICS__225627167`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__225627167
(10) Project
Arguments: [CODE_CIM10_225629#522338 AS 04_DIAGNOSTICS__225627_CODE_CIM10_225629#522349, NUMEROSEJOUR_225628#522339 AS 04_DIAGNOSTICS__225627_NUMEROSEJOUR_225628#522350, CODECIM10_NORM_225630#522342 AS 04_DIAGNOSTICS__225627_CODECIM10_NORM_225630#522351]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__225627_NUMEROSEJOUR_225628#522350 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522357, cast(04_DIAGNOSTICS__225627_CODE_CIM10_225629#522349 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522358]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522357 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522361, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522358 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522362]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522361 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522365, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522362 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522366]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522365 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522369, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522366 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522370]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522369, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522370, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522369, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#522373]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#522369, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522370, COL_A188B73D_4933_4923_828E_687FE72CE189#522373, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522370, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522377]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#522370)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522373 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522382, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522377 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522383]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522382 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522383 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#522388]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#519380, Libell%C3%A9+long#519381, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386], false
(21) Project
Arguments: [Code+CIM+10#519380 AS Code CIM 10#519394, Libell%C3%A9+long#519381, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(22) Project
Arguments: [Code CIM 10#519394, Libell%C3%A9+long#519381 AS Libellé long#519403, Date_effet#519382, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(23) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519382 AS Date_effet#519411, Date_r%C3%A9vocation#519383, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(24) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_r%C3%A9vocation#519383 AS Date_révocation#519419, Responsable+MAJ#519384, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(25) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable+MAJ#519384 AS Responsable MAJ#519427, Source#519385, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(26) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable MAJ#519427, Source#519385 AS Source#519435, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386]
(27) Project
Arguments: [Code CIM 10#519394, Libellé long#519403, Date_effet#519411, Date_révocation#519419, Responsable MAJ#519427, Source#519435, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519386 AS DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519443]
(28) Project
Arguments: [Code CIM 10#519394 AS Code CIM 10#519451, Libellé long#519403 AS Libellé long#519452, Date_effet#519411 AS Date_effet#519453, Date_révocation#519419 AS Date_révocation#519454, Responsable MAJ#519427 AS Responsable MAJ#519455, Source#519435 AS Source#519456, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519443 AS DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519457]
(29) Project
Arguments: [Code CIM 10#519451, Libellé long#519452, Date_effet#519453, Date_révocation#519454, Responsable MAJ#519455, Source#519456, DIAGNOSTIC_PE1__225525HEADER_COL_DETAIL_DEPOT#519457]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#519451, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_225563#519478, str_to_datez(Date_effet#519453, M/d/yy, null, null) AS DATE_EFFET_225565#519473, str_to_datez(Date_révocation#519454, M/d/yy, null, null) AS DATE_REVOCATION_225566#519474, Libellé long#519452 AS LIBELLE_LONG_225564#519475, Responsable MAJ#519455 AS RESPONSABLE_MAJ_225567#519476, Source#519456 AS SOURCE_225568#519477]
(31) Project
Arguments: [CODE_CIM_10_225563#519478, DATE_EFFET_225565#519473, DATE_REVOCATION_225566#519474, LIBELLE_LONG_225564#519475, RESPONSABLE_MAJ_225567#519476, SOURCE_225568#519477, str_remove_space(str_remove_extend(CODE_CIM_10_225563#519478, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_225569#519485]
(32) View
Arguments: `DIAGNOSTIC_PE1__225562167`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__225562167
(34) Project
Arguments: [CODE_CIM_10_225563#519478 AS DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399, DATE_EFFET_225565#519473 AS DIAGNOSTIC_PE1__225562_DATE_EFFET_225565#522400, DATE_REVOCATION_225566#519474 AS DIAGNOSTIC_PE1__225562_DATE_REVOCATION_225566#522401, LIBELLE_LONG_225564#519475 AS DIAGNOSTIC_PE1__225562_LIBELLE_LONG_225564#522402, RESPONSABLE_MAJ_225567#519476 AS DIAGNOSTIC_PE1__225562_RESPONSABLE_MAJ_225567#522403, SOURCE_225568#519477 AS DIAGNOSTIC_PE1__225562_SOURCE_225568#522404, CODE_CIM10_NORM_225569#519485 AS DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387 = DIAGNOSTIC_PE1__225562_CODE_CIM10_NORM_225569#522405)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, COL_63526921_A0EA_4239_B888_806A810EA728#522388, DIAGNOSTIC_PE1__225562_CODE_CIM_10_225563#522399 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522433]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387, COL_63526921_A0EA_4239_B888_806A810EA728#522388, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522433, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522433), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522440]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522386 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522454, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522387 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522455, COL_63526921_A0EA_4239_B888_806A810EA728#522388 AS COL_63526921_A0EA_4239_B888_806A810EA728#522456, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522433 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522457, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522440 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522458]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522454 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522464, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522455 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522465, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522458 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522457 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522467, COL_63526921_A0EA_4239_B888_806A810EA728#522456 AS COL_63526921_A0EA_4239_B888_806A810EA728#522468]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#519874, Libell%C3%A9+long#519875, Responsable+MAJ#519876, Source#519877, Date_effet#519878, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880], false
(41) Project
Arguments: [Code+CIM+10#519874 AS Code CIM 10#519908, Libell%C3%A9+long#519875, Responsable+MAJ#519876, Source#519877, Date_effet#519878, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(42) Project
Arguments: [Code CIM 10#519908, Libell%C3%A9+long#519875 AS Libellé long#519917, Responsable+MAJ#519876, Source#519877, Date_effet#519878, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(43) Project
Arguments: [Code CIM 10#519908, Libellé long#519917, Responsable+MAJ#519876 AS Responsable MAJ#519925, Source#519877, Date_effet#519878, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(44) Project
Arguments: [Code CIM 10#519908, Libellé long#519917, Responsable MAJ#519925, Source#519877 AS Source#519933, Date_effet#519878, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(45) Project
Arguments: [Code CIM 10#519908, Libellé long#519917, Responsable MAJ#519925, Source#519933, Date_effet#519878 AS Date_effet#519941, Date_r%C3%A9vocation#519879, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(46) Project
Arguments: [Code CIM 10#519908, Libellé long#519917, Responsable MAJ#519925, Source#519933, Date_effet#519941, Date_r%C3%A9vocation#519879 AS Date_révocation#519949, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880]
(47) Project
Arguments: [Code CIM 10#519908, Libellé long#519917, Responsable MAJ#519925, Source#519933, Date_effet#519941, Date_révocation#519949, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519880 AS DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519957]
(48) Project
Arguments: [Code CIM 10#519908 AS Code CIM 10#519965, Libellé long#519917 AS Libellé long#519966, Responsable MAJ#519925 AS Responsable MAJ#519967, Source#519933 AS Source#519968, Date_effet#519941 AS Date_effet#519969, Date_révocation#519949 AS Date_révocation#519970, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519957 AS DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519971]
(49) Project
Arguments: [Code CIM 10#519965, Libellé long#519966, Responsable MAJ#519967, Source#519968, Date_effet#519969, Date_révocation#519970, DIAGNOSTIC_PE2__225527HEADER_COL_DETAIL_DEPOT#519971]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#519965, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_225646#519992, Date_effet#519969 AS DATE_EFFET_225648#519987, Date_révocation#519970 AS DATE_REVOCATION_225649#519988, Libellé long#519966 AS LIBELLE_LONG_225647#519989, Responsable MAJ#519967 AS RESPONSABLE_MAJ_225650#519990, Source#519968 AS SOURCE_225651#519991]
(51) Project
Arguments: [CODE_CIM_10_225646#519992, DATE_EFFET_225648#519987, DATE_REVOCATION_225649#519988, LIBELLE_LONG_225647#519989, RESPONSABLE_MAJ_225650#519990, SOURCE_225651#519991, str_remove_space(str_remove_extend(CODE_CIM_10_225646#519992, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_225652#519999]
(52) View
Arguments: `DIAGNOSTIC_PE2__225645167`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__225645167
(54) Project
Arguments: [CODE_CIM_10_225646#519992 AS DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481, DATE_EFFET_225648#519987 AS DIAGNOSTIC_PE2__225645_DATE_EFFET_225648#522482, DATE_REVOCATION_225649#519988 AS DIAGNOSTIC_PE2__225645_DATE_REVOCATION_225649#522483, LIBELLE_LONG_225647#519989 AS DIAGNOSTIC_PE2__225645_LIBELLE_LONG_225647#522484, RESPONSABLE_MAJ_225650#519990 AS DIAGNOSTIC_PE2__225645_RESPONSABLE_MAJ_225650#522485, SOURCE_225651#519991 AS DIAGNOSTIC_PE2__225645_SOURCE_225651#522486, CODE_CIM10_NORM_225652#519999 AS DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522465 = DIAGNOSTIC_PE2__225645_CODE_CIM10_NORM_225652#522487)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522464, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522465, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522467, COL_63526921_A0EA_4239_B888_806A810EA728#522468, DIAGNOSTIC_PE2__225645_CODE_CIM_10_225646#522481 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522519]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522464, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522465, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522467, COL_63526921_A0EA_4239_B888_806A810EA728#522468, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522519, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522519), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522526]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522464 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522534, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522465 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522535, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522466 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522536, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522467 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522537, COL_63526921_A0EA_4239_B888_806A810EA728#522468 AS COL_63526921_A0EA_4239_B888_806A810EA728#522538, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522519 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522539, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522526 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522540]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522534 AS COL_A188B73D_4933_4923_828E_687FE72CE189#522548, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522535 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522549, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522536 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522550, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522540 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522539 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522552, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522537 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522553, COL_63526921_A0EA_4239_B888_806A810EA728#522538 AS COL_63526921_A0EA_4239_B888_806A810EA728#522554]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#522548], [COL_A188B73D_4933_4923_828E_687FE72CE189#522548 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522562, 1 AS NULL_1#522586, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#522550) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522571, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#522551) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522573, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#522549), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5a0a5284, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522577, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#522553), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5326ecae, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522581, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#522552), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@49652da9, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522585]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522562, COL_22F494F7_741E_40CC_932F_1428DA298F77#522571, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522573, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522577, COL_7F63CD51_FF18_434B_926C_8420A0519999#522581, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522585]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522562 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522639, COL_22F494F7_741E_40CC_932F_1428DA298F77#522571 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522640, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522573 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522641, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522577 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522642, COL_7F63CD51_FF18_434B_926C_8420A0519999#522581 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522643, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522585 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522644]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522639 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522651, COL_22F494F7_741E_40CC_932F_1428DA298F77#522640 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522652, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522641 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522653, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522642 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522654, COL_7F63CD51_FF18_434B_926C_8420A0519999#522643 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522655, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522644 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522656]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522651 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522663, COL_22F494F7_741E_40CC_932F_1428DA298F77#522652 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522664, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522653 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522665, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522654 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522666, COL_7F63CD51_FF18_434B_926C_8420A0519999#522655 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522667, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522656 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522668]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522663 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522675, COL_22F494F7_741E_40CC_932F_1428DA298F77#522664 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522676, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522665 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522677, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522666 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522678, COL_7F63CD51_FF18_434B_926C_8420A0519999#522667 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522679, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522668 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522680]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522675 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#522687, COL_22F494F7_741E_40CC_932F_1428DA298F77#522676 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#522688, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522677 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#522689, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522678 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#522690, COL_7F63CD51_FF18_434B_926C_8420A0519999#522679 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#522691, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522680 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#522692]