== 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_203296168`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#1055378, code_Cim10#1055379], false
(4) Project
Arguments: [Numéro Séjour#1055378 AS Numéro Séjour#1055384, code_Cim10#1055379 AS code_Cim10#1055385]
(5) Project
Arguments: [Numéro Séjour#1055384, code_Cim10#1055385]
(6) Project
Arguments: [code_Cim10#1055385 AS CODE_CIM10_202964#1055391, Numéro Séjour#1055384 AS NUMEROSEJOUR_202963#1055392]
(7) Project
Arguments: [CODE_CIM10_202964#1055391, NUMEROSEJOUR_202963#1055392, str_remove_space(str_remove_extend(CODE_CIM10_202964#1055391, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_202965#1055395]
(8) View
Arguments: `04_DIAGNOSTICS__202962168`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__202962168
(10) Project
Arguments: [CODE_CIM10_202964#1055391 AS 04_DIAGNOSTICS__202962_CODE_CIM10_202964#1055628, NUMEROSEJOUR_202963#1055392 AS 04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1055629, CODECIM10_NORM_202965#1055395 AS 04_DIAGNOSTICS__202962_CODECIM10_NORM_202965#1055630]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__202962_NUMEROSEJOUR_202963#1055629 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055636, cast(04_DIAGNOSTICS__202962_CODE_CIM10_202964#1055628 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055637]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055636 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055640, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055637 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055641]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055640 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055644, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055641 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055645]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055644 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055648, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055645 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055649]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055648, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055649, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055648, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055652]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#1055648, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055649, COL_A188B73D_4933_4923_828E_687FE72CE189#1055652, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055649, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055656]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#1055649)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055652 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055661, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055656 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055662]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055661 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055665, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055662 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055666, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#1055667]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#1055399, Libell%C3%A9+long#1055400, Date_effet#1055401, Date_r%C3%A9vocation#1055402, Responsable+MAJ#1055403, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405], false
(21) Project
Arguments: [Code+CIM+10#1055399 AS Code CIM 10#1055413, Libell%C3%A9+long#1055400, Date_effet#1055401, Date_r%C3%A9vocation#1055402, Responsable+MAJ#1055403, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(22) Project
Arguments: [Code CIM 10#1055413, Libell%C3%A9+long#1055400 AS Libellé long#1055422, Date_effet#1055401, Date_r%C3%A9vocation#1055402, Responsable+MAJ#1055403, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(23) Project
Arguments: [Code CIM 10#1055413, Libellé long#1055422, Date_effet#1055401 AS Date_effet#1055430, Date_r%C3%A9vocation#1055402, Responsable+MAJ#1055403, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(24) Project
Arguments: [Code CIM 10#1055413, Libellé long#1055422, Date_effet#1055430, Date_r%C3%A9vocation#1055402 AS Date_révocation#1055438, Responsable+MAJ#1055403, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(25) Project
Arguments: [Code CIM 10#1055413, Libellé long#1055422, Date_effet#1055430, Date_révocation#1055438, Responsable+MAJ#1055403 AS Responsable MAJ#1055446, Source#1055404, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(26) Project
Arguments: [Code CIM 10#1055413, Libellé long#1055422, Date_effet#1055430, Date_révocation#1055438, Responsable MAJ#1055446, Source#1055404 AS Source#1055454, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405]
(27) Project
Arguments: [Code CIM 10#1055413, Libellé long#1055422, Date_effet#1055430, Date_révocation#1055438, Responsable MAJ#1055446, Source#1055454, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055405 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055462]
(28) Project
Arguments: [Code CIM 10#1055413 AS Code CIM 10#1055470, Libellé long#1055422 AS Libellé long#1055471, Date_effet#1055430 AS Date_effet#1055472, Date_révocation#1055438 AS Date_révocation#1055473, Responsable MAJ#1055446 AS Responsable MAJ#1055474, Source#1055454 AS Source#1055475, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055462 AS DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055476]
(29) Project
Arguments: [Code CIM 10#1055470, Libellé long#1055471, Date_effet#1055472, Date_révocation#1055473, Responsable MAJ#1055474, Source#1055475, DIAGNOSTIC_PE1__202860HEADER_COL_DETAIL_DEPOT#1055476]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1055470, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202898#1055497, str_to_datez(Date_effet#1055472, M/d/yy, null, null) AS DATE_EFFET_202900#1055492, str_to_datez(Date_révocation#1055473, M/d/yy, null, null) AS DATE_REVOCATION_202901#1055493, Libellé long#1055471 AS LIBELLE_LONG_202899#1055494, Responsable MAJ#1055474 AS RESPONSABLE_MAJ_202902#1055495, Source#1055475 AS SOURCE_202903#1055496]
(31) Project
Arguments: [CODE_CIM_10_202898#1055497, DATE_EFFET_202900#1055492, DATE_REVOCATION_202901#1055493, LIBELLE_LONG_202899#1055494, RESPONSABLE_MAJ_202902#1055495, SOURCE_202903#1055496, str_remove_space(str_remove_extend(CODE_CIM_10_202898#1055497, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202904#1055504]
(32) View
Arguments: `DIAGNOSTIC_PE1__202897168`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__202897168
(34) Project
Arguments: [CODE_CIM_10_202898#1055497 AS DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1055678, DATE_EFFET_202900#1055492 AS DIAGNOSTIC_PE1__202897_DATE_EFFET_202900#1055679, DATE_REVOCATION_202901#1055493 AS DIAGNOSTIC_PE1__202897_DATE_REVOCATION_202901#1055680, LIBELLE_LONG_202899#1055494 AS DIAGNOSTIC_PE1__202897_LIBELLE_LONG_202899#1055681, RESPONSABLE_MAJ_202902#1055495 AS DIAGNOSTIC_PE1__202897_RESPONSABLE_MAJ_202902#1055682, SOURCE_202903#1055496 AS DIAGNOSTIC_PE1__202897_SOURCE_202903#1055683, CODE_CIM10_NORM_202904#1055504 AS DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1055684]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055666 = DIAGNOSTIC_PE1__202897_CODE_CIM10_NORM_202904#1055684)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055665, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055666, COL_63526921_A0EA_4239_B888_806A810EA728#1055667, DIAGNOSTIC_PE1__202897_CODE_CIM_10_202898#1055678 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055712]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055665, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055666, COL_63526921_A0EA_4239_B888_806A810EA728#1055667, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055712, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055712), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055717]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055665 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055723, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055666 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055724, COL_63526921_A0EA_4239_B888_806A810EA728#1055667 AS COL_63526921_A0EA_4239_B888_806A810EA728#1055725, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055712 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055726, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055717 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055727]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055723 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055733, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055724 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055734, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055727 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055735, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055726 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055736, COL_63526921_A0EA_4239_B888_806A810EA728#1055725 AS COL_63526921_A0EA_4239_B888_806A810EA728#1055737]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#1055512, Libell%C3%A9+long#1055513, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518], false
(41) Project
Arguments: [Code+CIM+10#1055512 AS Code CIM 10#1055526, Libell%C3%A9+long#1055513, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(42) Project
Arguments: [Code CIM 10#1055526, Libell%C3%A9+long#1055513 AS Libellé long#1055535, Responsable+MAJ#1055514, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(43) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable+MAJ#1055514 AS Responsable MAJ#1055543, Source#1055515, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(44) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055515 AS Source#1055551, Date_effet#1055516, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(45) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055516 AS Date_effet#1055559, Date_r%C3%A9vocation#1055517, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(46) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055559, Date_r%C3%A9vocation#1055517 AS Date_révocation#1055567, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518]
(47) Project
Arguments: [Code CIM 10#1055526, Libellé long#1055535, Responsable MAJ#1055543, Source#1055551, Date_effet#1055559, Date_révocation#1055567, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055518 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055575]
(48) Project
Arguments: [Code CIM 10#1055526 AS Code CIM 10#1055583, Libellé long#1055535 AS Libellé long#1055584, Responsable MAJ#1055543 AS Responsable MAJ#1055585, Source#1055551 AS Source#1055586, Date_effet#1055559 AS Date_effet#1055587, Date_révocation#1055567 AS Date_révocation#1055588, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055575 AS DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055589]
(49) Project
Arguments: [Code CIM 10#1055583, Libellé long#1055584, Responsable MAJ#1055585, Source#1055586, Date_effet#1055587, Date_révocation#1055588, DIAGNOSTIC_PE2__202862HEADER_COL_DETAIL_DEPOT#1055589]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#1055583, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_202981#1055610, Date_effet#1055587 AS DATE_EFFET_202983#1055605, Date_révocation#1055588 AS DATE_REVOCATION_202984#1055606, Libellé long#1055584 AS LIBELLE_LONG_202982#1055607, Responsable MAJ#1055585 AS RESPONSABLE_MAJ_202985#1055608, Source#1055586 AS SOURCE_202986#1055609]
(51) Project
Arguments: [CODE_CIM_10_202981#1055610, DATE_EFFET_202983#1055605, DATE_REVOCATION_202984#1055606, LIBELLE_LONG_202982#1055607, RESPONSABLE_MAJ_202985#1055608, SOURCE_202986#1055609, str_remove_space(str_remove_extend(CODE_CIM_10_202981#1055610, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_202987#1055617]
(52) View
Arguments: `DIAGNOSTIC_PE2__202980168`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__202980168
(54) Project
Arguments: [CODE_CIM_10_202981#1055610 AS DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1055750, DATE_EFFET_202983#1055605 AS DIAGNOSTIC_PE2__202980_DATE_EFFET_202983#1055751, DATE_REVOCATION_202984#1055606 AS DIAGNOSTIC_PE2__202980_DATE_REVOCATION_202984#1055752, LIBELLE_LONG_202982#1055607 AS DIAGNOSTIC_PE2__202980_LIBELLE_LONG_202982#1055753, RESPONSABLE_MAJ_202985#1055608 AS DIAGNOSTIC_PE2__202980_RESPONSABLE_MAJ_202985#1055754, SOURCE_202986#1055609 AS DIAGNOSTIC_PE2__202980_SOURCE_202986#1055755, CODE_CIM10_NORM_202987#1055617 AS DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1055756]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055734 = DIAGNOSTIC_PE2__202980_CODE_CIM10_NORM_202987#1055756)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055733, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055734, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055735, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055736, COL_63526921_A0EA_4239_B888_806A810EA728#1055737, DIAGNOSTIC_PE2__202980_CODE_CIM_10_202981#1055750 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055788]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055733, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055734, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055735, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055736, COL_63526921_A0EA_4239_B888_806A810EA728#1055737, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055788, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055788), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055795]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055733 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055803, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055734 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055804, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055735 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055805, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055736 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055806, COL_63526921_A0EA_4239_B888_806A810EA728#1055737 AS COL_63526921_A0EA_4239_B888_806A810EA728#1055807, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055788 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055808, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055795 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055809]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055803 AS COL_A188B73D_4933_4923_828E_687FE72CE189#1055817, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055804 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055818, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055805 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055819, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055809 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055820, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055808 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055821, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055806 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055822, COL_63526921_A0EA_4239_B888_806A810EA728#1055807 AS COL_63526921_A0EA_4239_B888_806A810EA728#1055823]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#1055817], [COL_A188B73D_4933_4923_828E_687FE72CE189#1055817 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055831, 1 AS NULL_1#1055855, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#1055819) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055840, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#1055820) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055842, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#1055818), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@7b9ae1fa, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055846, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#1055822), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@234f8cd4, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055850, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#1055821), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3467b504, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055854]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055831, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055840, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055842, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055846, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055850, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055854]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055831 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055908, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055840 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055909, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055842 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055910, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055846 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055911, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055850 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055912, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055854 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055913]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055908 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055920, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055909 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055921, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055910 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055922, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055911 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055923, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055912 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055924, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055913 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055925]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055920 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055932, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055921 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055933, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055922 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055934, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055923 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055935, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055924 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055936, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055925 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055937]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055932 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055944, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055933 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055945, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055934 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055946, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055935 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055947, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055936 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055948, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055937 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055949]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055944 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#1055956, COL_22F494F7_741E_40CC_932F_1428DA298F77#1055945 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#1055957, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055946 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#1055958, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055947 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#1055959, COL_7F63CD51_FF18_434B_926C_8420A0519999#1055948 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#1055960, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055949 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#1055961]