== 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#48588, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#48589, COL_E631054E_686B_4907_A404_653F7ADC1F83#48590, COL_4918BC29_3253_443D_B454_0165E3F8531A#48591, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#48592, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#48593, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#48594, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#48595, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#48596]
Arguments: <empty>, [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#48588, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#48589, COL_E631054E_686B_4907_A404_653F7ADC1F83#48590, COL_4918BC29_3253_443D_B454_0165E3F8531A#48591, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#48592, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#48593, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#48594, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#48595, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#48596]
(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#48382, code_uo#48383, usager_id#48384, code_prestation#48385, date#48386, quantite_nuit#48387]
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#48382 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478, code_uo#48383 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479, usager_id#48384 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480, code_prestation#48385 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, cast(date#48386 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482, cast(REFORMAT_FOR_DOUBLE(quantite_nuit#48387) as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483]
Input [6]: [id_ligne#48382, code_uo#48383, usager_id#48384, code_prestation#48385, date#48386, quantite_nuit#48387]
(4) LocalLimit [codegen id : 1]
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480, COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483]
Arguments: 500000
(5) Exchange
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480, COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483]
Arguments: hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, 10), ENSURE_REQUIREMENTS, [plan_id=9541]
(6) Sort
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480, COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483]
Arguments: [COL_BEE328D2_279D_490C_A8A7_45465541A509#48481 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#48345, code_prestation#48342, libelle#48344, niveau#48343]
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#48345 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#48494, code_prestation#48342 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495, libelle#48344 AS NOMENCLATURE_PR_424747_LIBELLE_424750#48496, niveau#48343 AS NOMENCLATURE_PR_424747_NIVEAU_424749#48497]
Input [4]: [code_parent#48345, code_prestation#48342, libelle#48344, niveau#48343]
(9) Exchange
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#48494, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495, NOMENCLATURE_PR_424747_LIBELLE_424750#48496, NOMENCLATURE_PR_424747_NIVEAU_424749#48497]
Arguments: hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495, 10), ENSURE_REQUIREMENTS, [plan_id=9542]
(10) Sort
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#48494, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495, NOMENCLATURE_PR_424747_LIBELLE_424750#48496, NOMENCLATURE_PR_424747_NIVEAU_424749#48497]
Arguments: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495 ASC NULLS FIRST], false, 0
(11) SortMergeJoin
Left keys [1]: [COL_BEE328D2_279D_490C_A8A7_45465541A509#48481]
Right keys [1]: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495]
Join type: LeftOuter
Join condition: None
(12) Project
Output [9]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#48588, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#48589, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#48590, COL_BEE328D2_279D_490C_A8A7_45465541A509#48481 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#48591, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#48592, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#48593, NOMENCLATURE_PR_424747_NIVEAU_424749#48497 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#48594, NOMENCLATURE_PR_424747_LIBELLE_424750#48496 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#48595, NOMENCLATURE_PR_424747_CODE_PARENT_424751#48494 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#48596]
Input [10]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#48478, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#48479, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#48480, COL_BEE328D2_279D_490C_A8A7_45465541A509#48481, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#48482, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#48483, NOMENCLATURE_PR_424747_CODE_PARENT_424751#48494, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#48495, NOMENCLATURE_PR_424747_LIBELLE_424750#48496, NOMENCLATURE_PR_424747_NIVEAU_424749#48497]
(13) CollectLimit
Input [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#48588, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#48589, COL_E631054E_686B_4907_A404_653F7ADC1F83#48590, COL_4918BC29_3253_443D_B454_0165E3F8531A#48591, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#48592, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#48593, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#48594, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#48595, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#48596]
Arguments: 500000
(14) AdaptiveSparkPlan
Output [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#48588, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#48589, COL_E631054E_686B_4907_A404_653F7ADC1F83#48590, COL_4918BC29_3253_443D_B454_0165E3F8531A#48591, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#48592, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#48593, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#48594, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#48595, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#48596]
Arguments: isFinalPlan=true