== 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_161814176`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: csv, [Numéro Séjour#2484032, code_Cim10#2484033], false
(4) Project
Arguments: [Numéro Séjour#2484032 AS Numéro Séjour#2484038, code_Cim10#2484033 AS code_Cim10#2484039]
(5) Project
Arguments: [Numéro Séjour#2484038, code_Cim10#2484039]
(6) Project
Arguments: [code_Cim10#2484039 AS CODE_CIM10_161525#2484045, Numéro Séjour#2484038 AS NUMEROSEJOUR_161524#2484046]
(7) Project
Arguments: [CODE_CIM10_161525#2484045, NUMEROSEJOUR_161524#2484046, str_remove_space(str_remove_extend(CODE_CIM10_161525#2484045, array(cast(. as string))), cast(ALL as string)) AS CODECIM10_NORM_161526#2484049]
(8) View
Arguments: `04_DIAGNOSTICS__161523176`, true
(9) SubqueryAlias
Arguments: 04_DIAGNOSTICS__161523176
(10) Project
Arguments: [CODE_CIM10_161525#2484045 AS 04_DIAGNOSTICS__161523_CODE_CIM10_161525#2484056, NUMEROSEJOUR_161524#2484046 AS 04_DIAGNOSTICS__161523_NUMEROSEJOUR_161524#2484057, CODECIM10_NORM_161526#2484049 AS 04_DIAGNOSTICS__161523_CODECIM10_NORM_161526#2484058]
(11) Project
Arguments: [cast(04_DIAGNOSTICS__161523_NUMEROSEJOUR_161524#2484057 as string) AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484064, cast(04_DIAGNOSTICS__161523_CODE_CIM10_161525#2484056 as string) AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484065]
(12) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484064 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484068, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484065 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484069]
(13) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484068 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484072, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484069 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484073]
(14) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484072 AS COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484076, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484073 AS COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484077]
(15) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484076, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484077, str_complete(str_remove_space(COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484076, cast(ALL as string)), cast(0 as string), cast(9 as bigint), cast(LEFT as string)) AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484080]
(16) Project
Arguments: [COL_2898C683_091C_4A32_9DC4_C939AE4C306E#2484076, COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484077, COL_A188B73D_4933_4923_828E_687FE72CE189#2484080, str_remove_extend(str_remove_space(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484077, cast(ALL as string)), array(cast(. as string))) AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484084]
(17) Filter
Arguments: isnotnull(COL_EF1F8300_8427_44B3_845C_08A8963FE4BE#2484077)
(18) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484080 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484089, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484084 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484090]
(19) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484089 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484093, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484090 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484094, cast(null as string) AS COL_63526921_A0EA_4239_B888_806A810EA728#2484095]
(20) LogicalRelation
Arguments: parquet, [Code+CIM+10#2483789, Libell%C3%A9+long#2483790, Date_effet#2483791, Date_r%C3%A9vocation#2483792, Responsable+MAJ#2483793, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795], false
(21) Project
Arguments: [Code+CIM+10#2483789 AS Code CIM 10#2483803, Libell%C3%A9+long#2483790, Date_effet#2483791, Date_r%C3%A9vocation#2483792, Responsable+MAJ#2483793, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(22) Project
Arguments: [Code CIM 10#2483803, Libell%C3%A9+long#2483790 AS Libellé long#2483812, Date_effet#2483791, Date_r%C3%A9vocation#2483792, Responsable+MAJ#2483793, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(23) Project
Arguments: [Code CIM 10#2483803, Libellé long#2483812, Date_effet#2483791 AS Date_effet#2483820, Date_r%C3%A9vocation#2483792, Responsable+MAJ#2483793, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(24) Project
Arguments: [Code CIM 10#2483803, Libellé long#2483812, Date_effet#2483820, Date_r%C3%A9vocation#2483792 AS Date_révocation#2483828, Responsable+MAJ#2483793, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(25) Project
Arguments: [Code CIM 10#2483803, Libellé long#2483812, Date_effet#2483820, Date_révocation#2483828, Responsable+MAJ#2483793 AS Responsable MAJ#2483836, Source#2483794, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(26) Project
Arguments: [Code CIM 10#2483803, Libellé long#2483812, Date_effet#2483820, Date_révocation#2483828, Responsable MAJ#2483836, Source#2483794 AS Source#2483844, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795]
(27) Project
Arguments: [Code CIM 10#2483803, Libellé long#2483812, Date_effet#2483820, Date_révocation#2483828, Responsable MAJ#2483836, Source#2483844, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483795 AS DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483852]
(28) Project
Arguments: [Code CIM 10#2483803 AS Code CIM 10#2483860, Libellé long#2483812 AS Libellé long#2483861, Date_effet#2483820 AS Date_effet#2483862, Date_révocation#2483828 AS Date_révocation#2483863, Responsable MAJ#2483836 AS Responsable MAJ#2483864, Source#2483844 AS Source#2483865, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483852 AS DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483866]
(29) Project
Arguments: [Code CIM 10#2483860, Libellé long#2483861, Date_effet#2483862, Date_révocation#2483863, Responsable MAJ#2483864, Source#2483865, DIAGNOSTIC_PE1__161422HEADER_COL_DETAIL_DEPOT#2483866]
(30) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2483860, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_161439#2483887, str_to_datez(Date_effet#2483862, M/d/yy, null, null) AS DATE_EFFET_161441#2483882, str_to_datez(Date_révocation#2483863, M/d/yy, null, null) AS DATE_REVOCATION_161442#2483883, Libellé long#2483861 AS LIBELLE_LONG_161440#2483884, Responsable MAJ#2483864 AS RESPONSABLE_MAJ_161443#2483885, Source#2483865 AS SOURCE_161444#2483886]
(31) Project
Arguments: [CODE_CIM_10_161439#2483887, DATE_EFFET_161441#2483882, DATE_REVOCATION_161442#2483883, LIBELLE_LONG_161440#2483884, RESPONSABLE_MAJ_161443#2483885, SOURCE_161444#2483886, str_remove_space(str_remove_extend(CODE_CIM_10_161439#2483887, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_161445#2483894]
(32) View
Arguments: `DIAGNOSTIC_PE1__161438176`, true
(33) SubqueryAlias
Arguments: DIAGNOSTIC_PE1__161438176
(34) Project
Arguments: [CODE_CIM_10_161439#2483887 AS DIAGNOSTIC_PE1__161438_CODE_CIM_10_161439#2484106, DATE_EFFET_161441#2483882 AS DIAGNOSTIC_PE1__161438_DATE_EFFET_161441#2484107, DATE_REVOCATION_161442#2483883 AS DIAGNOSTIC_PE1__161438_DATE_REVOCATION_161442#2484108, LIBELLE_LONG_161440#2483884 AS DIAGNOSTIC_PE1__161438_LIBELLE_LONG_161440#2484109, RESPONSABLE_MAJ_161443#2483885 AS DIAGNOSTIC_PE1__161438_RESPONSABLE_MAJ_161443#2484110, SOURCE_161444#2483886 AS DIAGNOSTIC_PE1__161438_SOURCE_161444#2484111, CODE_CIM10_NORM_161445#2483894 AS DIAGNOSTIC_PE1__161438_CODE_CIM10_NORM_161445#2484112]
(35) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484094 = DIAGNOSTIC_PE1__161438_CODE_CIM10_NORM_161445#2484112)
(36) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484093, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484094, COL_63526921_A0EA_4239_B888_806A810EA728#2484095, DIAGNOSTIC_PE1__161438_CODE_CIM_10_161439#2484106 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484140]
(37) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484093, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484094, COL_63526921_A0EA_4239_B888_806A810EA728#2484095, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484140, str_if_with_rule(isnotnull(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484140), cast(1 as string), cast(0 as string)) AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484145]
(38) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484093 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484151, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484094 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484152, COL_63526921_A0EA_4239_B888_806A810EA728#2484095 AS COL_63526921_A0EA_4239_B888_806A810EA728#2484153, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484140 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484154, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484145 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484155]
(39) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484151 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484161, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484152 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484162, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484155 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484163, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484154 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484164, COL_63526921_A0EA_4239_B888_806A810EA728#2484153 AS COL_63526921_A0EA_4239_B888_806A810EA728#2484165]
(40) LogicalRelation
Arguments: parquet, [Code+CIM+10#2483902, Libell%C3%A9+long#2483903, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908], false
(41) Project
Arguments: [Code+CIM+10#2483902 AS Code CIM 10#2483916, Libell%C3%A9+long#2483903, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(42) Project
Arguments: [Code CIM 10#2483916, Libell%C3%A9+long#2483903 AS Libellé long#2483925, Responsable+MAJ#2483904, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(43) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable+MAJ#2483904 AS Responsable MAJ#2483933, Source#2483905, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(44) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483905 AS Source#2483941, Date_effet#2483906, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(45) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483906 AS Date_effet#2483949, Date_r%C3%A9vocation#2483907, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(46) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483949, Date_r%C3%A9vocation#2483907 AS Date_révocation#2483957, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908]
(47) Project
Arguments: [Code CIM 10#2483916, Libellé long#2483925, Responsable MAJ#2483933, Source#2483941, Date_effet#2483949, Date_révocation#2483957, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483908 AS DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483965]
(48) Project
Arguments: [Code CIM 10#2483916 AS Code CIM 10#2483973, Libellé long#2483925 AS Libellé long#2483974, Responsable MAJ#2483933 AS Responsable MAJ#2483975, Source#2483941 AS Source#2483976, Date_effet#2483949 AS Date_effet#2483977, Date_révocation#2483957 AS Date_révocation#2483978, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483965 AS DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483979]
(49) Project
Arguments: [Code CIM 10#2483973, Libellé long#2483974, Responsable MAJ#2483975, Source#2483976, Date_effet#2483977, Date_révocation#2483978, DIAGNOSTIC_PE2__161424HEADER_COL_DETAIL_DEPOT#2483979]
(50) Project
Arguments: [cast(str_remove_space(str_remove_extend(Code CIM 10#2483973, array(cast(. as string))), cast(RIGHT as string)) as string) AS CODE_CIM_10_161542#2484000, Date_effet#2483977 AS DATE_EFFET_161544#2483995, Date_révocation#2483978 AS DATE_REVOCATION_161545#2483996, Libellé long#2483974 AS LIBELLE_LONG_161543#2483997, Responsable MAJ#2483975 AS RESPONSABLE_MAJ_161546#2483998, Source#2483976 AS SOURCE_161547#2483999]
(51) Project
Arguments: [CODE_CIM_10_161542#2484000, DATE_EFFET_161544#2483995, DATE_REVOCATION_161545#2483996, LIBELLE_LONG_161543#2483997, RESPONSABLE_MAJ_161546#2483998, SOURCE_161547#2483999, str_remove_space(str_remove_extend(CODE_CIM_10_161542#2484000, array(cast(. as string))), cast(RIGHT as string)) AS CODE_CIM10_NORM_161548#2484007]
(52) View
Arguments: `DIAGNOSTIC_PE2__161541176`, true
(53) SubqueryAlias
Arguments: DIAGNOSTIC_PE2__161541176
(54) Project
Arguments: [CODE_CIM_10_161542#2484000 AS DIAGNOSTIC_PE2__161541_CODE_CIM_10_161542#2484178, DATE_EFFET_161544#2483995 AS DIAGNOSTIC_PE2__161541_DATE_EFFET_161544#2484179, DATE_REVOCATION_161545#2483996 AS DIAGNOSTIC_PE2__161541_DATE_REVOCATION_161545#2484180, LIBELLE_LONG_161543#2483997 AS DIAGNOSTIC_PE2__161541_LIBELLE_LONG_161543#2484181, RESPONSABLE_MAJ_161546#2483998 AS DIAGNOSTIC_PE2__161541_RESPONSABLE_MAJ_161546#2484182, SOURCE_161547#2483999 AS DIAGNOSTIC_PE2__161541_SOURCE_161547#2484183, CODE_CIM10_NORM_161548#2484007 AS DIAGNOSTIC_PE2__161541_CODE_CIM10_NORM_161548#2484184]
(55) Join
Arguments: LeftOuter, (COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484162 = DIAGNOSTIC_PE2__161541_CODE_CIM10_NORM_161548#2484184)
(56) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484161, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484162, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484163, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484164, COL_63526921_A0EA_4239_B888_806A810EA728#2484165, DIAGNOSTIC_PE2__161541_CODE_CIM_10_161542#2484178 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484216]
(57) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484161, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484162, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484163, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484164, COL_63526921_A0EA_4239_B888_806A810EA728#2484165, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484216, str_if_with_rule(isnotnull(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484216), cast(1 as string), cast(0 as string)) AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484223]
(58) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484161 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484231, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484162 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484232, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484163 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484233, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484164 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484234, COL_63526921_A0EA_4239_B888_806A810EA728#2484165 AS COL_63526921_A0EA_4239_B888_806A810EA728#2484235, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484216 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484236, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484223 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484237]
(59) Project
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484231 AS COL_A188B73D_4933_4923_828E_687FE72CE189#2484245, COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484232 AS COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484246, COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484233 AS COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484247, COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484237 AS COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484248, COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484236 AS COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484249, COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484234 AS COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484250, COL_63526921_A0EA_4239_B888_806A810EA728#2484235 AS COL_63526921_A0EA_4239_B888_806A810EA728#2484251]
(60) Aggregate
Arguments: [COL_A188B73D_4933_4923_828E_687FE72CE189#2484245], [COL_A188B73D_4933_4923_828E_687FE72CE189#2484245 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484259, 1 AS NULL_1#2484283, max(COL_8E83DA5F_0319_4C71_A57F_EB8028C126EB#2484247) AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484268, max(COL_CEA89754_0D9E_4D31_BC11_226DBE26276F#2484248) AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484270, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_D1E62AC3_9D22_4956_8B06_3DF990F627F2#2484246), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@6a929bf3, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484274, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_FBBF269F_6C60_4151_97F8_E09621CDA28C#2484250), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@2bee2397, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484278, concatwithseparatorudaf(ARRAY_TO_STR_BEFORE_CONCAT(COL_17A0F81D_FDA8_42AC_B142_4E64FA588FEA#2484249), com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@3726bb99, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484282]
(61) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484259, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484268, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484270, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484274, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484278, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484282]
(62) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484259 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484336, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484268 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484337, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484270 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484338, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484274 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484339, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484278 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484340, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484282 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484341]
(63) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484336 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484348, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484337 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484349, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484338 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484350, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484339 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484351, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484340 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484352, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484341 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484353]
(64) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484348 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484360, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484349 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484361, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484350 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484362, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484351 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484363, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484352 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484364, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484353 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484365]
(65) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484360 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484372, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484361 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484373, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484362 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484374, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484363 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484375, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484364 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484376, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484365 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484377]
(66) Project
Arguments: [COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484372 AS COL_259E9494_8CB4_4AA8_AECC_3EBA7C8B80FB#2484384, COL_22F494F7_741E_40CC_932F_1428DA298F77#2484373 AS COL_22F494F7_741E_40CC_932F_1428DA298F77#2484385, COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484374 AS COL_F1C1F6ED_07EB_492F_A7A5_F42040F97810#2484386, COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484375 AS COL_22564C4C_27A7_4316_AD62_101B7408E7AA#2484387, COL_7F63CD51_FF18_434B_926C_8420A0519999#2484376 AS COL_7F63CD51_FF18_434B_926C_8420A0519999#2484388, COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484377 AS COL_DB74F3CF_13F5_4E2A_91A4_26A2BD9ABDC3#2484389]