== 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_188534169`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#716665, code_Cim10#716666], false
(4) Project
Arguments: [Numéro Séjour#716665 AS Numéro Séjour#716671, code_Cim10#716666 AS code_Cim10#716672]
(5) Project
Arguments: [Numéro Séjour#716671, code_Cim10#716672]
(6) Project
Arguments: [code_Cim10#716672 AS CODE_CIM10_188018#716678, Numéro Séjour#716671 AS NUMEROSEJOUR_188017#716679]
(7) Project
Arguments: [CODE_CIM10_188018#716678, NUMEROSEJOUR_188017#716679, str_remove_space(str_remove_extend(CODE_CIM10_188018#716678, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_188019#716682]
(8) View
Arguments: `04_DIAGNOSTICS__188016169`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__188016169
(10) Project
Arguments: [CODE_CIM10_188018#716678 AS 04_DIAGNOSTICS__188016_CODE_CIM10_188018#716689, NUMEROSEJOUR_188017#716679 AS 04_DIAGNOSTICS__188016_NUMEROSEJOUR_188017#716690, CODECIM10_NORM_188019#716682 AS 04_DIAGNOSTICS__188016_CODECIM10_NORM_188019#716691]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__188016_NUMEROSEJOUR_188017#716690 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716697, cast(04_DIAGNOSTICS__188016_CODE_CIM10_188018#716689 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716698]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716697 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716701, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716698 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716702]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716701 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716705, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716702 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716706]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716705 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716709, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716706 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716710]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716709, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716710, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716709, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#716713]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#716709, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716710, COL_A188B73D_4933_4923_828E_687FE72CE189#716713, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716710, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716717]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#716710)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716713 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716722, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716717 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716723]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716722 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716726, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716723 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716727, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#716728]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#716422, Libell%C3%A9+long#716423, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428], false
(21) Project
Arguments: [Code+CIM+10#716422 AS Code CIM 10#716436, Libell%C3%A9+long#716423, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(22) Project
Arguments: [Code CIM 10#716436, Libell%C3%A9+long#716423 AS Libellé long#716445, Date_effet#716424, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(23) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716424 AS Date_effet#716453, Date_r%C3%A9vocation#716425, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(24) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_r%C3%A9vocation#716425 AS Date_révocation#716461, Responsable+MAJ#716426, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(25) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable+MAJ#716426 AS Responsable MAJ#716469, Source#716427, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(26) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable MAJ#716469, Source#716427 AS Source#716477, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428]
(27) Project
Arguments: [Code CIM 10#716436, Libellé long#716445, Date_effet#716453, Date_révocation#716461, Responsable MAJ#716469, Source#716477, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716428 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716485]
(28) Project
Arguments: [Code CIM 10#716436 AS Code CIM 10#716493, Libellé long#716445 AS Libellé long#716494, Date_effet#716453 AS Date_effet#716495, Date_révocation#716461 AS Date_révocation#716496, Responsable MAJ#716469 AS Responsable MAJ#716497, Source#716477 AS Source#716498, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716485 AS DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716499]
(29) Project
Arguments: [Code CIM 10#716493, Libellé long#716494, Date_effet#716495, Date_révocation#716496, Responsable MAJ#716497, Source#716498, DIAGNOSTIC_PE1__187914HEADER_COL_DETAIL_DEPOT#716499]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#716493, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_187952#716520, str_to_datez(Date_effet#716495, M/d/yy, null, null) AS DATE_EFFET_187954#716515, str_to_datez(Date_révocation#716496, M/d/yy, null, null) AS DATE_REVOCATION_187955#716516, Libellé long#716494 AS LIBELLE_LONG_187953#716517, Responsable MAJ#716497 AS RESPONSABLE_MAJ_187956#716518, Source#716498 AS SOURCE_187957#716519]
(31) Project
Arguments: [CODE_CIM_10_187952#716520, DATE_EFFET_187954#716515, DATE_REVOCATION_187955#716516, LIBELLE_LONG_187953#716517, RESPONSABLE_MAJ_187956#716518, SOURCE_187957#716519, str_remove_space(str_remove_extend(CODE_CIM_10_187952#716520, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_187958#716527]
(32) View
Arguments: `DIAGNOSTIC_PE1__187951169`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__187951169
(34) Project
Arguments: [CODE_CIM_10_187952#716520 AS DIAGNOSTIC_PE1__187951_CODE_CIM_10_187952#716739, DATE_EFFET_187954#716515 AS DIAGNOSTIC_PE1__187951_DATE_EFFET_187954#716740, DATE_REVOCATION_187955#716516 AS DIAGNOSTIC_PE1__187951_DATE_REVOCATION_187955#716741, LIBELLE_LONG_187953#716517 AS DIAGNOSTIC_PE1__187951_LIBELLE_LONG_187953#716742, RESPONSABLE_MAJ_187956#716518 AS DIAGNOSTIC_PE1__187951_RESPONSABLE_MAJ_187956#716743, SOURCE_187957#716519 AS DIAGNOSTIC_PE1__187951_SOURCE_187957#716744, CODE_CIM10_NORM_187958#716527 AS DIAGNOSTIC_PE1__187951_CODE_CIM10_NORM_187958#716745]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716727 = DIAGNOSTIC_PE1__187951_CODE_CIM10_NORM_187958#716745)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716726, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716727, COL_63526921_A0EA_4239_B888_806A810EA728#716728, DIAGNOSTIC_PE1__187951_CODE_CIM_10_187952#716739 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716773]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716726, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716727, COL_63526921_A0EA_4239_B888_806A810EA728#716728, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716773, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716773), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716778]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716726 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716784, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716727 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716785, COL_63526921_A0EA_4239_B888_806A810EA728#716728 AS COL_63526921_A0EA_4239_B888_806A810EA728#716786, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716773 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716787, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716778 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716788]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716784 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716794, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716785 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716795, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716788 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716796, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716787 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716797, COL_63526921_A0EA_4239_B888_806A810EA728#716786 AS COL_63526921_A0EA_4239_B888_806A810EA728#716798]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#716535, Libell%C3%A9+long#716536, Responsable+MAJ#716537, Source#716538, Date_effet#716539, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541], false
(41) Project
Arguments: [Code+CIM+10#716535 AS Code CIM 10#716549, Libell%C3%A9+long#716536, Responsable+MAJ#716537, Source#716538, Date_effet#716539, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(42) Project
Arguments: [Code CIM 10#716549, Libell%C3%A9+long#716536 AS Libellé long#716558, Responsable+MAJ#716537, Source#716538, Date_effet#716539, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(43) Project
Arguments: [Code CIM 10#716549, Libellé long#716558, Responsable+MAJ#716537 AS Responsable MAJ#716566, Source#716538, Date_effet#716539, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(44) Project
Arguments: [Code CIM 10#716549, Libellé long#716558, Responsable MAJ#716566, Source#716538 AS Source#716574, Date_effet#716539, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(45) Project
Arguments: [Code CIM 10#716549, Libellé long#716558, Responsable MAJ#716566, Source#716574, Date_effet#716539 AS Date_effet#716582, Date_r%C3%A9vocation#716540, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(46) Project
Arguments: [Code CIM 10#716549, Libellé long#716558, Responsable MAJ#716566, Source#716574, Date_effet#716582, Date_r%C3%A9vocation#716540 AS Date_révocation#716590, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541]
(47) Project
Arguments: [Code CIM 10#716549, Libellé long#716558, Responsable MAJ#716566, Source#716574, Date_effet#716582, Date_révocation#716590, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716541 AS DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716598]
(48) Project
Arguments: [Code CIM 10#716549 AS Code CIM 10#716606, Libellé long#716558 AS Libellé long#716607, Responsable MAJ#716566 AS Responsable MAJ#716608, Source#716574 AS Source#716609, Date_effet#716582 AS Date_effet#716610, Date_révocation#716590 AS Date_révocation#716611, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716598 AS DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716612]
(49) Project
Arguments: [Code CIM 10#716606, Libellé long#716607, Responsable MAJ#716608, Source#716609, Date_effet#716610, Date_révocation#716611, DIAGNOSTIC_PE2__187916HEADER_COL_DETAIL_DEPOT#716612]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#716606, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_188035#716633, Date_effet#716610 AS DATE_EFFET_188037#716628, Date_révocation#716611 AS DATE_REVOCATION_188038#716629, Libellé long#716607 AS LIBELLE_LONG_188036#716630, Responsable MAJ#716608 AS RESPONSABLE_MAJ_188039#716631, Source#716609 AS SOURCE_188040#716632]
(51) Project
Arguments: [CODE_CIM_10_188035#716633, DATE_EFFET_188037#716628, DATE_REVOCATION_188038#716629, LIBELLE_LONG_188036#716630, RESPONSABLE_MAJ_188039#716631, SOURCE_188040#716632, str_remove_space(str_remove_extend(CODE_CIM_10_188035#716633, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_188041#716640]
(52) View
Arguments: `DIAGNOSTIC_PE2__188034169`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__188034169
(54) Project
Arguments: [CODE_CIM_10_188035#716633 AS DIAGNOSTIC_PE2__188034_CODE_CIM_10_188035#716811, DATE_EFFET_188037#716628 AS DIAGNOSTIC_PE2__188034_DATE_EFFET_188037#716812, DATE_REVOCATION_188038#716629 AS DIAGNOSTIC_PE2__188034_DATE_REVOCATION_188038#716813, LIBELLE_LONG_188036#716630 AS DIAGNOSTIC_PE2__188034_LIBELLE_LONG_188036#716814, RESPONSABLE_MAJ_188039#716631 AS DIAGNOSTIC_PE2__188034_RESPONSABLE_MAJ_188039#716815, SOURCE_188040#716632 AS DIAGNOSTIC_PE2__188034_SOURCE_188040#716816, CODE_CIM10_NORM_188041#716640 AS DIAGNOSTIC_PE2__188034_CODE_CIM10_NORM_188041#716817]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716795 = DIAGNOSTIC_PE2__188034_CODE_CIM10_NORM_188041#716817)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716794, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716795, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716796, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716797, COL_63526921_A0EA_4239_B888_806A810EA728#716798, DIAGNOSTIC_PE2__188034_CODE_CIM_10_188035#716811 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716849]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716794, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716795, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716796, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716797, COL_63526921_A0EA_4239_B888_806A810EA728#716798, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716849, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716849), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716856]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716794 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716864, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716795 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716865, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716796 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716866, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716797 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716867, COL_63526921_A0EA_4239_B888_806A810EA728#716798 AS COL_63526921_A0EA_4239_B888_806A810EA728#716868, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716849 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716869, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716856 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716870]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716864 AS COL_A188B73D_4933_4923_828E_687FE72CE189#716878, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716865 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716879, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716866 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716880, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716870 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716881, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716869 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716882, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716867 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716883, COL_63526921_A0EA_4239_B888_806A810EA728#716868 AS COL_63526921_A0EA_4239_B888_806A810EA728#716884]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#716878], [COL_A188B73D_4933_4923_828E_687FE72CE189#716878 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716892, 1 AS NULL_1#716916, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#716880) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#716901, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#716881) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716903, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#716879), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@22e17835, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716907, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#716883), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@45d2dbf, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#716911, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#716882), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@5f644758, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716915]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716892, COL_22F494F7_741E_40CC_932F_1428DA298F77#716901, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716903, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716907, COL_7F63CD51_FF18_434B_926C_8420A0519999#716911, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716915]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716892 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716969, COL_22F494F7_741E_40CC_932F_1428DA298F77#716901 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#716970, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716903 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716971, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716907 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716972, COL_7F63CD51_FF18_434B_926C_8420A0519999#716911 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#716973, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716915 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716974]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716969 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716981, COL_22F494F7_741E_40CC_932F_1428DA298F77#716970 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#716982, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716971 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716983, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716972 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716984, COL_7F63CD51_FF18_434B_926C_8420A0519999#716973 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#716985, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716974 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716986]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716981 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716993, COL_22F494F7_741E_40CC_932F_1428DA298F77#716982 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#716994, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716983 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716995, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716984 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716996, COL_7F63CD51_FF18_434B_926C_8420A0519999#716985 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#716997, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716986 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716998]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#716993 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#717005, COL_22F494F7_741E_40CC_932F_1428DA298F77#716994 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#717006, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#716995 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#717007, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#716996 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#717008, COL_7F63CD51_FF18_434B_926C_8420A0519999#716997 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#717009, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#716998 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#717010]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#717005 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#717017, COL_22F494F7_741E_40CC_932F_1428DA298F77#717006 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#717018, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#717007 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#717019, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#717008 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#717020, COL_7F63CD51_FF18_434B_926C_8420A0519999#717009 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#717021, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#717010 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#717022]