== 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_43722690`, 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#321966, cp_burdis#321967, cp_codpays#321968, cp_coduti#321969, cp_datmaj#321970, cp_codinsee#321971], false
(4) Project
Arguments: [cp_codpos#321966 AS COLL0#321978, cp_burdis#321967 AS COLL1#321979, cp_codpays#321968 AS COLL2#321980, cp_coduti#321969 AS COLL3#321981, cp_datmaj#321970 AS COLL4#321982, cp_codinsee#321971 AS COLL5#321983]
(5) Project
Arguments: [COLL0#321978 AS COLL0#321990, COLL1#321979 AS COLL1#321991, COLL2#321980 AS COLL2#321992, COLL3#321981 AS COLL3#321993, COLL4#321982 AS COLL4#321994, COLL5#321983 AS COLL5#321995]
(6) Project
Arguments: [COLL0#321990, COLL1#321991, COLL2#321992, COLL3#321993, COLL4#321994, COLL5#321995]
(7) Project
Arguments: [COLL1#321991 AS CP_BURDIS_437228#322008, COLL5#321995 AS CP_CODINSEE_437232#322009, COLL2#321992 AS CP_CODPAYS_437229#322010, COLL0#321990 AS CP_CODPOS_437227#322011, COLL3#321993 AS CP_CODUTI_437230#322012, COLL4#321994 AS CP_DATMAJ_437231#322013, cast(null as string) AS ORIGINE_440138#322014]
(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#322022, cp_burdis#322023, cp_codpays#322024, cp_coduti#322025, cp_datmaj#322026, cp_codinsee#322027], false
(9) Project
Arguments: [cp_codpos#322022 AS COLL0#322034, cp_burdis#322023 AS COLL1#322035, cp_codpays#322024 AS COLL2#322036, cp_coduti#322025 AS COLL3#322037, cp_datmaj#322026 AS COLL4#322038, cp_codinsee#322027 AS COLL5#322039]
(10) Project
Arguments: [COLL0#322034 AS COLL0#322046, COLL1#322035 AS COLL1#322047, COLL2#322036 AS COLL2#322048, COLL3#322037 AS COLL3#322049, COLL4#322038 AS COLL4#322050, COLL5#322039 AS COLL5#322051]
(11) Project
Arguments: [COLL0#322046, COLL1#322047, COLL2#322048, COLL3#322049, COLL4#322050, COLL5#322051]
(12) Project
Arguments: [COLL1#322047 AS CP_BURDIS_437228#322064, COLL5#322051 AS CP_CODINSEE_437232#322065, COLL2#322048 AS CP_CODPAYS_437229#322066, COLL0#322046 AS CP_CODPOS_437227#322067, COLL3#322049 AS CP_CODUTI_437230#322068, COLL4#322050 AS CP_DATMAJ_437231#322069, cast(null as string) AS ORIGINE_440138#322070]
(13) Union
Arguments: false, false
(14) Project
Arguments: [CP_BURDIS_437228#322008, CP_CODINSEE_437232#322009, CP_CODPAYS_437229#322010, CP_CODPOS_437227#322011, CP_CODUTI_437230#322012, CP_DATMAJ_437231#322013, ORIGINE_440138#322014]
(15) View
Arguments: `3D86F21D_B5A5_41D1_8E3F_5BDEC61F9312`, true
(16) SubqueryAlias
Arguments: 3D86F21D_B5A5_41D1_8E3F_5BDEC61F9312
(17) Project
Arguments: [CP_BURDIS_437228#322008, CP_CODINSEE_437232#322009, CP_CODPAYS_437229#322010, CP_CODPOS_437227#322011, CP_CODUTI_437230#322012, CP_DATMAJ_437231#322013, ORIGINE_440138#322014]
(18) Aggregate
Arguments: [CP_BURDIS_437228#322008, CP_CODINSEE_437232#322009, CP_CODPAYS_437229#322010, CP_CODPOS_437227#322011, CP_CODUTI_437230#322012, CP_DATMAJ_437231#322013, ORIGINE_440138#322014], [CP_BURDIS_437228#322008, CP_CODINSEE_437232#322009, CP_CODPAYS_437229#322010, CP_CODPOS_437227#322011, CP_CODUTI_437230#322012, CP_DATMAJ_437231#322013, ORIGINE_440138#322014]