== 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_188534171`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#721971, code_Cim10#721972], false
(4) Project
Arguments: [Numéro Séjour#721971 AS Numéro Séjour#721977, code_Cim10#721972 AS code_Cim10#721978]
(5) Project
Arguments: [Numéro Séjour#721977, code_Cim10#721978]
(6) Project
Arguments: [code_Cim10#721978 AS CODE_CIM10_188018#721984, Numéro Séjour#721977 AS NUMEROSEJOUR_188017#721985]
(7) Project
Arguments: [CODE_CIM10_188018#721984, NUMEROSEJOUR_188017#721985, str_remove_space(str_remove_extend(CODE_CIM10_188018#721984, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_188019#721988]
(8) View
Arguments: `04_DIAGNOSTICS__188016171`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__188016171
(10) Project
Arguments: [CODE_CIM10_188018#721984 AS 04_DIAGNOSTICS__188016_CODE_CIM10_188018#721995, NUMEROSEJOUR_188017#721985 AS 04_DIAGNOSTICS__188016_NUMEROSEJOUR_188017#721996, CODECIM10_NORM_188019#721988 AS 04_DIAGNOSTICS__188016_CODECIM10_NORM_188019#721997]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__188016_NUMEROSEJOUR_188017#721996 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722003, cast(04_DIAGNOSTICS__188016_CODE_CIM10_188018#721995 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722004]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722003 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722007, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722004 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722008]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722007 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722011, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722008 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722012]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722011 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722015, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722012 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722016]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722015, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722016, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722015, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#722019]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#722015, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722016, COL_A188B73D_4933_4923_828E_687FE72CE189#722019, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722016, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722023]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#722016)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722019 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722028, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722023 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722029]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722028 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722032, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722029 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722033, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#722034]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#721705, Libell%C3%A9+long#721706, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711], false
(21) Project
Arguments: [Code+CIM+10#721705 AS Code CIM 10#721728, Libell%C3%A9+long#721706, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(22) Project
Arguments: [Code CIM 10#721728, Libell%C3%A9+long#721706 AS Libellé long#721737, Date_effet#721707, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(23) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721707 AS Date_effet#721745, Date_r%C3%A9vocation#721708, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(24) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_r%C3%A9vocation#721708 AS Date_révocation#721753, Responsable+MAJ#721709, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(25) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable+MAJ#721709 AS Responsable MAJ#721768, Source#721710, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(26) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable MAJ#721768, Source#721710 AS Source#721776, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711]
(27) Project
Arguments: [Code CIM 10#721728, Libellé long#721737, Date_effet#721745, Date_révocation#721753, Responsable MAJ#721768, Source#721776, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721711 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721784]
(28) Project
Arguments: [Code CIM 10#721728 AS Code CIM 10#721799, Libellé long#721737 AS Libellé long#721800, Date_effet#721745 AS Date_effet#721801, Date_révocation#721753 AS Date_révocation#721802, Responsable MAJ#721768 AS Responsable MAJ#721803, Source#721776 AS Source#721804, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721784 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721805]
(29) Project
Arguments: [Code CIM 10#721799, Libellé long#721800, Date_effet#721801, Date_révocation#721802, Responsable MAJ#721803, Source#721804, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#721805]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#721799, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_187952#721826, str_to_datez(Date_effet#721801, M/d/yy, null, null) AS DATE_EFFET_187954#721821, str_to_datez(Date_révocation#721802, M/d/yy, null, null) AS DATE_REVOCATION_187955#721822, Libellé long#721800 AS LIBELLE_LONG_187953#721823, Responsable MAJ#721803 AS RESPONSABLE_MAJ_187956#721824, Source#721804 AS SOURCE_187957#721825]
(31) Project
Arguments: [CODE_CIM_10_187952#721826, DATE_EFFET_187954#721821, DATE_REVOCATION_187955#721822, LIBELLE_LONG_187953#721823, RESPONSABLE_MAJ_187956#721824, SOURCE_187957#721825, str_remove_space(str_remove_extend(CODE_CIM_10_187952#721826, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_187958#721833]
(32) View
Arguments: `DIAGNOSTIC_PE1__187951171`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__187951171
(34) Project
Arguments: [CODE_CIM_10_187952#721826 AS DIAGNOSTIC_PE1__187951_CODE_CIM_10_187952#722045, DATE_EFFET_187954#721821 AS DIAGNOSTIC_PE1__187951_DATE_EFFET_187954#722046, DATE_REVOCATION_187955#721822 AS DIAGNOSTIC_PE1__187951_DATE_REVOCATION_187955#722047, LIBELLE_LONG_187953#721823 AS DIAGNOSTIC_PE1__187951_LIBELLE_LONG_187953#722048, RESPONSABLE_MAJ_187956#721824 AS DIAGNOSTIC_PE1__187951_RESPONSABLE_MAJ_187956#722049, SOURCE_187957#721825 AS DIAGNOSTIC_PE1__187951_SOURCE_187957#722050, CODE_CIM10_NORM_187958#721833 AS DIAGNOSTIC_PE1__187951_CODE_CIM10_NORM_187958#722051]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722033 = DIAGNOSTIC_PE1__187951_CODE_CIM10_NORM_187958#722051)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722032, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722033, COL_63526921_A0EA_4239_B888_806A810EA728#722034, DIAGNOSTIC_PE1__187951_CODE_CIM_10_187952#722045 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722079]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722032, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722033, COL_63526921_A0EA_4239_B888_806A810EA728#722034, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722079, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722079), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722084]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722032 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722090, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722033 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722091, COL_63526921_A0EA_4239_B888_806A810EA728#722034 AS COL_63526921_A0EA_4239_B888_806A810EA728#722092, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722079 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722093, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722084 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722094]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722090 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722100, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722091 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722101, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722094 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722102, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722093 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722103, COL_63526921_A0EA_4239_B888_806A810EA728#722092 AS COL_63526921_A0EA_4239_B888_806A810EA728#722104]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#721841, Libell%C3%A9+long#721842, Responsable+MAJ#721843, Source#721844, Date_effet#721845, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847], false
(41) Project
Arguments: [Code+CIM+10#721841 AS Code CIM 10#721855, Libell%C3%A9+long#721842, Responsable+MAJ#721843, Source#721844, Date_effet#721845, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(42) Project
Arguments: [Code CIM 10#721855, Libell%C3%A9+long#721842 AS Libellé long#721864, Responsable+MAJ#721843, Source#721844, Date_effet#721845, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(43) Project
Arguments: [Code CIM 10#721855, Libellé long#721864, Responsable+MAJ#721843 AS Responsable MAJ#721872, Source#721844, Date_effet#721845, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(44) Project
Arguments: [Code CIM 10#721855, Libellé long#721864, Responsable MAJ#721872, Source#721844 AS Source#721880, Date_effet#721845, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(45) Project
Arguments: [Code CIM 10#721855, Libellé long#721864, Responsable MAJ#721872, Source#721880, Date_effet#721845 AS Date_effet#721888, Date_r%C3%A9vocation#721846, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(46) Project
Arguments: [Code CIM 10#721855, Libellé long#721864, Responsable MAJ#721872, Source#721880, Date_effet#721888, Date_r%C3%A9vocation#721846 AS Date_révocation#721896, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847]
(47) Project
Arguments: [Code CIM 10#721855, Libellé long#721864, Responsable MAJ#721872, Source#721880, Date_effet#721888, Date_révocation#721896, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721847 AS DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721904]
(48) Project
Arguments: [Code CIM 10#721855 AS Code CIM 10#721912, Libellé long#721864 AS Libellé long#721913, Responsable MAJ#721872 AS Responsable MAJ#721914, Source#721880 AS Source#721915, Date_effet#721888 AS Date_effet#721916, Date_révocation#721896 AS Date_révocation#721917, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721904 AS DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721918]
(49) Project
Arguments: [Code CIM 10#721912, Libellé long#721913, Responsable MAJ#721914, Source#721915, Date_effet#721916, Date_révocation#721917, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#721918]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#721912, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_188035#721939, Date_effet#721916 AS DATE_EFFET_188037#721934, Date_révocation#721917 AS DATE_REVOCATION_188038#721935, Libellé long#721913 AS LIBELLE_LONG_188036#721936, Responsable MAJ#721914 AS RESPONSABLE_MAJ_188039#721937, Source#721915 AS SOURCE_188040#721938]
(51) Project
Arguments: [CODE_CIM_10_188035#721939, DATE_EFFET_188037#721934, DATE_REVOCATION_188038#721935, LIBELLE_LONG_188036#721936, RESPONSABLE_MAJ_188039#721937, SOURCE_188040#721938, str_remove_space(str_remove_extend(CODE_CIM_10_188035#721939, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_188041#721946]
(52) View
Arguments: `DIAGNOSTIC_PE2__188034171`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__188034171
(54) Project
Arguments: [CODE_CIM_10_188035#721939 AS DIAGNOSTIC_PE2__188034_CODE_CIM_10_188035#722117, DATE_EFFET_188037#721934 AS DIAGNOSTIC_PE2__188034_DATE_EFFET_188037#722118, DATE_REVOCATION_188038#721935 AS DIAGNOSTIC_PE2__188034_DATE_REVOCATION_188038#722119, LIBELLE_LONG_188036#721936 AS DIAGNOSTIC_PE2__188034_LIBELLE_LONG_188036#722120, RESPONSABLE_MAJ_188039#721937 AS DIAGNOSTIC_PE2__188034_RESPONSABLE_MAJ_188039#722121, SOURCE_188040#721938 AS DIAGNOSTIC_PE2__188034_SOURCE_188040#722122, CODE_CIM10_NORM_188041#721946 AS DIAGNOSTIC_PE2__188034_CODE_CIM10_NORM_188041#722123]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722101 = DIAGNOSTIC_PE2__188034_CODE_CIM10_NORM_188041#722123)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722100, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722101, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722102, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722103, COL_63526921_A0EA_4239_B888_806A810EA728#722104, DIAGNOSTIC_PE2__188034_CODE_CIM_10_188035#722117 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722155]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722100, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722101, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722102, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722103, COL_63526921_A0EA_4239_B888_806A810EA728#722104, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722155, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722155), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722162]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722100 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722170, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722101 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722171, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722102 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722172, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722103 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722173, COL_63526921_A0EA_4239_B888_806A810EA728#722104 AS COL_63526921_A0EA_4239_B888_806A810EA728#722174, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722155 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722175, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722162 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722176]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722170 AS COL_A188B73D_4933_4923_828E_687FE72CE189#722184, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722171 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722185, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722172 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722186, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722176 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722187, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722175 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722188, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722173 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722189, COL_63526921_A0EA_4239_B888_806A810EA728#722174 AS COL_63526921_A0EA_4239_B888_806A810EA728#722190]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#722184], [COL_A188B73D_4933_4923_828E_687FE72CE189#722184 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722198, 1 AS NULL_1#722222, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#722186) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722207, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#722187) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722209, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#722185), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@64e36fe, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722213, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#722189), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@45564c41, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722217, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#722188), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3dcc82e1, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722221]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722198, COL_22F494F7_741E_40CC_932F_1428DA298F77#722207, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722209, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722213, COL_7F63CD51_FF18_434B_926C_8420A0519999#722217, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722221]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722198 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722275, COL_22F494F7_741E_40CC_932F_1428DA298F77#722207 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722276, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722209 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722277, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722213 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722278, COL_7F63CD51_FF18_434B_926C_8420A0519999#722217 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722279, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722221 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722280]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722275 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722287, COL_22F494F7_741E_40CC_932F_1428DA298F77#722276 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722288, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722277 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722289, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722278 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722290, COL_7F63CD51_FF18_434B_926C_8420A0519999#722279 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722291, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722280 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722292]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722287 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722299, COL_22F494F7_741E_40CC_932F_1428DA298F77#722288 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722300, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722289 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722301, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722290 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722302, COL_7F63CD51_FF18_434B_926C_8420A0519999#722291 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722303, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722292 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722304]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722299 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722311, COL_22F494F7_741E_40CC_932F_1428DA298F77#722300 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722312, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722301 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722313, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722302 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722314, COL_7F63CD51_FF18_434B_926C_8420A0519999#722303 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722315, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722304 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722316]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722311 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#722323, COL_22F494F7_741E_40CC_932F_1428DA298F77#722312 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#722324, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722313 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#722325, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722314 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#722326, COL_7F63CD51_FF18_434B_926C_8420A0519999#722315 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#722327, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722316 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#722328]