== Physical Plan ==
AdaptiveSparkPlan (15)
+- == Final Plan ==
LocalTableScan (1)
+- == Initial Plan ==
TakeOrderedAndProject (14)
+- Project (13)
+- SortMergeJoin Inner (12)
:- Sort (6)
: +- Exchange (5)
: +- Project (4)
: +- Filter (3)
: +- Scan parquet (2)
+- Sort (11)
+- Exchange (10)
+- Project (9)
+- Filter (8)
+- Scan parquet (7)
(1) LocalTableScan
Output [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Arguments: <empty>, [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
(2) Scan parquet
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1390061, COL_DE173389_FC77_42AB_B565_A267156FF638#1390062, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#1390063, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#1390064, COL_57A29A37_9A17_4B66_8075_897F4B240E81#1390065, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#1390066, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#1390067, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1390068, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#1390069, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#1390070, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1390071, COL_7283FB96_45C4_411A_901D_417BCF15E684#1390072, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1390073, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#1390074, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#1390075, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1390076]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_D_DETERMINAT_204986]
PushedFilters: [EqualNullSafe(COL_FC10C112_88B1_45B9_AA4E_B279540F2D09,Eligible), IsNotNull(COL_788D4A66_31DF_4E0F_911A_8BD9F9464719)]
ReadSchema: struct<COL_016E6242_B446_46F7_97DC_5F775D66196E:string,COL_DE173389_FC77_42AB_B565_A267156FF638:string,COL_788D4A66_31DF_4E0F_911A_8BD9F9464719:string,COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1:int,COL_57A29A37_9A17_4B66_8075_897F4B240E81:string,COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA:string,COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE:string,COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C:string,COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25:string,COL_C0BCA214_8699_42D8_AB9C_67933DE649E9:string,COL_FC10C112_88B1_45B9_AA4E_B279540F2D09:string,COL_7283FB96_45C4_411A_901D_417BCF15E684:string,COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25:string,COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF:string,COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE:string,COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908:string>
(3) Filter
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1390061, COL_DE173389_FC77_42AB_B565_A267156FF638#1390062, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#1390063, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#1390064, COL_57A29A37_9A17_4B66_8075_897F4B240E81#1390065, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#1390066, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#1390067, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1390068, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#1390069, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#1390070, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1390071, COL_7283FB96_45C4_411A_901D_417BCF15E684#1390072, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1390073, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#1390074, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#1390075, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1390076]
Condition : ((COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1390071 <=> Eligible) AND isnotnull(COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#1390063))
(4) Project
Output [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1390061 AS COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_DE173389_FC77_42AB_B565_A267156FF638#1390062 AS COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#1390063 AS COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#1390064 AS COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_57A29A37_9A17_4B66_8075_897F4B240E81#1390065 AS COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#1390066 AS COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_7283FB96_45C4_411A_901D_417BCF15E684#1390072 AS COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1390073 AS COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#1390067 AS COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1390068 AS COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#1390069 AS COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#1390070 AS COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1390071 AS COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#1390074 AS COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#1390075 AS COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1390076 AS COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Input [16]: [COL_016E6242_B446_46F7_97DC_5F775D66196E#1390061, COL_DE173389_FC77_42AB_B565_A267156FF638#1390062, COL_788D4A66_31DF_4E0F_911A_8BD9F9464719#1390063, COL_C2CEE206_E588_4A2C_B2B5_C7AD2EA3DDF1#1390064, COL_57A29A37_9A17_4B66_8075_897F4B240E81#1390065, COL_7F1C4BC4_EB95_40BE_BDBB_B5F7706757CA#1390066, COL_27D851AF_C83A_474B_A7CF_D66FAADB50EE#1390067, COL_AF155DAB_420D_45B6_A9A9_56AA8D2E3D5C#1390068, COL_5C1C2325_6DF2_4B88_BCC6_78BECE76AD25#1390069, COL_C0BCA214_8699_42D8_AB9C_67933DE649E9#1390070, COL_FC10C112_88B1_45B9_AA4E_B279540F2D09#1390071, COL_7283FB96_45C4_411A_901D_417BCF15E684#1390072, COL_D0D2A969_5962_4BD8_9DAA_FA2A1236DF25#1390073, COL_D5C5BAB5_C1EE_413F_91CE_34E4418166FF#1390074, COL_9A5C53EE_83DB_41F0_A31B_B32A5F144FAE#1390075, COL_F05A55CE_AA70_477D_B5B1_B1F39C0FF908#1390076]
(5) Exchange
Input [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Arguments: hashpartitioning(COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, 10), ENSURE_REQUIREMENTS, [plan_id=718668]
(6) Sort
Input [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Arguments: [COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206 ASC NULLS FIRST], false, 0
(7) Scan parquet
Output [1]: [Finess#1390010]
Batched: true
Location: InMemoryFileIndex [file:/data/input/depot/excel/cache/09_INFORMATION__204529_26897fa913503b7c2ff6c2e0bd71df5c/Info_Etab_init_v1.1 CHSF.xlsx_41dc788345dd715eba9a9d7feff1aa68]
PushedFilters: [IsNotNull(Finess)]
ReadSchema: struct<Finess:string>
(8) Filter
Input [1]: [Finess#1390010]
Condition : isnotnull(Finess#1390010)
(9) Project
Output [1]: [Finess#1390010 AS 09_INFORMATION__204665_FINESS_204667#1390240]
Input [1]: [Finess#1390010]
(10) Exchange
Input [1]: [09_INFORMATION__204665_FINESS_204667#1390240]
Arguments: hashpartitioning(09_INFORMATION__204665_FINESS_204667#1390240, 10), ENSURE_REQUIREMENTS, [plan_id=718669]
(11) Sort
Input [1]: [09_INFORMATION__204665_FINESS_204667#1390240]
Arguments: [09_INFORMATION__204665_FINESS_204667#1390240 ASC NULLS FIRST], false, 0
(12) SortMergeJoin
Left keys [1]: [COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206]
Right keys [1]: [09_INFORMATION__204665_FINESS_204667#1390240]
Join type: Inner
Join condition: None
(13) Project
Output [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Input [17]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219, 09_INFORMATION__204665_FINESS_204667#1390240]
(14) TakeOrderedAndProject
Input [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Arguments: 1500, [COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207 ASC NULLS FIRST], [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
(15) AdaptiveSparkPlan
Output [16]: [COL_4ECA949F_2DA4_41C5_80E1_520DEFC8D1EA#1390204, COL_D14F6518_D1F3_4F18_93EC_DEF8E6712184#1390205, COL_F522EF71_EF5D_46C0_B0EC_B3EB638B97F7#1390206, COL_CEFA2472_1E3F_469C_9633_864540C40AD9#1390207, COL_1DDA21A4_0127_416B_A5DB_7EDD9CC61B56#1390208, COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#1390209, COL_0521CAB9_7617_4F31_948E_95DCA16387D7#1390210, COL_1DACB81E_AFA5_4BB8_83D7_57DE8B8062B7#1390211, COL_9262BBED_C393_416D_B38C_8F1458965BA7#1390212, COL_F76265AB_8748_4114_92B4_00E37DE25D34#1390213, COL_96E2282E_0771_460E_8BDB_D11261BD9020#1390214, COL_12028397_66B1_4E3C_BBDB_64537606E7DE#1390215, COL_2C09E3B7_4086_45D3_8676_F1D58494C2DD#1390216, COL_4473F770_A575_4100_97F6_8190F900749A#1390217, COL_715B3479_EAD2_422C_BF5C_7B020197D946#1390218, COL_383EDE50_7CF9_4E24_A70F_BA7CD5C9D6BA#1390219]
Arguments: isFinalPlan=true