== 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#46084, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#46085, COL_E631054E_686B_4907_A404_653F7ADC1F83#46086, COL_4918BC29_3253_443D_B454_0165E3F8531A#46087, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#46088, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#46089, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#46090, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#46091, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#46092]
Arguments: <empty>, [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#46084, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#46085, COL_E631054E_686B_4907_A404_653F7ADC1F83#46086, COL_4918BC29_3253_443D_B454_0165E3F8531A#46087, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#46088, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#46089, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#46090, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#46091, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#46092]
(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#45878, code_uo#45879, usager_id#45880, code_prestation#45881, date#45882, quantite_nuit#45883]
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#45878 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974, code_uo#45879 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975, usager_id#45880 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976, code_prestation#45881 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, cast(date#45882 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978, cast(REFORMAT_FOR_DOUBLE(quantite_nuit#45883) as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979]
Input [6]: [id_ligne#45878, code_uo#45879, usager_id#45880, code_prestation#45881, date#45882, quantite_nuit#45883]
(4) LocalLimit [codegen id : 1]
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976, COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979]
Arguments: 500000
(5) Exchange
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976, COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979]
Arguments: hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, 10), ENSURE_REQUIREMENTS, [plan_id=9021]
(6) Sort
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976, COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979]
Arguments: [COL_BEE328D2_279D_490C_A8A7_45465541A509#45977 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#45841, code_prestation#45838, libelle#45840, niveau#45839]
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#45841 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#45990, code_prestation#45838 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991, libelle#45840 AS NOMENCLATURE_PR_424747_LIBELLE_424750#45992, niveau#45839 AS NOMENCLATURE_PR_424747_NIVEAU_424749#45993]
Input [4]: [code_parent#45841, code_prestation#45838, libelle#45840, niveau#45839]
(9) Exchange
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#45990, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991, NOMENCLATURE_PR_424747_LIBELLE_424750#45992, NOMENCLATURE_PR_424747_NIVEAU_424749#45993]
Arguments: hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991, 10), ENSURE_REQUIREMENTS, [plan_id=9022]
(10) Sort
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#45990, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991, NOMENCLATURE_PR_424747_LIBELLE_424750#45992, NOMENCLATURE_PR_424747_NIVEAU_424749#45993]
Arguments: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991 ASC NULLS FIRST], false, 0
(11) SortMergeJoin
Left keys [1]: [COL_BEE328D2_279D_490C_A8A7_45465541A509#45977]
Right keys [1]: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991]
Join type: LeftOuter
Join condition: None
(12) Project
Output [9]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#46084, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#46085, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#46086, COL_BEE328D2_279D_490C_A8A7_45465541A509#45977 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#46087, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#46088, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#46089, NOMENCLATURE_PR_424747_NIVEAU_424749#45993 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#46090, NOMENCLATURE_PR_424747_LIBELLE_424750#45992 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#46091, NOMENCLATURE_PR_424747_CODE_PARENT_424751#45990 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#46092]
Input [10]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#45974, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#45975, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#45976, COL_BEE328D2_279D_490C_A8A7_45465541A509#45977, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#45978, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#45979, NOMENCLATURE_PR_424747_CODE_PARENT_424751#45990, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#45991, NOMENCLATURE_PR_424747_LIBELLE_424750#45992, NOMENCLATURE_PR_424747_NIVEAU_424749#45993]
(13) CollectLimit
Input [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#46084, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#46085, COL_E631054E_686B_4907_A404_653F7ADC1F83#46086, COL_4918BC29_3253_443D_B454_0165E3F8531A#46087, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#46088, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#46089, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#46090, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#46091, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#46092]
Arguments: 500000
(14) AdaptiveSparkPlan
Output [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#46084, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#46085, COL_E631054E_686B_4907_A404_653F7ADC1F83#46086, COL_4918BC29_3253_443D_B454_0165E3F8531A#46087, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#46088, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#46089, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#46090, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#46091, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#46092]
Arguments: isFinalPlan=true