== 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_CDAM_43720990`, false, true, LocalTempView, true
(3) LogicalRelation
Arguments: JDBCRelation((SELECT "da_codcha", "da_codbas", "da_annval", "da_poids", "da_letgre", "da_icr", "da_noseq", "da_seule", "da_cdam", "da_defini", "da_index", "da_datmeo", "da_datmaj", "da_coduti", "da_unioeu" FROM "xplore"."h_cdam") as x) [numPartitions=1], [da_codcha#319383, da_codbas#319384, da_annval#319385, da_poids#319386, da_letgre#319387, da_icr#319388, da_noseq#319389, da_seule#319390, da_cdam#319391, da_defini#319392, da_index#319393, da_datmeo#319394, da_datmaj#319395, da_coduti#319396, da_unioeu#319397], false
(4) Project
Arguments: [da_codcha#319383 AS COLL0#319413, da_codbas#319384 AS COLL1#319414, da_annval#319385 AS COLL2#319415, da_poids#319386 AS COLL3#319416, da_letgre#319387 AS COLL4#319417, da_icr#319388 AS COLL5#319418, da_noseq#319389 AS COLL6#319419, da_seule#319390 AS COLL7#319420, da_cdam#319391 AS COLL8#319421, da_defini#319392 AS COLL9#319422, da_index#319393 AS COLL10#319423, da_datmeo#319394 AS COLL11#319424, da_datmaj#319395 AS COLL12#319425, da_coduti#319396 AS COLL13#319426, da_unioeu#319397 AS COLL14#319427]
(5) Project
Arguments: [COLL0#319413 AS COLL0#319443, COLL1#319414 AS COLL1#319444, COLL2#319415 AS COLL2#319445, COLL3#319416 AS COLL3#319446, COLL4#319417 AS COLL4#319447, COLL5#319418 AS COLL5#319448, COLL6#319419 AS COLL6#319449, COLL7#319420 AS COLL7#319450, COLL8#319421 AS COLL8#319451, COLL9#319422 AS COLL9#319452, COLL10#319423 AS COLL10#319453, COLL11#319424 AS COLL11#319454, COLL12#319425 AS COLL12#319455, COLL13#319426 AS COLL13#319456, COLL14#319427 AS COLL14#319457]
(6) Project
Arguments: [COLL0#319443, COLL1#319444, COLL2#319445, COLL3#319446, COLL4#319447, COLL5#319448, COLL6#319449, COLL7#319450, COLL8#319451, COLL9#319452, COLL10#319453, COLL11#319454, COLL12#319455, COLL13#319456, COLL14#319457]
(7) Project
Arguments: [COLL2#319445 AS DA_ANNVAL_437212#319488, COLL8#319451 AS DA_CDAM_437218#319489, COLL1#319444 AS DA_CODBAS_437211#319490, COLL0#319443 AS DA_CODCHA_437210#319491, COLL13#319456 AS DA_CODUTI_437223#319492, COLL12#319455 AS DA_DATMAJ_437222#319493, COLL11#319454 AS DA_DATMEO_437221#319494, COLL9#319452 AS DA_DEFINI_437219#319495, COLL5#319448 AS DA_ICR_437215#319496, COLL10#319453 AS DA_INDEX_437220#319497, COLL4#319447 AS DA_LETGRE_437214#319498, COLL6#319449 AS DA_NOSEQ_437216#319499, COLL3#319446 AS DA_POIDS_437213#319500, COLL7#319450 AS DA_SEULE_437217#319501, COLL14#319457 AS DA_UNIOEU_437224#319502, cast(null as string) AS ORIGINE_440137#319503]
(8) LogicalRelation
Arguments: JDBCRelation((SELECT "da_codcha", "da_codbas", "da_annval", "da_poids", "da_letgre", "da_icr", "da_noseq", "da_seule", "da_cdam", "da_defini", "da_index", "da_datmeo", "da_datmaj", "da_coduti", "da_unioeu" FROM "xplore2"."h_cdam") as x) [numPartitions=1], [da_codcha#319520, da_codbas#319521, da_annval#319522, da_poids#319523, da_letgre#319524, da_icr#319525, da_noseq#319526, da_seule#319527, da_cdam#319528, da_defini#319529, da_index#319530, da_datmeo#319531, da_datmaj#319532, da_coduti#319533, da_unioeu#319534], false
(9) Project
Arguments: [da_codcha#319520 AS COLL0#319550, da_codbas#319521 AS COLL1#319551, da_annval#319522 AS COLL2#319552, da_poids#319523 AS COLL3#319553, da_letgre#319524 AS COLL4#319554, da_icr#319525 AS COLL5#319555, da_noseq#319526 AS COLL6#319556, da_seule#319527 AS COLL7#319557, da_cdam#319528 AS COLL8#319558, da_defini#319529 AS COLL9#319559, da_index#319530 AS COLL10#319560, da_datmeo#319531 AS COLL11#319561, da_datmaj#319532 AS COLL12#319562, da_coduti#319533 AS COLL13#319563, da_unioeu#319534 AS COLL14#319564]
(10) Project
Arguments: [COLL0#319550 AS COLL0#319580, COLL1#319551 AS COLL1#319581, COLL2#319552 AS COLL2#319582, COLL3#319553 AS COLL3#319583, COLL4#319554 AS COLL4#319584, COLL5#319555 AS COLL5#319585, COLL6#319556 AS COLL6#319586, COLL7#319557 AS COLL7#319587, COLL8#319558 AS COLL8#319588, COLL9#319559 AS COLL9#319589, COLL10#319560 AS COLL10#319590, COLL11#319561 AS COLL11#319591, COLL12#319562 AS COLL12#319592, COLL13#319563 AS COLL13#319593, COLL14#319564 AS COLL14#319594]
(11) Project
Arguments: [COLL0#319580, COLL1#319581, COLL2#319582, COLL3#319583, COLL4#319584, COLL5#319585, COLL6#319586, COLL7#319587, COLL8#319588, COLL9#319589, COLL10#319590, COLL11#319591, COLL12#319592, COLL13#319593, COLL14#319594]
(12) Project
Arguments: [COLL2#319582 AS DA_ANNVAL_437212#319625, COLL8#319588 AS DA_CDAM_437218#319626, COLL1#319581 AS DA_CODBAS_437211#319627, COLL0#319580 AS DA_CODCHA_437210#319628, COLL13#319593 AS DA_CODUTI_437223#319629, COLL12#319592 AS DA_DATMAJ_437222#319630, COLL11#319591 AS DA_DATMEO_437221#319631, COLL9#319589 AS DA_DEFINI_437219#319632, COLL5#319585 AS DA_ICR_437215#319633, COLL10#319590 AS DA_INDEX_437220#319634, COLL4#319584 AS DA_LETGRE_437214#319635, COLL6#319586 AS DA_NOSEQ_437216#319636, COLL3#319583 AS DA_POIDS_437213#319637, COLL7#319587 AS DA_SEULE_437217#319638, COLL14#319594 AS DA_UNIOEU_437224#319639, cast(null as string) AS ORIGINE_440137#319640]
(13) Union
Arguments: false, false
(14) Project
Arguments: [DA_ANNVAL_437212#319488, DA_CDAM_437218#319489, DA_CODBAS_437211#319490, DA_CODCHA_437210#319491, DA_CODUTI_437223#319492, DA_DATMAJ_437222#319493, DA_DATMEO_437221#319494, DA_DEFINI_437219#319495, DA_ICR_437215#319496, DA_INDEX_437220#319497, DA_LETGRE_437214#319498, DA_NOSEQ_437216#319499, DA_POIDS_437213#319500, DA_SEULE_437217#319501, DA_UNIOEU_437224#319502, ORIGINE_440137#319503]
(15) View
Arguments: `F1CD13ED_23C0_4723_9D2D_09E69CDD611F`, true
(16) SubqueryAlias
Arguments: F1CD13ED_23C0_4723_9D2D_09E69CDD611F
(17) Project
Arguments: [DA_ANNVAL_437212#319488, DA_CDAM_437218#319489, DA_CODBAS_437211#319490, DA_CODCHA_437210#319491, DA_CODUTI_437223#319492, DA_DATMAJ_437222#319493, DA_DATMEO_437221#319494, DA_DEFINI_437219#319495, DA_ICR_437215#319496, DA_INDEX_437220#319497, DA_LETGRE_437214#319498, DA_NOSEQ_437216#319499, DA_POIDS_437213#319500, DA_SEULE_437217#319501, DA_UNIOEU_437224#319502, ORIGINE_440137#319503]
(18) Aggregate
Arguments: [DA_ANNVAL_437212#319488, DA_CDAM_437218#319489, DA_CODBAS_437211#319490, DA_CODCHA_437210#319491, DA_CODUTI_437223#319492, DA_DATMAJ_437222#319493, DA_DATMEO_437221#319494, DA_DEFINI_437219#319495, DA_ICR_437215#319496, DA_INDEX_437220#319497, DA_LETGRE_437214#319498, DA_NOSEQ_437216#319499, DA_POIDS_437213#319500, DA_SEULE_437217#319501, DA_UNIOEU_437224#319502, ORIGINE_440137#319503], [DA_ANNVAL_437212#319488, DA_CDAM_437218#319489, DA_CODBAS_437211#319490, DA_CODCHA_437210#319491, DA_CODUTI_437223#319492, DA_DATMAJ_437222#319493, DA_DATMEO_437221#319494, DA_DEFINI_437219#319495, DA_ICR_437215#319496, DA_INDEX_437220#319497, DA_LETGRE_437214#319498, DA_NOSEQ_437216#319499, DA_POIDS_437213#319500, DA_SEULE_437217#319501, DA_UNIOEU_437224#319502, ORIGINE_440137#319503]