== Physical Plan ==
Execute CreateViewCommand (1)
+- CreateViewCommand (2)
+- Aggregate (18)
+- Project (17)
+- SubqueryAlias (16)
+- View (15)
+- 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: `H_CODPOS_43722689`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore"."h_codpos") as x) [numPartitions=1], [cp_codpos#322195, cp_burdis#322196, cp_codpays#322197, cp_coduti#322198, cp_datmaj#322199, cp_codinsee#322200], false
(4) Project
Arguments: [cp_codpos#322195 AS COLL0#322207, cp_burdis#322196 AS COLL1#322208, cp_codpays#322197 AS COLL2#322209, cp_coduti#322198 AS COLL3#322210, cp_datmaj#322199 AS COLL4#322211, cp_codinsee#322200 AS COLL5#322212]
(5) Project
Arguments: [COLL0#322207 AS COLL0#322219, COLL1#322208 AS COLL1#322220, COLL2#322209 AS COLL2#322221, COLL3#322210 AS COLL3#322222, COLL4#322211 AS COLL4#322223, COLL5#322212 AS COLL5#322224]
(6) Project
Arguments: [COLL0#322219, COLL1#322220, COLL2#322221, COLL3#322222, COLL4#322223, COLL5#322224]
(7) Project
Arguments: [COLL1#322220 AS CP_BURDIS_437228#322237, COLL5#322224 AS CP_CODINSEE_437232#322238, COLL2#322221 AS CP_CODPAYS_437229#322239, COLL0#322219 AS CP_CODPOS_437227#322240, COLL3#322222 AS CP_CODUTI_437230#322241, COLL4#322223 AS CP_DATMAJ_437231#322242, cast(null as string) AS ORIGINE_440138#322243]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "cp_codpos", "cp_burdis", "cp_codpays", "cp_coduti", "cp_datmaj", "cp_codinsee" FROM "xplore2"."h_codpos") as x) [numPartitions=1], [cp_codpos#322251, cp_burdis#322252, cp_codpays#322253, cp_coduti#322254, cp_datmaj#322255, cp_codinsee#322256], false
(9) Project
Arguments: [cp_codpos#322251 AS COLL0#322263, cp_burdis#322252 AS COLL1#322264, cp_codpays#322253 AS COLL2#322265, cp_coduti#322254 AS COLL3#322266, cp_datmaj#322255 AS COLL4#322267, cp_codinsee#322256 AS COLL5#322268]
(10) Project
Arguments: [COLL0#322263 AS COLL0#322275, COLL1#322264 AS COLL1#322276, COLL2#322265 AS COLL2#322277, COLL3#322266 AS COLL3#322278, COLL4#322267 AS COLL4#322279, COLL5#322268 AS COLL5#322280]
(11) Project
Arguments: [COLL0#322275, COLL1#322276, COLL2#322277, COLL3#322278, COLL4#322279, COLL5#322280]
(12) Project
Arguments: [COLL1#322276 AS CP_BURDIS_437228#322293, COLL5#322280 AS CP_CODINSEE_437232#322294, COLL2#322277 AS CP_CODPAYS_437229#322295, COLL0#322275 AS CP_CODPOS_437227#322296, COLL3#322278 AS CP_CODUTI_437230#322297, COLL4#322279 AS CP_DATMAJ_437231#322298, cast(null as string) AS ORIGINE_440138#322299]
(13) Union
Arguments: false, false
(14) Project
Arguments: [CP_BURDIS_437228#322237, CP_CODINSEE_437232#322238, CP_CODPAYS_437229#322239, CP_CODPOS_437227#322240, CP_CODUTI_437230#322241, CP_DATMAJ_437231#322242, ORIGINE_440138#322243]
(15) View
Arguments: `7CCD06AE_AA61_4783_8B9F_CD30A24C24C4`, true
(16) SubqueryAlias
Arguments: 7CCD06AE_AA61_4783_8B9F_CD30A24C24C4
(17) Project
Arguments: [CP_BURDIS_437228#322237, CP_CODINSEE_437232#322238, CP_CODPAYS_437229#322239, CP_CODPOS_437227#322240, CP_CODUTI_437230#322241, CP_DATMAJ_437231#322242, ORIGINE_440138#322243]
(18) Aggregate
Arguments: [CP_BURDIS_437228#322237, CP_CODINSEE_437232#322238, CP_CODPAYS_437229#322239, CP_CODPOS_437227#322240, CP_CODUTI_437230#322241, CP_DATMAJ_437231#322242, ORIGINE_440138#322243], [CP_BURDIS_437228#322237, CP_CODINSEE_437232#322238, CP_CODPAYS_437229#322239, CP_CODPOS_437227#322240, CP_CODUTI_437230#322241, CP_DATMAJ_437231#322242, ORIGINE_440138#322243]