== Physical Plan ==
AdaptiveSparkPlan (47)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (3)
+- WriteFiles (2)
+- LocalTableScan (1)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (46)
+- WriteFiles (45)
+- Project (44)
+- Project (43)
+- Project (42)
+- Project (41)
+- Project (40)
+- Window (39)
+- Sort (38)
+- Exchange (37)
+- Project (36)
+- Generate (35)
+- Project (34)
+- Project (33)
+- Filter (32)
+- Window (31)
+- Sort (30)
+- Project (29)
+- SortMergeJoin Inner (28)
:- Project (22)
: +- Window (21)
: +- Project (20)
: +- Window (19)
: +- Sort (18)
: +- Exchange (17)
: +- Project (16)
: +- Filter (15)
: +- Window (14)
: +- Sort (13)
: +- Exchange (12)
: +- Project (11)
: +- CartesianProduct Inner (10)
: :- Project (6)
: : +- Filter (5)
: : +- Scan parquet (4)
: +- Project (9)
: +- Filter (8)
: +- Scan csv (7)
+- Sort (27)
+- Exchange (26)
+- Project (25)
+- Filter (24)
+- Scan parquet (23)
(1) LocalTableScan
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1312107, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Arguments: <empty>, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1312107, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
(2) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1312107, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
(3) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_188253, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_188253], Overwrite, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C]
(4) Scan parquet
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1309433, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1309455, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1309467, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1309475, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1309481]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_188400]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_7D270645_B926_42AF_A110_EB3A1A53031B:string,COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157:string,COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>
(5) Filter
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1309433, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1309455, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1309467, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1309475, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1309481]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1309433)
(6) Project
Output [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1309433 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1309475 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1309467 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1309481 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1309455 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942]
Input [5]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1309433, COL_7D270645_B926_42AF_A110_EB3A1A53031B#1309455, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#1309467, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#1309475, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1309481]
(7) Scan csv
Output [2]: [REGLES#1309160, APPLICABLE#1309161]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_187903/REGLES-A-TTT new BESANCON 050226.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(8) Filter
Input [2]: [REGLES#1309160, APPLICABLE#1309161]
Condition : ((isnotnull(REGLES#1309160) AND (RC-SSN-SSF = REGLES#1309160)) AND (APPLICABLE#1309161 <=> O))
(9) Project
Output: []
Input [2]: [REGLES#1309160, APPLICABLE#1309161]
(10) CartesianProduct
Join type: Inner
Join condition: None
(11) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279]
Input [5]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942]
(12) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, 10), ENSURE_REQUIREMENTS, [plan_id=747302]
(13) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942 ASC NULLS LAST], false, 0
(14) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942 ASC NULLS LAST]
(15) Filter
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387 <=> 1)
(16) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#1310228, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
(17) Exchange
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, 10), ENSURE_REQUIREMENTS, [plan_id=747308]
(18) Sort
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(19) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937], [1 DESC NULLS LAST]
(20) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940) AS _w0#1310598]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#1309939, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#1309940, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545]
(21) Window
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, _w0#1310598]
Arguments: [concatwithseparatorudaf(_w0#1310598, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@68e4fe5d, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937], [1 DESC NULLS LAST]
(22) Project
Output [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Input [8]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, _w0#1310598, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597]
(23) Scan parquet
Output [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1301286, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1301287, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1301291, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1301327, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1301328]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_188318]
PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A), IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56:string,COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_95383EBC_3648_4E94_9C53_D311092BF5F4:array<string>,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD:string>
(24) Filter
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1301286, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1301287, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1301291, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1301327, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1301328]
Condition : ((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1301286) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1301286)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#1301291))
(25) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1301287 AS 02_A_ELIGIBLE_188318_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1310744, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1301291 AS 02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1301327 AS 02_A_ELIGIBLE_188318_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1310784, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1301328 AS 02_A_ELIGIBLE_188318_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1310785]
Input [5]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1301286, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1301287, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1301291, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1301327, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1301328]
(26) Exchange
Input [4]: [02_A_ELIGIBLE_188318_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1310744, 02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748, 02_A_ELIGIBLE_188318_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1310784, 02_A_ELIGIBLE_188318_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1310785]
Arguments: hashpartitioning(02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748, 10), ENSURE_REQUIREMENTS, [plan_id=747316]
(27) Sort
Input [4]: [02_A_ELIGIBLE_188318_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1310744, 02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748, 02_A_ELIGIBLE_188318_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1310784, 02_A_ELIGIBLE_188318_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1310785]
Arguments: [02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748 ASC NULLS FIRST], false, 0
(28) SortMergeJoin
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937]
Right keys [1]: [02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748]
Join type: Inner
Join condition: None
(29) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, 02_A_ELIGIBLE_188318_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1310744 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, 02_A_ELIGIBLE_188318_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1310784 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, 02_A_ELIGIBLE_188318_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1310785 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, 02_A_ELIGIBLE_188318_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1310744, 02_A_ELIGIBLE_188318_COL_F76265AB_8748_4114_92B4_00E37DE25D34#1310748, 02_A_ELIGIBLE_188318_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#1310784, 02_A_ELIGIBLE_188318_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#1310785]
(30) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989 DESC NULLS LAST], false, 0
(31) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1311078], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989 DESC NULLS LAST]
(32) Filter
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1311078]
Condition : ((COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1311078 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988)), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545)), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)))))
(33) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1311190, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1311215]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#1310545, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#1309941, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#1310988, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#1311078]
(34) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1311190)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1311215)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1311190), [SSN,SSF], [SSN+,SSF+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1311215), [SSN,SSF], [SSN-,SSF-]), [[,",]], [,,]), ,)) AS COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1311395]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#1311024, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#1311190, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#1311215]
(35) Generate
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1311395]
Arguments: explode(COL_DD5D4F74_6719_435E_ACCF_6D12BBA233D8#1311395), [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387], false, [COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420]
(36) Project
Output [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, str_extract_by_str(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, *, RIGHT) AS COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420]
(37) Exchange
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541]
Arguments: hashpartitioning(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541, 10), ENSURE_REQUIREMENTS, [plan_id=747329]
(38) Sort
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541]
Arguments: [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985 ASC NULLS FIRST, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(39) Window
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541]
Arguments: [count(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420) windowspecdefinition(COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L], [COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541], [1 DESC NULLS LAST]
(40) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, str_create(RC-SSN-SSF) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, str_remove_space(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786]
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_6BE21DA6_0AA7_4FA6_8C0A_A46C38416DAB#1311541, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L]
(41) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, +) END, str_extract_key_value(COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, RIGHT, 3))), VALUE), str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#1310597, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786]
(42) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845) AS COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#1311845]
(43) Project
Output [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, LEFT, 4), !, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#1311786, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890]
(44) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, str_if_with_rule(CASE WHEN isnull(Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, +)) THEN false ELSE Contains(COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, +) END, str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L <=> 1), Ajout de forfait@, Switch de forfait@), COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, RIGHT, 2))), str_concat(array(str_if_with_rule((COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L <=> 1), Suppression de Forfait@, Switch de Forfait@), str_concat(array(str_extract_by_str(COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, RIGHT, 2)))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1312107, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_A1DFE0E6_4EBB_4300_B095_859EA0848893#1311420, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#1310989, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_F7CE0F37_6AB9_4644_907D_E577689D258D#1311598L, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_3305F1DF_8C20_4CFA_9A3F_CC35D97A2B36#1311890, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923]
(45) WriteFiles
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#1309937, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#1310985, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#1311758, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#1311923, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#1312107, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#1311324, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#1309942, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#1310279, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#1310387]
(46) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SSN_SSF_188253, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SSN_SSF_188253], Overwrite, [COL_568DEDCB_F936_41B1_A0EC_986E8205D003, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C]
(47) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true