== Physical Plan ==
AdaptiveSparkPlan (43)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (3)
+- WriteFiles (2)
+- LocalTableScan (1)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (42)
+- WriteFiles (41)
+- Project (40)
+- Project (39)
+- Project (38)
+- Project (37)
+- Project (36)
+- Generate (35)
+- Project (34)
+- Project (33)
+- Project (32)
+- Project (31)
+- Filter (30)
+- Window (29)
+- Sort (28)
+- Project (27)
+- SortMergeJoin LeftOuter (26)
:- Project (20)
: +- Filter (19)
: +- Window (18)
: +- Sort (17)
: +- Project (16)
: +- Window (15)
: +- Sort (14)
: +- Window (13)
: +- Sort (12)
: +- Exchange (11)
: +- Project (10)
: +- CartesianProduct Inner (9)
: :- Project (5)
: : +- Scan parquet (4)
: +- Project (8)
: +- Filter (7)
: +- Scan csv (6)
+- Sort (25)
+- Exchange (24)
+- Project (23)
+- Filter (22)
+- Scan parquet (21)
(1) LocalTableScan
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#529666, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
Arguments: <empty>, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#529666, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
(2) WriteFiles
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#529666, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081], Overwrite, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586, COL_D055870D_7682_4410_A82D_BC4C41964169, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26, COL_63CCC378_62A4_4226_A892_27ED03D11185, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_8081145F_99B8_4EEC_AAB4_325C38549922, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8, COL_032696D7_7058_44F0_ABC3_DB207100F75A, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D]
(4) Scan parquet
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#527542, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#527575, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#527583, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#527590]
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_F45E0732_AB66_4936_AECE_1F9475288E1E:string,COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>
(5) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#527542 AS COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#527583 AS COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#527575 AS COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#527590 AS COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#527542, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#527575, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#527583, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#527590]
(6) Scan csv
Output [2]: [REGLES#527523, APPLICABLE#527524]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SIC/SIM), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(7) Filter
Input [2]: [REGLES#527523, APPLICABLE#527524]
Condition : ((isnotnull(REGLES#527523) AND (RC-SIC/SIM = REGLES#527523)) AND (APPLICABLE#527524 <=> O))
(8) Project
Output [1]: [APPLICABLE#527524 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#528049]
Input [2]: [REGLES#527523, APPLICABLE#527524]
(9) CartesianProduct
Join type: Inner
Join condition: None
(10) Project
Output [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, REGLES_A_APPLIQ_225642_APPLICABLE_225644#528049 AS COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, *, LEFT) AS COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, *, RIGHT) AS COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124]
Input [5]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, REGLES_A_APPLIQ_225642_APPLICABLE_225644#528049]
(11) Exchange
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124]
Arguments: hashpartitioning(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, 10), ENSURE_REQUIREMENTS, [plan_id=322351]
(12) Sort
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST], false, 0
(13) Window
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124]
Arguments: [collect_set(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_63CCC378_62A4_4226_A892_27ED03D11185#528284], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST]
(14) Sort
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037 ASC NULLS FIRST, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(15) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284]
Arguments: [collect_set(COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#528146], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124], [1 DESC NULLS LAST]
(16) Project
Output [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, str_list_as_str(COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#528146) AS COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, ARRAY_TO_STR_BEFORE_CONCAT(COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040) AS _w0#528329]
Input [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#528115, COL_15562112_F77D_4D34_9215_7F07DD688A1B#528124, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#528146]
(17) Sort
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, _w0#528329]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST], false, 0
(18) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, _w0#528329]
Arguments: [concatwithseparatorudaf(_w0#528329, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@43a0a6c1, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039 ASC NULLS LAST]
(19) Filter
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, _w0#528329, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393]
Condition : (COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393 <=> 1)
(20) Project
Output [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060]
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, _w0#528329, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393]
(21) Scan parquet
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#527753, COL_F76265AB_8748_4114_92B4_00E37DE25D34#527757, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#527791, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#527792]
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_B8D0B7A4_71CB_4406_88C1_4791F02E29EF:array<string>,COL_AA499A88_B893_47E4_99C5_0EB9F6D69842:string>
(22) Filter
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#527753, COL_F76265AB_8748_4114_92B4_00E37DE25D34#527757, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#527791, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#527792]
Condition : isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#527757)
(23) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#527753 AS 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#528589, COL_F76265AB_8748_4114_92B4_00E37DE25D34#527757 AS 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#527791 AS 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#528627, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#527792 AS 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#528628]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#527753, COL_F76265AB_8748_4114_92B4_00E37DE25D34#527757, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#527791, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#527792]
(24) Exchange
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#528589, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#528627, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#528628]
Arguments: hashpartitioning(02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593, 10), ENSURE_REQUIREMENTS, [plan_id=322365]
(25) Sort
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#528589, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#528627, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#528628]
Arguments: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593 ASC NULLS FIRST], false, 0
(26) SortMergeJoin
Left keys [1]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037]
Right keys [1]: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593]
Join type: LeftOuter
Join condition: None
(27) Project
Output [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#528589 AS COL_D055870D_7682_4410_A82D_BC4C41964169#528825, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#528627 AS COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#528628 AS COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827]
Input [13]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#528589, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#528593, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#528627, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#528628]
(28) Sort
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037 ASC NULLS FIRST, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827 DESC NULLS LAST], false, 0
(29) Window
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827]
Arguments: [collect_set(COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#528924], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037], [COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827 DESC NULLS LAST]
(30) Filter
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#528924]
Condition : ((COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#528924 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)))))
(31) Project
Output [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039) AS COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#529034]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#528924]
(32) Project
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, array_except(array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#529034), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#529054, array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#529034)) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#529075]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#529034]
(33) Project
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, str_join(array(str_join(array(SIC/SIM Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#529054)), : ), str_join(array(SIC/SIM dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#529075)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864)), : )), - ) AS COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#529054), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#529075), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)) AS COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#529054, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#529075]
(34) Project
Output [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, size(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, true) AS COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233]
(35) Generate
Input [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255]
Arguments: explode(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233), [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255], false, [COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279]
(36) Project
Output [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, str_create(RC-SIC/SIM) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, str_remove_space(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420]
Input [17]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279]
(37) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, +) END, str_extract_key_value(COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, RIGHT, 3))), VALUE), str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473, str_list_as_str(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233) AS COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501]
Input [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#529233, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420]
(38) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473) AS COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#529473, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501]
(39) Project
Output [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, LEFT, 4), !, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, str_if_with_rule((((((COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255 <=> 2) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, SIC)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, SIC) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, SIM)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, SIM) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, +)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, +) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, -)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, -) END), 1, ) AS COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#529420, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530]
(40) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, +) END, str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591 <=> 1), str_concat(array(Switch de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, RIGHT, 2))), str_concat(array(Ajout de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, RIGHT, 2)))), str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591 <=> 1), str_concat(array(Switch de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, RIGHT, 2))), str_concat(array(Suppression de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, RIGHT, 2))))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#529666, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
Input [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#529279, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#529530, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
(41) WriteFiles
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#528037, COL_D055870D_7682_4410_A82D_BC4C41964169#528825, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#528039, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#528040, COL_63CCC378_62A4_4226_A892_27ED03D11185#528284, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#528328, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#528826, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#528827, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#529395, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#529560, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#529666, COL_8081145F_99B8_4EEC_AAB4_325C38549922#528393, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#529169, COL_032696D7_7058_44F0_ABC3_DB207100F75A#528041, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#528864, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#528256, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#528060, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#529255, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#529501, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#529591]
(42) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081], Overwrite, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586, COL_D055870D_7682_4410_A82D_BC4C41964169, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26, COL_63CCC378_62A4_4226_A892_27ED03D11185, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_8081145F_99B8_4EEC_AAB4_325C38549922, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8, COL_032696D7_7058_44F0_ABC3_DB207100F75A, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D]
(43) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true