== Physical Plan ==
AdaptiveSparkPlan (35)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (3)
+- WriteFiles (2)
+- LocalTableScan (1)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (34)
+- WriteFiles (33)
+- Project (32)
+- Project (31)
+- Project (30)
+- Project (29)
+- Generate (28)
+- Project (27)
+- Project (26)
+- Filter (25)
+- Window (24)
+- Sort (23)
+- Project (22)
+- SortMergeJoin LeftOuter (21)
:- Project (15)
: +- Window (14)
: +- Project (13)
: +- Window (12)
: +- Sort (11)
: +- Exchange (10)
: +- CartesianProduct Inner (9)
: :- Project (5)
: : +- Scan parquet (4)
: +- Project (8)
: +- Filter (7)
: +- Scan csv (6)
+- Sort (20)
+- Exchange (19)
+- Project (18)
+- Filter (17)
+- Scan parquet (16)
(1) LocalTableScan
Output [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#524340, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Arguments: <empty>, [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#524340, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
(2) WriteFiles
Input [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#524340, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SAS_226023, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SAS_226023], Overwrite, [COL_D610971A_3CE5_4463_92C0_C0A5309658BE, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26, COL_6E1D5B77_8073_43D0_992B_909644A54726]
(4) Scan parquet
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#522739, COL_A28E7C10_52DA_469E_B838_1040D4667E96#522765, COL_3986DFE6_43DA_40D6_ADC7_0AA898F8AF56#522779, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#522787]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_A28E7C10_52DA_469E_B838_1040D4667E96:string,COL_3986DFE6_43DA_40D6_ADC7_0AA898F8AF56:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>
(5) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#522739 AS COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_A28E7C10_52DA_469E_B838_1040D4667E96#522765 AS COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155, COL_3986DFE6_43DA_40D6_ADC7_0AA898F8AF56#522779 AS COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#522787 AS COL_072F9B89_90D0_4807_812C_34E065AA368B#523157]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#522739, COL_A28E7C10_52DA_469E_B838_1040D4667E96#522765, COL_3986DFE6_43DA_40D6_ADC7_0AA898F8AF56#522779, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#522787]
(6) Scan csv
Output [2]: [REGLES#522718, APPLICABLE#522719]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SAS), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(7) Filter
Input [2]: [REGLES#522718, APPLICABLE#522719]
Condition : ((isnotnull(REGLES#522718) AND (RC-SAS = REGLES#522718)) AND (APPLICABLE#522719 <=> O))
(8) Project
Output: []
Input [2]: [REGLES#522718, APPLICABLE#522719]
(9) CartesianProduct
Join type: Inner
Join condition: None
(10) Exchange
Input [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155, COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157]
Arguments: hashpartitioning(COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, 10), ENSURE_REQUIREMENTS, [plan_id=319460]
(11) Sort
Input [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155, COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157]
Arguments: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(12) Window
Input [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155, COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157]
Arguments: [collect_set(COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, 0, 0) windowspecdefinition(COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226], [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153], [1 DESC NULLS LAST]
(13) Project
Output [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, ARRAY_TO_STR_BEFORE_CONCAT(COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155) AS _w0#523259]
Input [5]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_187F79B5_42D2_4100_970A_EC9704FBFB8D#523155, COL_EAE35BEC_3A66_41B2_8FFA_9099B7BC18D2#523156, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226]
(14) Window
Input [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, _w0#523259]
Arguments: [concatwithseparatorudaf(_w0#523259, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@32cbd937, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, collect_set(COL_072F9B89_90D0_4807_812C_34E065AA368B#523157, 0, 0) windowspecdefinition(COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307], [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153], [1 DESC NULLS LAST]
(15) Project
Output [4]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307]
Input [6]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_072F9B89_90D0_4807_812C_34E065AA368B#523157, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, _w0#523259, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307]
(16) Scan parquet
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#522849, COL_F76265AB_8748_4114_92B4_00E37DE25D34#522853, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#522885, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#522886]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_225697]
PushedFilters: [IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_D7508510_B4D7_44C5_A063_A2132B6EF08A:array<string>,COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E:string>
(17) Filter
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#522849, COL_F76265AB_8748_4114_92B4_00E37DE25D34#522853, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#522885, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#522886]
Condition : isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#522853)
(18) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#522849 AS 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#523428, COL_F76265AB_8748_4114_92B4_00E37DE25D34#522853 AS 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#522885 AS 02_A_ELIGIBLE_225697_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#523464, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#522886 AS 02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#522849, COL_F76265AB_8748_4114_92B4_00E37DE25D34#522853, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#522885, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#522886]
(19) Exchange
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#523428, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432, 02_A_ELIGIBLE_225697_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#523464, 02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465]
Arguments: hashpartitioning(02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432, 10), ENSURE_REQUIREMENTS, [plan_id=319468]
(20) Sort
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#523428, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432, 02_A_ELIGIBLE_225697_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#523464, 02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465]
Arguments: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432 ASC NULLS FIRST], false, 0
(21) SortMergeJoin
Left keys [1]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153]
Right keys [1]: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432]
Join type: LeftOuter
Join condition: None
(22) Project
Output [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#523428 AS COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, 02_A_ELIGIBLE_225697_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#523464 AS COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, 02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465 AS COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, str_if_with_rule((NOT (02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465 <=> ) AND isnotnull(02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465)), Oui, ) AS COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Input [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#523428, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#523432, 02_A_ELIGIBLE_225697_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#523464, 02_A_ELIGIBLE_225697_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#523465]
(23) Sort
Input [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Arguments: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153 ASC NULLS FIRST, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672 DESC NULLS LAST], false, 0
(24) Window
Input [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Arguments: [row_number() windowspecdefinition(COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_AA36D0E0_CE08_45F6_91B6_44E1CC4526A0#523740], [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153], [COL_6E1D5B77_8073_43D0_992B_909644A54726#523672 DESC NULLS LAST]
(25) Filter
Input [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_AA36D0E0_CE08_45F6_91B6_44E1CC4526A0#523740]
Condition : ((COL_AA36D0E0_CE08_45F6_91B6_44E1CC4526A0#523740 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace(str_list_as_str(array_except(COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657)), SAS, SAS+), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace(str_list_as_str(array_except(COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226)), SAS, SAS-), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace(str_list_as_str(array_except(COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657)), SAS, SAS+), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace(str_list_as_str(array_except(COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226)), SAS, SAS-), [[,",]], [,,]), ,)))))
(26) Project
Output [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, array_except(COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#523912, array_except(COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#523913, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Input [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_50D75E8B_5722_4B45_9671_DAFCAF82B2F4#523226, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_346FC3A4_6C88_4CAC_9D30_A367B8565C7C#523657, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_AA36D0E0_CE08_45F6_91B6_44E1CC4526A0#523740]
(27) Project
Output [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, str_list_union(str_split(str_replace_extend(str_replace(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#523912), SAS, SAS+), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#523913), SAS, SAS-), [[,",]], [,,]), ,)) AS COL_A15743F2_88F9_4366_9571_19F6AE10AC4A#523974, str_join(array(str_join(array(SAS déduit Infos Patient Absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#523912)), : ), str_join(array(SAS dans RSF Absent des infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#523913)), : ), str_join(array(acte - Spé - date , str_list_as_str(COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307)), : )), - ) AS COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995]
Input [8]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#523912, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#523913, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_68E9A79C_5593_4C58_BE95_1E6F18B96608#523307, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
(28) Generate
Input [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_A15743F2_88F9_4366_9571_19F6AE10AC4A#523974, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995]
Arguments: explode(COL_A15743F2_88F9_4366_9571_19F6AE10AC4A#523974), [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995], false, [COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018]
(29) Project
Output [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, str_create(RC-SAS) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, str_remove_space(COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159]
Input [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018]
(30) Project
Output [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, str_if_with_rule(CASE WHEN isnull(Contains(COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, +)) THEN false ELSE Contains(COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, +) END, str_extract_key_value(COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, RIGHT, 3))), VALUE), str_extract_by_str(COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204]
Input [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_95CA2C0E_097C_48E4_B09E_2C4E540556C5#523258, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159]
(31) Project
Output [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, LEFT, 4), !, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255]
Input [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#524159, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204]
(32) Project
Output [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, str_if_with_rule(CASE WHEN isnull(Contains(COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, +)) THEN false ELSE Contains(COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, +) END, str_concat(array(Ajout de forfait@, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, RIGHT, 2))), str_concat(array(Suppression de Forfait@, str_concat(array(str_extract_by_str(COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#524340, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
Input [9]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_F4BB4755_50C3_48E5_A18D_C60C341B5D87#523658, COL_E3BC6B96_6FDA_4A4A_B538_8F14DC385158#524018, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#524204, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255]
(33) WriteFiles
Input [7]: [COL_D610971A_3CE5_4463_92C0_C0A5309658BE#523153, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD#523656, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#524138, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#524255, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#524340, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26#523995, COL_6E1D5B77_8073_43D0_992B_909644A54726#523672]
(34) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SAS_226023, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SAS_226023], Overwrite, [COL_D610971A_3CE5_4463_92C0_C0A5309658BE, COL_37FB33EF_F56C_40A0_8E69_3CD53BA5E5BD, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_9297F7A5_EA15_4188_A13A_37E1612F4D26, COL_6E1D5B77_8073_43D0_992B_909644A54726]
(35) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true