== 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_152349173`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2305586, code_Cim10#2305587], false
(4) Project
Arguments: [Numéro Séjour#2305586 AS Numéro Séjour#2305592, code_Cim10#2305587 AS code_Cim10#2305593]
(5) Project
Arguments: [Numéro Séjour#2305592, code_Cim10#2305593]
(6) Project
Arguments: [code_Cim10#2305593 AS CODE_CIM10_152109#2305599, Numéro Séjour#2305592 AS NUMEROSEJOUR_152108#2305600]
(7) Project
Arguments: [CODE_CIM10_152109#2305599, NUMEROSEJOUR_152108#2305600, str_remove_space(str_remove_extend(CODE_CIM10_152109#2305599, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_152110#2305603]
(8) View
Arguments: `04_DIAGNOSTICS__152107173`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__152107173
(10) Project
Arguments: [CODE_CIM10_152109#2305599 AS 04_DIAGNOSTICS__152107_CODE_CIM10_152109#2305610, NUMEROSEJOUR_152108#2305600 AS 04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2305611, CODECIM10_NORM_152110#2305603 AS 04_DIAGNOSTICS__152107_CODECIM10_NORM_152110#2305612]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2305611 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305618, cast(04_DIAGNOSTICS__152107_CODE_CIM10_152109#2305610 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305619]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305618 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305622, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305619 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305623]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305622 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305626, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305623 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305627]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305626 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305630, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305627 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305631]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305630, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305631, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305630, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305634]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2305630, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305631, COL_A188B73D_4933_4923_828E_687FE72CE189#2305634, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305631, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305638]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2305631)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305634 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305643, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305638 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305644]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305643 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305647, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305644 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305648, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#2305649]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#2305343, Libell%C3%A9+long#2305344, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349], false
(21) Project
Arguments: [Code+CIM+10#2305343 AS Code CIM 10#2305357, Libell%C3%A9+long#2305344, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(22) Project
Arguments: [Code CIM 10#2305357, Libell%C3%A9+long#2305344 AS Libellé long#2305366, Date_effet#2305345, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(23) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305345 AS Date_effet#2305374, Date_r%C3%A9vocation#2305346, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(24) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_r%C3%A9vocation#2305346 AS Date_révocation#2305382, Responsable+MAJ#2305347, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(25) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable+MAJ#2305347 AS Responsable MAJ#2305390, Source#2305348, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(26) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable MAJ#2305390, Source#2305348 AS Source#2305398, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349]
(27) Project
Arguments: [Code CIM 10#2305357, Libellé long#2305366, Date_effet#2305374, Date_révocation#2305382, Responsable MAJ#2305390, Source#2305398, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305349 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305406]
(28) Project
Arguments: [Code CIM 10#2305357 AS Code CIM 10#2305414, Libellé long#2305366 AS Libellé long#2305415, Date_effet#2305374 AS Date_effet#2305416, Date_révocation#2305382 AS Date_révocation#2305417, Responsable MAJ#2305390 AS Responsable MAJ#2305418, Source#2305398 AS Source#2305419, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305406 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305420]
(29) Project
Arguments: [Code CIM 10#2305414, Libellé long#2305415, Date_effet#2305416, Date_révocation#2305417, Responsable MAJ#2305418, Source#2305419, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2305420]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2305414, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152023#2305441, str_to_datez(Date_effet#2305416, M/d/yy, null, null) AS DATE_EFFET_152025#2305436, str_to_datez(Date_révocation#2305417, M/d/yy, null, null) AS DATE_REVOCATION_152026#2305437, Libellé long#2305415 AS LIBELLE_LONG_152024#2305438, Responsable MAJ#2305418 AS RESPONSABLE_MAJ_152027#2305439, Source#2305419 AS SOURCE_152028#2305440]
(31) Project
Arguments: [CODE_CIM_10_152023#2305441, DATE_EFFET_152025#2305436, DATE_REVOCATION_152026#2305437, LIBELLE_LONG_152024#2305438, RESPONSABLE_MAJ_152027#2305439, SOURCE_152028#2305440, str_remove_space(str_remove_extend(CODE_CIM_10_152023#2305441, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152029#2305448]
(32) View
Arguments: `DIAGNOSTIC_PE1__152022173`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__152022173
(34) Project
Arguments: [CODE_CIM_10_152023#2305441 AS DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2305660, DATE_EFFET_152025#2305436 AS DIAGNOSTIC_PE1__152022_DATE_EFFET_152025#2305661, DATE_REVOCATION_152026#2305437 AS DIAGNOSTIC_PE1__152022_DATE_REVOCATION_152026#2305662, LIBELLE_LONG_152024#2305438 AS DIAGNOSTIC_PE1__152022_LIBELLE_LONG_152024#2305663, RESPONSABLE_MAJ_152027#2305439 AS DIAGNOSTIC_PE1__152022_RESPONSABLE_MAJ_152027#2305664, SOURCE_152028#2305440 AS DIAGNOSTIC_PE1__152022_SOURCE_152028#2305665, CODE_CIM10_NORM_152029#2305448 AS DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2305666]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305648 = DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2305666)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305647, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305648, COL_63526921_A0EA_4239_B888_806A810EA728#2305649, DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2305660 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305694]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305647, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305648, COL_63526921_A0EA_4239_B888_806A810EA728#2305649, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305694, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305694), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305699]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305647 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305705, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305648 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305706, COL_63526921_A0EA_4239_B888_806A810EA728#2305649 AS COL_63526921_A0EA_4239_B888_806A810EA728#2305707, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305694 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305708, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305699 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305709]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305705 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305715, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305706 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305716, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305709 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305717, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305708 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305718, COL_63526921_A0EA_4239_B888_806A810EA728#2305707 AS COL_63526921_A0EA_4239_B888_806A810EA728#2305719]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#2305456, Libell%C3%A9+long#2305457, Responsable+MAJ#2305458, Source#2305459, Date_effet#2305460, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462], false
(41) Project
Arguments: [Code+CIM+10#2305456 AS Code CIM 10#2305470, Libell%C3%A9+long#2305457, Responsable+MAJ#2305458, Source#2305459, Date_effet#2305460, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(42) Project
Arguments: [Code CIM 10#2305470, Libell%C3%A9+long#2305457 AS Libellé long#2305479, Responsable+MAJ#2305458, Source#2305459, Date_effet#2305460, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(43) Project
Arguments: [Code CIM 10#2305470, Libellé long#2305479, Responsable+MAJ#2305458 AS Responsable MAJ#2305487, Source#2305459, Date_effet#2305460, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(44) Project
Arguments: [Code CIM 10#2305470, Libellé long#2305479, Responsable MAJ#2305487, Source#2305459 AS Source#2305495, Date_effet#2305460, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(45) Project
Arguments: [Code CIM 10#2305470, Libellé long#2305479, Responsable MAJ#2305487, Source#2305495, Date_effet#2305460 AS Date_effet#2305503, Date_r%C3%A9vocation#2305461, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(46) Project
Arguments: [Code CIM 10#2305470, Libellé long#2305479, Responsable MAJ#2305487, Source#2305495, Date_effet#2305503, Date_r%C3%A9vocation#2305461 AS Date_révocation#2305511, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462]
(47) Project
Arguments: [Code CIM 10#2305470, Libellé long#2305479, Responsable MAJ#2305487, Source#2305495, Date_effet#2305503, Date_révocation#2305511, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305462 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305519]
(48) Project
Arguments: [Code CIM 10#2305470 AS Code CIM 10#2305527, Libellé long#2305479 AS Libellé long#2305528, Responsable MAJ#2305487 AS Responsable MAJ#2305529, Source#2305495 AS Source#2305530, Date_effet#2305503 AS Date_effet#2305531, Date_révocation#2305511 AS Date_révocation#2305532, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305519 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305533]
(49) Project
Arguments: [Code CIM 10#2305527, Libellé long#2305528, Responsable MAJ#2305529, Source#2305530, Date_effet#2305531, Date_révocation#2305532, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2305533]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2305527, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152126#2305554, Date_effet#2305531 AS DATE_EFFET_152128#2305549, Date_révocation#2305532 AS DATE_REVOCATION_152129#2305550, Libellé long#2305528 AS LIBELLE_LONG_152127#2305551, Responsable MAJ#2305529 AS RESPONSABLE_MAJ_152130#2305552, Source#2305530 AS SOURCE_152131#2305553]
(51) Project
Arguments: [CODE_CIM_10_152126#2305554, DATE_EFFET_152128#2305549, DATE_REVOCATION_152129#2305550, LIBELLE_LONG_152127#2305551, RESPONSABLE_MAJ_152130#2305552, SOURCE_152131#2305553, str_remove_space(str_remove_extend(CODE_CIM_10_152126#2305554, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152132#2305561]
(52) View
Arguments: `DIAGNOSTIC_PE2__152125173`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__152125173
(54) Project
Arguments: [CODE_CIM_10_152126#2305554 AS DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2305732, DATE_EFFET_152128#2305549 AS DIAGNOSTIC_PE2__152125_DATE_EFFET_152128#2305733, DATE_REVOCATION_152129#2305550 AS DIAGNOSTIC_PE2__152125_DATE_REVOCATION_152129#2305734, LIBELLE_LONG_152127#2305551 AS DIAGNOSTIC_PE2__152125_LIBELLE_LONG_152127#2305735, RESPONSABLE_MAJ_152130#2305552 AS DIAGNOSTIC_PE2__152125_RESPONSABLE_MAJ_152130#2305736, SOURCE_152131#2305553 AS DIAGNOSTIC_PE2__152125_SOURCE_152131#2305737, CODE_CIM10_NORM_152132#2305561 AS DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2305738]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305716 = DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2305738)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305715, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305716, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305717, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305718, COL_63526921_A0EA_4239_B888_806A810EA728#2305719, DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2305732 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305770]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305715, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305716, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305717, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305718, COL_63526921_A0EA_4239_B888_806A810EA728#2305719, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305770, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305770), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305777]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305715 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305785, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305716 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305786, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305717 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305787, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305718 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305788, COL_63526921_A0EA_4239_B888_806A810EA728#2305719 AS COL_63526921_A0EA_4239_B888_806A810EA728#2305789, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305770 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305790, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305777 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305791]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305785 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2305799, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305786 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305800, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305787 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305801, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305791 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305802, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305790 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305803, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305788 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305804, COL_63526921_A0EA_4239_B888_806A810EA728#2305789 AS COL_63526921_A0EA_4239_B888_806A810EA728#2305805]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2305799], [COL_A188B73D_4933_4923_828E_687FE72CE189#2305799 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305813, 1 AS NULL_1#2305837, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2305801) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305822, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2305802) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305824, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2305800), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@ca9f64e, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305828, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2305804), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@58386fa9, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305832, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2305803), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@62d8dfd9, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305836]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305813, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305822, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305824, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305828, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305832, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305836]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305813 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305890, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305822 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305891, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305824 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305892, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305828 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305893, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305832 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305894, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305836 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305895]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305890 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305902, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305891 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305903, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305892 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305904, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305893 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305905, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305894 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305906, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305895 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305907]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305902 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305914, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305903 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305915, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305904 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305916, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305905 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305917, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305906 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305918, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305907 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305919]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305914 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305926, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305915 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305927, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305916 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305928, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305917 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305929, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305918 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305930, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305919 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305931]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305926 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2305938, COL_22F494F7_741E_40CC_932F_1428DA298F77#2305927 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2305939, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305928 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2305940, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305929 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2305941, COL_7F63CD51_FF18_434B_926C_8420A0519999#2305930 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2305942, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305931 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2305943]