== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (25)
+- Project (24)
+- Join (23)
:- Project (13)
: +- Project (12)
: +- Project (11)
: +- SubqueryAlias (10)
: +- View (9)
: +- Project (8)
: +- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (22)
+- SubqueryAlias (21)
+- View (20)
+- Project (19)
+- Project (18)
+- Project (17)
+- Project (16)
+- Project (15)
+- LogicalRelation (14)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `NUITEES_UO_424955172`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1], [id_ligne#834604, code_uo#834605, usager_id#834606, code_prestation#834607, date#834608, quantite_nuit#834609], false
(4) Project
Arguments: [id_ligne#834604 AS COLL0#834616, code_uo#834605 AS COLL1#834617, usager_id#834606 AS COLL2#834618, code_prestation#834607 AS COLL3#834619, date#834608 AS COLL4#834620, quantite_nuit#834609 AS COLL5#834621]
(5) Project
Arguments: [COLL0#834616 AS COLL0#834628, COLL1#834617 AS COLL1#834629, COLL2#834618 AS COLL2#834630, COLL3#834619 AS COLL3#834631, COLL4#834620 AS COLL4#834632, COLL5#834621 AS COLL5#834633]
(6) Project
Arguments: [COLL0#834628, COLL1#834629, COLL2#834630, COLL3#834631, COLL4#834632, COLL5#834633]
(7) Project
Arguments: [COLL3#834631 AS CODE_PRESTATION_424829#834646, COLL1#834629 AS CODE_UO_424827#834647, cast(COLL4#834632 as timestamp) AS DATE_424830#834648, COLL0#834628 AS ID_LIGNE_424826#834649, cast(REFORMAT_FOR_DOUBLE(COLL5#834633) as double) AS QUANTITE_NUIT_424831#834650, COLL2#834630 AS USAGER_ID_424828#834651]
(8) Project
Arguments: [CODE_PRESTATION_424829#834646, CODE_UO_424827#834647, DATE_424830#834648, ID_LIGNE_424826#834649, QUANTITE_NUIT_424831#834650, USAGER_ID_424828#834651]
(9) View
Arguments: `UO_NUIT_424825172`, true
(10) SubqueryAlias
Arguments: UO_NUIT_424825172
(11) Project
Arguments: [CODE_PRESTATION_424829#834646 AS UO_NUIT_424825_CODE_PRESTATION_424829#834670, CODE_UO_424827#834647 AS UO_NUIT_424825_CODE_UO_424827#834671, DATE_424830#834648 AS UO_NUIT_424825_DATE_424830#834672, ID_LIGNE_424826#834649 AS UO_NUIT_424825_ID_LIGNE_424826#834673, QUANTITE_NUIT_424831#834650 AS UO_NUIT_424825_QUANTITE_NUIT_424831#834674, USAGER_ID_424828#834651 AS UO_NUIT_424825_USAGER_ID_424828#834675]
(12) Project
Arguments: [cast(UO_NUIT_424825_ID_LIGNE_424826#834673 as int) AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834688, cast(UO_NUIT_424825_CODE_UO_424827#834671 as string) AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834689, cast(UO_NUIT_424825_USAGER_ID_424828#834675 as string) AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834690, cast(UO_NUIT_424825_CODE_PRESTATION_424829#834670 as string) AS COL_BEE328D2_279D_490C_A8A7_45465541A509#834691, cast(UO_NUIT_424825_DATE_424830#834672 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834692, cast(UO_NUIT_424825_QUANTITE_NUIT_424831#834674 as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834693]
(13) Project
Arguments: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834688 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834689 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834690 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834691 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834692 AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834693 AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
(14) LogicalRelation
Arguments: JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1], [code_prestation#834544, niveau#834545, libelle#834546, code_parent#834547], false
(15) Project
Arguments: [code_prestation#834544 AS COLL0#834552, niveau#834545 AS COLL1#834553, libelle#834546 AS COLL2#834554, code_parent#834547 AS COLL3#834555]
(16) Project
Arguments: [COLL0#834552 AS COLL0#834560, COLL1#834553 AS COLL1#834561, COLL2#834554 AS COLL2#834562, COLL3#834555 AS COLL3#834563]
(17) Project
Arguments: [COLL0#834560, COLL1#834561, COLL2#834562, COLL3#834563]
(18) Project
Arguments: [COLL3#834563 AS CODE_PARENT_424751#834572, COLL0#834560 AS CODE_PRESTATION_424748#834573, COLL2#834562 AS LIBELLE_424750#834574, COLL1#834561 AS NIVEAU_424749#834575]
(19) Project
Arguments: [CODE_PARENT_424751#834572, CODE_PRESTATION_424748#834573, LIBELLE_424750#834574, NIVEAU_424749#834575]
(20) View
Arguments: `NOMENCLATURE_PR_424747172`, true
(21) SubqueryAlias
Arguments: NOMENCLATURE_PR_424747172
(22) Project
Arguments: [CODE_PARENT_424751#834572 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, CODE_PRESTATION_424748#834573 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, LIBELLE_424750#834574 AS NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NIVEAU_424749#834575 AS NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
(23) Join
Arguments: LeftOuter, (COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 = NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717)
(24) Project
Arguments: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705, NOMENCLATURE_PR_424747_NIVEAU_424749#834719 AS COL_93D22DA0_0855_4B4E_BFD6_C6B623AFA32B#834744, NOMENCLATURE_PR_424747_LIBELLE_424750#834718 AS COL_1B09A02C_0391_4ACF_9593_6E4595BD66AC#834745, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716 AS COL_8F9DE718_F3F8_4F46_B4BF_FFC6DE00D14D#834746]
(25) Project
Arguments: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834756, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834757, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834758, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#834759, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704 AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834760, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705 AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834761, COL_93D22DA0_0855_4B4E_BFD6_C6B623AFA32B#834744 AS COL_93D22DA0_0855_4B4E_BFD6_C6B623AFA32B#834762, COL_1B09A02C_0391_4ACF_9593_6E4595BD66AC#834745 AS COL_1B09A02C_0391_4ACF_9593_6E4595BD66AC#834763, COL_8F9DE718_F3F8_4F46_B4BF_FFC6DE00D14D#834746 AS COL_8F9DE718_F3F8_4F46_B4BF_FFC6DE00D14D#834764]