== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Project (14)
+- Union (13)
:- Project (7)
: +- Project (6)
: +- Project (5)
: +- Project (4)
: +- LogicalRelation (3)
+- Project (12)
+- Project (11)
+- Project (10)
+- Project (9)
+- LogicalRelation (8)
(1) Execute CreateViewCommand
Output: []
(2) CreateViewCommand
Arguments: `ZZ_CONTROLE_LIE_43843791`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "lien", "type_lien", "nb_lignes_renseignees", "nb_lignes_orphelines", "nb_valeurs_orphelines", "pct_orphelins", "date_controle" FROM "xplore"."zz_controle_liens") as x) [numPartitions=1], [lien#310156, type_lien#310157, nb_lignes_renseignees#310158L, nb_lignes_orphelines#310159L, nb_valeurs_orphelines#310160L, pct_orphelins#310161, date_controle#310162], false
(4) Project
Arguments: [lien#310156 AS COLL0#310170, type_lien#310157 AS COLL1#310171, nb_lignes_renseignees#310158L AS COLL2#310172L, nb_lignes_orphelines#310159L AS COLL3#310173L, nb_valeurs_orphelines#310160L AS COLL4#310174L, pct_orphelins#310161 AS COLL5#310175, date_controle#310162 AS COLL6#310176]
(5) Project
Arguments: [COLL0#310170 AS COLL0#310184, COLL1#310171 AS COLL1#310185, COLL2#310172L AS COLL2#310186L, COLL3#310173L AS COLL3#310187L, COLL4#310174L AS COLL4#310188L, COLL5#310175 AS COLL5#310189, COLL6#310176 AS COLL6#310190]
(6) Project
Arguments: [COLL0#310184, COLL1#310185, COLL2#310186L, COLL3#310187L, COLL4#310188L, COLL5#310189, COLL6#310190]
(7) Project
Arguments: [COLL6#310190 AS DATE_CONTROLE_438444#310205, COLL0#310184 AS LIEN_438438#310206, cast(COLL3#310187L as int) AS NB_LIGNES_ORPHE_438441#310207, cast(COLL2#310186L as int) AS NB_LIGNES_RENSE_438440#310208, cast(COLL4#310188L as int) AS NB_VALEURS_ORPH_438442#310209, cast(str_create(cast(Cab_A as string)) as string) AS ORIGINE_440157#310213, cast(COLL5#310189 as int) AS PCT_ORPHELINS_438443#310211, COLL1#310185 AS TYPE_LIEN_438439#310212]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "lien", "type_lien", "nb_lignes_renseignees", "nb_lignes_orphelines", "nb_valeurs_orphelines", "pct_orphelins", "date_controle" FROM "xplore2"."zz_controle_liens") as x) [numPartitions=1], [lien#310222, type_lien#310223, nb_lignes_renseignees#310224L, nb_lignes_orphelines#310225L, nb_valeurs_orphelines#310226L, pct_orphelins#310227, date_controle#310228], false
(9) Project
Arguments: [lien#310222 AS COLL0#310236, type_lien#310223 AS COLL1#310237, nb_lignes_renseignees#310224L AS COLL2#310238L, nb_lignes_orphelines#310225L AS COLL3#310239L, nb_valeurs_orphelines#310226L AS COLL4#310240L, pct_orphelins#310227 AS COLL5#310241, date_controle#310228 AS COLL6#310242]
(10) Project
Arguments: [COLL0#310236 AS COLL0#310250, COLL1#310237 AS COLL1#310251, COLL2#310238L AS COLL2#310252L, COLL3#310239L AS COLL3#310253L, COLL4#310240L AS COLL4#310254L, COLL5#310241 AS COLL5#310255, COLL6#310242 AS COLL6#310256]
(11) Project
Arguments: [COLL0#310250, COLL1#310251, COLL2#310252L, COLL3#310253L, COLL4#310254L, COLL5#310255, COLL6#310256]
(12) Project
Arguments: [COLL6#310256 AS DATE_CONTROLE_438444#310271, COLL0#310250 AS LIEN_438438#310272, cast(COLL3#310253L as int) AS NB_LIGNES_ORPHE_438441#310273, cast(COLL2#310252L as int) AS NB_LIGNES_RENSE_438440#310274, cast(COLL4#310254L as int) AS NB_VALEURS_ORPH_438442#310275, cast(str_create(cast(Cab_B as string)) as string) AS ORIGINE_440157#310279, cast(COLL5#310255 as int) AS PCT_ORPHELINS_438443#310277, COLL1#310251 AS TYPE_LIEN_438439#310278]
(13) Union
Arguments: false, false
(14) Project
Arguments: [DATE_CONTROLE_438444#310205, LIEN_438438#310206, NB_LIGNES_ORPHE_438441#310207, NB_LIGNES_RENSE_438440#310208, NB_VALEURS_ORPH_438442#310209, ORIGINE_440157#310213, PCT_ORPHELINS_438443#310211, TYPE_LIEN_438439#310212]