== 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_152349172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2300535, code_Cim10#2300536], false
(4) Project
Arguments: [Numéro Séjour#2300535 AS Numéro Séjour#2300541, code_Cim10#2300536 AS code_Cim10#2300542]
(5) Project
Arguments: [Numéro Séjour#2300541, code_Cim10#2300542]
(6) Project
Arguments: [code_Cim10#2300542 AS CODE_CIM10_152109#2300548, Numéro Séjour#2300541 AS NUMEROSEJOUR_152108#2300549]
(7) Project
Arguments: [CODE_CIM10_152109#2300548, NUMEROSEJOUR_152108#2300549, str_remove_space(str_remove_extend(CODE_CIM10_152109#2300548, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_152110#2300552]
(8) View
Arguments: `04_DIAGNOSTICS__152107172`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__152107172
(10) Project
Arguments: [CODE_CIM10_152109#2300548 AS 04_DIAGNOSTICS__152107_CODE_CIM10_152109#2300559, NUMEROSEJOUR_152108#2300549 AS 04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2300560, CODECIM10_NORM_152110#2300552 AS 04_DIAGNOSTICS__152107_CODECIM10_NORM_152110#2300561]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__152107_NUMEROSEJOUR_152108#2300560 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300567, cast(04_DIAGNOSTICS__152107_CODE_CIM10_152109#2300559 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300568]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300567 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300571, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300568 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300572]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300571 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300575, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300572 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300576]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300575 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300579, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300576 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300580]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300579, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300580, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300579, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300583]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2300579, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300580, COL_A188B73D_4933_4923_828E_687FE72CE189#2300583, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300580, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300587]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2300580)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300583 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300592, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300587 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300593]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300592 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300596, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300593 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300597, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#2300598]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#2300251, Libell%C3%A9+long#2300252, Date_effet#2300253, Date_r%C3%A9vocation#2300254, Responsable+MAJ#2300255, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257], false
(21) Project
Arguments: [Code+CIM+10#2300251 AS Code CIM 10#2300265, Libell%C3%A9+long#2300252, Date_effet#2300253, Date_r%C3%A9vocation#2300254, Responsable+MAJ#2300255, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(22) Project
Arguments: [Code CIM 10#2300265, Libell%C3%A9+long#2300252 AS Libellé long#2300274, Date_effet#2300253, Date_r%C3%A9vocation#2300254, Responsable+MAJ#2300255, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(23) Project
Arguments: [Code CIM 10#2300265, Libellé long#2300274, Date_effet#2300253 AS Date_effet#2300282, Date_r%C3%A9vocation#2300254, Responsable+MAJ#2300255, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(24) Project
Arguments: [Code CIM 10#2300265, Libellé long#2300274, Date_effet#2300282, Date_r%C3%A9vocation#2300254 AS Date_révocation#2300290, Responsable+MAJ#2300255, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(25) Project
Arguments: [Code CIM 10#2300265, Libellé long#2300274, Date_effet#2300282, Date_révocation#2300290, Responsable+MAJ#2300255 AS Responsable MAJ#2300298, Source#2300256, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(26) Project
Arguments: [Code CIM 10#2300265, Libellé long#2300274, Date_effet#2300282, Date_révocation#2300290, Responsable MAJ#2300298, Source#2300256 AS Source#2300306, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257]
(27) Project
Arguments: [Code CIM 10#2300265, Libellé long#2300274, Date_effet#2300282, Date_révocation#2300290, Responsable MAJ#2300298, Source#2300306, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300257 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300314]
(28) Project
Arguments: [Code CIM 10#2300265 AS Code CIM 10#2300322, Libellé long#2300274 AS Libellé long#2300323, Date_effet#2300282 AS Date_effet#2300324, Date_révocation#2300290 AS Date_révocation#2300325, Responsable MAJ#2300298 AS Responsable MAJ#2300326, Source#2300306 AS Source#2300327, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300314 AS DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300328]
(29) Project
Arguments: [Code CIM 10#2300322, Libellé long#2300323, Date_effet#2300324, Date_révocation#2300325, Responsable MAJ#2300326, Source#2300327, DIAGNOSTIC_PE1__152000HEADER_COL_DETAIL_DEPOT#2300328]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2300322, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152023#2300349, str_to_datez(Date_effet#2300324, M/d/yy, null, null) AS DATE_EFFET_152025#2300344, str_to_datez(Date_révocation#2300325, M/d/yy, null, null) AS DATE_REVOCATION_152026#2300345, Libellé long#2300323 AS LIBELLE_LONG_152024#2300346, Responsable MAJ#2300326 AS RESPONSABLE_MAJ_152027#2300347, Source#2300327 AS SOURCE_152028#2300348]
(31) Project
Arguments: [CODE_CIM_10_152023#2300349, DATE_EFFET_152025#2300344, DATE_REVOCATION_152026#2300345, LIBELLE_LONG_152024#2300346, RESPONSABLE_MAJ_152027#2300347, SOURCE_152028#2300348, str_remove_space(str_remove_extend(CODE_CIM_10_152023#2300349, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152029#2300356]
(32) View
Arguments: `DIAGNOSTIC_PE1__152022172`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__152022172
(34) Project
Arguments: [CODE_CIM_10_152023#2300349 AS DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2300609, DATE_EFFET_152025#2300344 AS DIAGNOSTIC_PE1__152022_DATE_EFFET_152025#2300610, DATE_REVOCATION_152026#2300345 AS DIAGNOSTIC_PE1__152022_DATE_REVOCATION_152026#2300611, LIBELLE_LONG_152024#2300346 AS DIAGNOSTIC_PE1__152022_LIBELLE_LONG_152024#2300612, RESPONSABLE_MAJ_152027#2300347 AS DIAGNOSTIC_PE1__152022_RESPONSABLE_MAJ_152027#2300613, SOURCE_152028#2300348 AS DIAGNOSTIC_PE1__152022_SOURCE_152028#2300614, CODE_CIM10_NORM_152029#2300356 AS DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2300615]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300597 = DIAGNOSTIC_PE1__152022_CODE_CIM10_NORM_152029#2300615)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300596, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300597, COL_63526921_A0EA_4239_B888_806A810EA728#2300598, DIAGNOSTIC_PE1__152022_CODE_CIM_10_152023#2300609 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300643]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300596, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300597, COL_63526921_A0EA_4239_B888_806A810EA728#2300598, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300643, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300643), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300648]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300596 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300654, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300597 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300655, COL_63526921_A0EA_4239_B888_806A810EA728#2300598 AS COL_63526921_A0EA_4239_B888_806A810EA728#2300656, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300643 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300657, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300648 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300658]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300654 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300664, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300655 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300665, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300658 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300666, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300657 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300667, COL_63526921_A0EA_4239_B888_806A810EA728#2300656 AS COL_63526921_A0EA_4239_B888_806A810EA728#2300668]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#2300405, Libell%C3%A9+long#2300406, Responsable+MAJ#2300407, Source#2300408, Date_effet#2300409, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411], false
(41) Project
Arguments: [Code+CIM+10#2300405 AS Code CIM 10#2300419, Libell%C3%A9+long#2300406, Responsable+MAJ#2300407, Source#2300408, Date_effet#2300409, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(42) Project
Arguments: [Code CIM 10#2300419, Libell%C3%A9+long#2300406 AS Libellé long#2300428, Responsable+MAJ#2300407, Source#2300408, Date_effet#2300409, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(43) Project
Arguments: [Code CIM 10#2300419, Libellé long#2300428, Responsable+MAJ#2300407 AS Responsable MAJ#2300436, Source#2300408, Date_effet#2300409, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(44) Project
Arguments: [Code CIM 10#2300419, Libellé long#2300428, Responsable MAJ#2300436, Source#2300408 AS Source#2300444, Date_effet#2300409, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(45) Project
Arguments: [Code CIM 10#2300419, Libellé long#2300428, Responsable MAJ#2300436, Source#2300444, Date_effet#2300409 AS Date_effet#2300452, Date_r%C3%A9vocation#2300410, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(46) Project
Arguments: [Code CIM 10#2300419, Libellé long#2300428, Responsable MAJ#2300436, Source#2300444, Date_effet#2300452, Date_r%C3%A9vocation#2300410 AS Date_révocation#2300460, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411]
(47) Project
Arguments: [Code CIM 10#2300419, Libellé long#2300428, Responsable MAJ#2300436, Source#2300444, Date_effet#2300452, Date_révocation#2300460, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300411 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300468]
(48) Project
Arguments: [Code CIM 10#2300419 AS Code CIM 10#2300476, Libellé long#2300428 AS Libellé long#2300477, Responsable MAJ#2300436 AS Responsable MAJ#2300478, Source#2300444 AS Source#2300479, Date_effet#2300452 AS Date_effet#2300480, Date_révocation#2300460 AS Date_révocation#2300481, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300468 AS DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300482]
(49) Project
Arguments: [Code CIM 10#2300476, Libellé long#2300477, Responsable MAJ#2300478, Source#2300479, Date_effet#2300480, Date_révocation#2300481, DIAGNOSTIC_PE2__152002HEADER_COL_DETAIL_DEPOT#2300482]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2300476, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_152126#2300503, Date_effet#2300480 AS DATE_EFFET_152128#2300498, Date_révocation#2300481 AS DATE_REVOCATION_152129#2300499, Libellé long#2300477 AS LIBELLE_LONG_152127#2300500, Responsable MAJ#2300478 AS RESPONSABLE_MAJ_152130#2300501, Source#2300479 AS SOURCE_152131#2300502]
(51) Project
Arguments: [CODE_CIM_10_152126#2300503, DATE_EFFET_152128#2300498, DATE_REVOCATION_152129#2300499, LIBELLE_LONG_152127#2300500, RESPONSABLE_MAJ_152130#2300501, SOURCE_152131#2300502, str_remove_space(str_remove_extend(CODE_CIM_10_152126#2300503, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_152132#2300510]
(52) View
Arguments: `DIAGNOSTIC_PE2__152125172`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__152125172
(54) Project
Arguments: [CODE_CIM_10_152126#2300503 AS DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2300681, DATE_EFFET_152128#2300498 AS DIAGNOSTIC_PE2__152125_DATE_EFFET_152128#2300682, DATE_REVOCATION_152129#2300499 AS DIAGNOSTIC_PE2__152125_DATE_REVOCATION_152129#2300683, LIBELLE_LONG_152127#2300500 AS DIAGNOSTIC_PE2__152125_LIBELLE_LONG_152127#2300684, RESPONSABLE_MAJ_152130#2300501 AS DIAGNOSTIC_PE2__152125_RESPONSABLE_MAJ_152130#2300685, SOURCE_152131#2300502 AS DIAGNOSTIC_PE2__152125_SOURCE_152131#2300686, CODE_CIM10_NORM_152132#2300510 AS DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2300687]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300665 = DIAGNOSTIC_PE2__152125_CODE_CIM10_NORM_152132#2300687)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300664, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300665, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300666, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300667, COL_63526921_A0EA_4239_B888_806A810EA728#2300668, DIAGNOSTIC_PE2__152125_CODE_CIM_10_152126#2300681 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300719]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300664, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300665, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300666, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300667, COL_63526921_A0EA_4239_B888_806A810EA728#2300668, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300719, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300719), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300726]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300664 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300734, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300665 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300735, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300666 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300736, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300667 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300737, COL_63526921_A0EA_4239_B888_806A810EA728#2300668 AS COL_63526921_A0EA_4239_B888_806A810EA728#2300738, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300719 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300739, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300726 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300740]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300734 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2300748, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300735 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300749, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300736 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300750, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300740 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300751, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300739 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300752, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300737 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300753, COL_63526921_A0EA_4239_B888_806A810EA728#2300738 AS COL_63526921_A0EA_4239_B888_806A810EA728#2300754]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2300748], [COL_A188B73D_4933_4923_828E_687FE72CE189#2300748 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300762, 1 AS NULL_1#2300786, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2300750) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300771, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2300751) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300773, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2300749), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@784bc1ac, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300777, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2300753), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3df59b7b, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300781, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2300752), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@18aec626, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300785]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300762, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300771, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300773, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300777, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300781, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300785]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300762 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300839, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300771 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300840, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300773 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300841, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300777 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300842, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300781 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300843, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300785 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300844]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300839 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300851, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300840 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300852, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300841 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300853, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300842 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300854, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300843 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300855, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300844 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300856]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300851 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300863, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300852 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300864, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300853 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300865, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300854 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300866, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300855 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300867, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300856 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300868]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300863 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300875, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300864 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300876, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300865 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300877, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300866 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300878, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300867 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300879, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300868 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300880]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300875 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2300887, COL_22F494F7_741E_40CC_932F_1428DA298F77#2300876 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2300888, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300877 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2300889, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300878 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2300890, COL_7F63CD51_FF18_434B_926C_8420A0519999#2300879 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2300891, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300880 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2300892]