== Physical Plan ==
AdaptiveSparkPlan (69)
+- == Final Plan ==
* Project (39)
+- * Project (38)
+- * Filter (37)
+- Window (36)
+- * Sort (35)
+- * Project (34)
+- * SortMergeJoin Inner (33)
:- * Project (24)
: +- Window (23)
: +- * Project (22)
: +- Window (21)
: +- * Sort (20)
: +- AQEShuffleRead (19)
: +- ShuffleQueryStage (18), Statistics(sizeInBytes=392.0 B, rowCount=2)
: +- Exchange (17)
: +- * Project (16)
: +- * Filter (15)
: +- Window (14)
: +- * Sort (13)
: +- AQEShuffleRead (12)
: +- ShuffleQueryStage (11), Statistics(sizeInBytes=1120.0 B, rowCount=7)
: +- Exchange (10)
: +- * Project (9)
: +- CartesianProduct Inner (8)
: :- * Project (4)
: : +- * Filter (3)
: : +- * ColumnarToRow (2)
: : +- Scan parquet (1)
: +- * Project (7)
: +- * Filter (6)
: +- Scan csv (5)
+- * Sort (32)
+- AQEShuffleRead (31)
+- ShuffleQueryStage (30), Statistics(sizeInBytes=112.0 B, rowCount=1)
+- Exchange (29)
+- * Project (28)
+- * Filter (27)
+- * ColumnarToRow (26)
+- Scan parquet (25)
+- == Initial Plan ==
CollectLimit (68)
+- Project (67)
+- Project (66)
+- Filter (65)
+- Window (64)
+- Sort (63)
+- Project (62)
+- SortMergeJoin Inner (61)
:- Project (56)
: +- Window (55)
: +- Project (54)
: +- Window (53)
: +- Sort (52)
: +- Exchange (51)
: +- Project (50)
: +- Filter (49)
: +- Window (48)
: +- Sort (47)
: +- Exchange (46)
: +- Project (45)
: +- CartesianProduct Inner (44)
: :- Project (41)
: : +- Filter (40)
: : +- Scan parquet (1)
: +- Project (43)
: +- Filter (42)
: +- Scan csv (5)
+- Sort (60)
+- Exchange (59)
+- Project (58)
+- Filter (57)
+- Scan parquet (25)
(1) Scan parquet
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_210234]
PushedFilters: [EqualNullSafe(COL_64ED17E5_A991_405B_AEED_8A2977283F76,011040518), IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62: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,COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF:timestamp>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
(3) Filter [codegen id : 1]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
Condition : ((COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430 <=> 011040518) AND isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430))
(4) Project [codegen id : 1]
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
(5) Scan csv
Output [2]: [REGLES#794664, APPLICABLE#794665]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_209983/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SSN-SSF), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#794664, APPLICABLE#794665]
Condition : ((isnotnull(REGLES#794664) AND (RC-SSN-SSF = REGLES#794664)) AND (APPLICABLE#794665 <=> O))
(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#794664, APPLICABLE#794665]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
(10) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, 10), ENSURE_REQUIREMENTS, [plan_id=489466]
(11) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: 0
(12) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: coalesced
(13) Sort [codegen id : 5]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST], false, 0
(14) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST]
(15) Filter [codegen id : 6]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218 <=> 1)
(16) Project [codegen id : 6]
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218]
(17) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 10), ENSURE_REQUIREMENTS, [plan_id=489624]
(18) ShuffleQueryStage
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: 2
(19) AQEShuffleRead
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: coalesced
(20) Sort [codegen id : 7]
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(21) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [1 DESC NULLS LAST]
(22) Project [codegen id : 8]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975) AS _w0#795432]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378]
(23) Window
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, _w0#795432]
Arguments: [concatwithseparatorudaf(_w0#795432, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@72f4f322, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [1 DESC NULLS LAST]
(24) Project [codegen id : 9]
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, _w0#795432, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431]
(25) Scan parquet
Output [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_210376]
PushedFilters: [IsNotNull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56), EqualTo(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56,A), EqualNullSafe(COL_F76265AB_8748_4114_92B4_00E37DE25D34,011040518), 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_D7508510_B4D7_44C5_A063_A2132B6EF08A:array<string>,COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E:string,COL_95383EBC_3648_4E94_9C53_D311092BF5F4:array<string>,COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD:string>
(26) ColumnarToRow [codegen id : 4]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
(27) Filter [codegen id : 4]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
Condition : (((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686)) AND (COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691 <=> 011040518)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691))
(28) Project [codegen id : 4]
Output [6]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687 AS 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691 AS 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723 AS 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724 AS 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727 AS 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728 AS 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
(29) Exchange
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: hashpartitioning(02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 10), ENSURE_REQUIREMENTS, [plan_id=489513]
(30) ShuffleQueryStage
Output [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: 1
(31) AQEShuffleRead
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: coalesced
(32) Sort [codegen id : 10]
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586 ASC NULLS FIRST], false, 0
(33) SortMergeJoin [codegen id : 11]
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972]
Right keys [1]: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586]
Join type: Inner
Join condition: None
(34) Project [codegen id : 11]
Output [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618 AS COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619 AS COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Input [17]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
(35) Sort [codegen id : 11]
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST], false, 0
(36) Window
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST]
(37) Filter [codegen id : 12]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910]
Condition : (COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910 <=> 1)
(38) Project [codegen id : 12]
Output [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910]
(39) Project [codegen id : 12]
Output [21]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#796099, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040]
(40) Filter
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
Condition : ((COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430 <=> 011040518) AND isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430))
(41) Project
Output [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430 AS COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431 AS COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472 AS COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464 AS COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478 AS COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452 AS COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483 AS COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [7]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#794430, COL_46E1DB98_C579_4CA8_91D3_EC36371C7D62#794431, COL_7D270645_B926_42AF_A110_EB3A1A53031B#794452, COL_6A592B9A_2D06_43E1_B7F3_F39B1EC01157#794464, COL_DC641C8D_1EAF_49BD_A02D_E74816E44C28#794472, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#794478, COL_592FCE63_4482_4A2D_9C45_50C2EEAA8ABF#794483]
(42) Filter
Input [2]: [REGLES#794664, APPLICABLE#794665]
Condition : ((isnotnull(REGLES#794664) AND (RC-SSN-SSF = REGLES#794664)) AND (APPLICABLE#794665 <=> O))
(43) Project
Output: []
Input [2]: [REGLES#794664, APPLICABLE#794665]
(44) CartesianProduct
Join type: Inner
Join condition: None
(45) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, *, RIGHT) AS COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, str_extract_by_str(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, *, RIGHT) AS COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Input [7]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
(46) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, 10), ENSURE_REQUIREMENTS, [plan_id=489398]
(47) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146 ASC NULLS FIRST, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST], false, 0
(48) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186]
Arguments: [row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146], [COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977 ASC NULLS LAST]
(49) Filter
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218]
Condition : (COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218 <=> 1)
(50) Project
Output [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_C97CE078_7AD5_4D54_A5FF_290B4E6B18FF#795146, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218]
(51) Exchange
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: hashpartitioning(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 10), ENSURE_REQUIREMENTS, [plan_id=489404]
(52) Sort
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(53) Window
Input [9]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: [collect_set(COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [1 DESC NULLS LAST]
(54) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, ARRAY_TO_STR_BEFORE_CONCAT(COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975) AS _w0#795432]
Input [10]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378]
(55) Window
Input [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, _w0#795432]
Arguments: [concatwithseparatorudaf(_w0#795432, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@72f4f322, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [1 DESC NULLS LAST]
(56) Project
Output [11]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [12]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, _w0#795432, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431]
(57) Filter
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
Condition : (((isnotnull(COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686) AND (A = COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686)) AND (COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691 <=> 011040518)) AND isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691))
(58) Project
Output [6]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687 AS 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691 AS 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723 AS 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724 AS 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727 AS 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728 AS 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Input [7]: [COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#794686, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#794687, COL_F76265AB_8748_4114_92B4_00E37DE25D34#794691, COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#794723, COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#794724, COL_95383EBC_3648_4E94_9C53_D311092BF5F4#794727, COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#794728]
(59) Exchange
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: hashpartitioning(02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 10), ENSURE_REQUIREMENTS, [plan_id=489412]
(60) Sort
Input [6]: [02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
Arguments: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586 ASC NULLS FIRST], false, 0
(61) SortMergeJoin
Left keys [1]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972]
Right keys [1]: [02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586]
Join type: Inner
Join condition: None
(62) Project
Output [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582 AS COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618 AS COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619 AS COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622 AS COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623 AS COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Input [17]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, 02_A_ELIGIBLE_210376_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#795582, 02_A_ELIGIBLE_210376_COL_F76265AB_8748_4114_92B4_00E37DE25D34#795586, 02_A_ELIGIBLE_210376_COL_D7508510_B4D7_44C5_A063_A2132B6EF08A#795618, 02_A_ELIGIBLE_210376_COL_EAA75683_8CB4_4075_AA4A_FACAF98EBD6E#795619, 02_A_ELIGIBLE_210376_COL_95383EBC_3648_4E94_9C53_D311092BF5F4#795622, 02_A_ELIGIBLE_210376_COL_7DC2A78A_5ED5_4908_AC94_0885B83B98CD#795623]
(63) Sort
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Arguments: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972 ASC NULLS FIRST, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST], false, 0
(64) Window
Input [16]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816]
Arguments: [collect_set(COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, 0, 0) windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, row_number() windowspecdefinition(COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910], [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972], [COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816 DESC NULLS LAST]
(65) Filter
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910]
Condition : (COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910 <=> 1)
(66) Project
Output [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, array_except(COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, array_except(COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040]
Input [18]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910]
(67) Project
Output [21]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040, str_join(array(str_join(array(SSN/SSF Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020)), : ), str_join(array(SSN/SSF dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853)), : )), - ) AS COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#796099, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Input [20]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040]
(68) CollectLimit
Input [21]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#796099, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: 1500
(69) AdaptiveSparkPlan
Output [21]: [COL_568DEDCB_F936_41B1_A0EC_986E8205D003#794972, COL_6B7A5180_4786_45B2_A22D_A3D20F9D0324#794973, COL_06C34AF4_5684_463F_907D_CDFD03718F51#795813, COL_75DE18B4_60A3_4F3A_84A5_68C9482F7321#795814, COL_2F1A6F60_882E_44EE_A93A_AED2110E2882#795910, COL_B266CE22_DAB8_4279_97A9_41F673AAB9EA#795812, COL_1BD1CF4D_D1E1_4C54_94F8_0754D4126CAC#794974, COL_C884EBCF_BFE3_4AC5_ACBE_F539AA12A176#794975, COL_4CC6454E_410C_4674_8B74_8D8769623AB2#795378, COL_9CC2FBBF_3122_4F31_8810_538C893D43F9#795431, COL_99C810C3_1B6A_4CB3_9742_B16D88709270#795815, COL_D566CC23_E2D6_4115_8A37_046E955BBD91#795816, COL_E80069D0_DB71_4C89_8CA9_A572562CD848#794976, COL_241A1273_DFBA_428E_B5AC_0BA3DD53F132#795853, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#796020, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#796040, COL_3C26E010_526E_4909_95DF_3CC7AD9E43A2#796099, COL_7453C4CB_1AAF_4D1F_A079_968F5F790238#794977, COL_DE32084C_B740_4DEB_BF88_5FFF43FAFE99#795186, COL_B2D8469D_E32C_4A51_BA8A_9172B340952C#795218, COL_37A86F83_3F41_4A03_B120_C509CC9A6C8A#794978]
Arguments: isFinalPlan=true