== Physical Plan ==
AdaptiveSparkPlan (14)
+- == Final Plan ==
LocalTableScan (1)
+- == Initial Plan ==
CollectLimit (13)
+- Project (12)
+- SortMergeJoin LeftOuter (11)
:- Sort (6)
: +- Exchange (5)
: +- LocalLimit (4)
: +- Project (3)
: +- Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] (2)
+- Sort (10)
+- Exchange (9)
+- Project (8)
+- Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] (7)
(1) LocalTableScan
Output [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#55129, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#55130, COL_E631054E_686B_4907_A404_653F7ADC1F83#55131, COL_4918BC29_3253_443D_B454_0165E3F8531A#55132, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#55133, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#55134, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#55135, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#55136, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#55137]
Arguments: <empty>, [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#55129, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#55130, COL_E631054E_686B_4907_A404_653F7ADC1F83#55131, COL_4918BC29_3253_443D_B454_0165E3F8531A#55132, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#55133, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#55134, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#55135, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#55136, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#55137]
(2) Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] [codegen id : 1]
Output [6]: [id_ligne#54923, code_uo#54924, usager_id#54925, code_prestation#54926, date#54927, quantite_nuit#54928]
PushedFilters: [*EqualNullSafe(usager_id,U007)]
ReadSchema: struct<id_ligne:int,code_uo:string,usager_id:string,code_prestation:string,date:date,quantite_nuit:float>
(3) Project [codegen id : 1]
Output [6]: [id_ligne#54923 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019, code_uo#54924 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020, usager_id#54925 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021, code_prestation#54926 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, cast(date#54927 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023, cast(REFORMAT_FOR_DOUBLE(quantite_nuit#54928) as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024]
Input [6]: [id_ligne#54923, code_uo#54924, usager_id#54925, code_prestation#54926, date#54927, quantite_nuit#54928]
(4) LocalLimit [codegen id : 1]
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021, COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024]
Arguments: 500000
(5) Exchange
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021, COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024]
Arguments: hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, 10), ENSURE_REQUIREMENTS, [plan_id=10234]
(6) Sort
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021, COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024]
Arguments: [COL_BEE328D2_279D_490C_A8A7_45465541A509#55022 ASC NULLS FIRST], false, 0
(7) Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] [codegen id : 2]
Output [4]: [code_parent#54886, code_prestation#54883, libelle#54885, niveau#54884]
PushedFilters: [*IsNotNull(code_prestation)]
ReadSchema: struct<code_parent:string,code_prestation:string,libelle:string,niveau:int>
(8) Project [codegen id : 2]
Output [4]: [code_parent#54886 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#55035, code_prestation#54883 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036, libelle#54885 AS NOMENCLATURE_PR_424747_LIBELLE_424750#55037, niveau#54884 AS NOMENCLATURE_PR_424747_NIVEAU_424749#55038]
Input [4]: [code_parent#54886, code_prestation#54883, libelle#54885, niveau#54884]
(9) Exchange
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#55035, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036, NOMENCLATURE_PR_424747_LIBELLE_424750#55037, NOMENCLATURE_PR_424747_NIVEAU_424749#55038]
Arguments: hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036, 10), ENSURE_REQUIREMENTS, [plan_id=10235]
(10) Sort
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#55035, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036, NOMENCLATURE_PR_424747_LIBELLE_424750#55037, NOMENCLATURE_PR_424747_NIVEAU_424749#55038]
Arguments: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036 ASC NULLS FIRST], false, 0
(11) SortMergeJoin
Left keys [1]: [COL_BEE328D2_279D_490C_A8A7_45465541A509#55022]
Right keys [1]: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036]
Join type: LeftOuter
Join condition: None
(12) Project
Output [9]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#55129, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#55130, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#55131, COL_BEE328D2_279D_490C_A8A7_45465541A509#55022 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#55132, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#55133, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#55134, NOMENCLATURE_PR_424747_NIVEAU_424749#55038 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#55135, NOMENCLATURE_PR_424747_LIBELLE_424750#55037 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#55136, NOMENCLATURE_PR_424747_CODE_PARENT_424751#55035 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#55137]
Input [10]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#55019, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#55020, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#55021, COL_BEE328D2_279D_490C_A8A7_45465541A509#55022, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#55023, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#55024, NOMENCLATURE_PR_424747_CODE_PARENT_424751#55035, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#55036, NOMENCLATURE_PR_424747_LIBELLE_424750#55037, NOMENCLATURE_PR_424747_NIVEAU_424749#55038]
(13) CollectLimit
Input [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#55129, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#55130, COL_E631054E_686B_4907_A404_653F7ADC1F83#55131, COL_4918BC29_3253_443D_B454_0165E3F8531A#55132, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#55133, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#55134, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#55135, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#55136, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#55137]
Arguments: 500000
(14) AdaptiveSparkPlan
Output [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#55129, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#55130, COL_E631054E_686B_4907_A404_653F7ADC1F83#55131, COL_4918BC29_3253_443D_B454_0165E3F8531A#55132, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#55133, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#55134, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#55135, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#55136, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#55137]
Arguments: isFinalPlan=true