== Parsed Logical Plan ==
CreateViewCommand `FACT_SJE_FILIAL_141954118`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16537, DATE_FACTURE_141961#16539, MAGASIN_141957#16541, MONTANT_FACTURE_141956#16543, NB_ARTICLE_141958#16545, N_CLIENT_141962#16547, N_FACTURE_141955#16549, VENDEUR_CMP_141960#16551]
+- Project [COLL4#16501 AS CODE_ARTICLE_141959#16537, COLL6#16503 AS DATE_FACTURE_141961#16539, COLL2#16499 AS MAGASIN_141957#16541, COLL1#16498 AS MONTANT_FACTURE_141956#16543, COLL3#16500 AS NB_ARTICLE_141958#16545, COLL7#16504 AS N_CLIENT_141962#16547, COLL0#16497 AS N_FACTURE_141955#16549, COLL5#16502 AS VENDEUR_CMP_141960#16551]
+- Project [COLL0#16497, COLL1#16498, COLL2#16499, COLL3#16500, COLL4#16501, COLL5#16502, COLL6#16503, COLL7#16504]
+- Project [COLL0#16458 AS COLL0#16497, COLL1#16460 AS COLL1#16498, COLL2#16462 AS COLL2#16499, COLL3#16464 AS COLL3#16500, COLL4#16465 AS COLL4#16501, COLL5#16466 AS COLL5#16502, COLL6#16468 AS COLL6#16503, COLL7#16470 AS COLL7#16504]
+- Project [N° Facture#16426 AS COLL0#16458, Montant Facture#16428 AS COLL1#16460, Magasin#16430 AS COLL2#16462, Nb Article#16432 AS COLL3#16464, Code Article#16434 AS COLL4#16465, Vendeur-cmp#16436 AS COLL5#16466, Date Facture#16438 AS COLL6#16468, N° Client#16440 AS COLL7#16470]
+- Relation[N° Facture#16426,Montant Facture#16428,Magasin#16430,Nb Article#16432,Code Article#16434,Vendeur-cmp#16436,Date Facture#16438,N° Client#16440] JDBCRelation((SELECT "N° Facture", "Montant Facture", "Magasin", "Nb Article", "Code Article", "Vendeur-cmp", "Date Facture", "N° Client" FROM "formation"."fact_sje_filiale_4") as x) [numPartitions=1]
== Analyzed Logical Plan ==
CreateViewCommand `FACT_SJE_FILIAL_141954118`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16537, DATE_FACTURE_141961#16539, MAGASIN_141957#16541, MONTANT_FACTURE_141956#16543, NB_ARTICLE_141958#16545, N_CLIENT_141962#16547, N_FACTURE_141955#16549, VENDEUR_CMP_141960#16551]
+- Project [COLL4#16501 AS CODE_ARTICLE_141959#16537, COLL6#16503 AS DATE_FACTURE_141961#16539, COLL2#16499 AS MAGASIN_141957#16541, COLL1#16498 AS MONTANT_FACTURE_141956#16543, COLL3#16500 AS NB_ARTICLE_141958#16545, COLL7#16504 AS N_CLIENT_141962#16547, COLL0#16497 AS N_FACTURE_141955#16549, COLL5#16502 AS VENDEUR_CMP_141960#16551]
+- Project [COLL0#16497, COLL1#16498, COLL2#16499, COLL3#16500, COLL4#16501, COLL5#16502, COLL6#16503, COLL7#16504]
+- Project [COLL0#16458 AS COLL0#16497, COLL1#16460 AS COLL1#16498, COLL2#16462 AS COLL2#16499, COLL3#16464 AS COLL3#16500, COLL4#16465 AS COLL4#16501, COLL5#16466 AS COLL5#16502, COLL6#16468 AS COLL6#16503, COLL7#16470 AS COLL7#16504]
+- Project [N° Facture#16426 AS COLL0#16458, Montant Facture#16428 AS COLL1#16460, Magasin#16430 AS COLL2#16462, Nb Article#16432 AS COLL3#16464, Code Article#16434 AS COLL4#16465, Vendeur-cmp#16436 AS COLL5#16466, Date Facture#16438 AS COLL6#16468, N° Client#16440 AS COLL7#16470]
+- Relation[N° Facture#16426,Montant Facture#16428,Magasin#16430,Nb Article#16432,Code Article#16434,Vendeur-cmp#16436,Date Facture#16438,N° Client#16440] JDBCRelation((SELECT "N° Facture", "Montant Facture", "Magasin", "Nb Article", "Code Article", "Vendeur-cmp", "Date Facture", "N° Client" FROM "formation"."fact_sje_filiale_4") as x) [numPartitions=1]
== Optimized Logical Plan ==
CreateViewCommand `FACT_SJE_FILIAL_141954118`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16537, DATE_FACTURE_141961#16539, MAGASIN_141957#16541, MONTANT_FACTURE_141956#16543, NB_ARTICLE_141958#16545, N_CLIENT_141962#16547, N_FACTURE_141955#16549, VENDEUR_CMP_141960#16551]
+- Project [COLL4#16501 AS CODE_ARTICLE_141959#16537, COLL6#16503 AS DATE_FACTURE_141961#16539, COLL2#16499 AS MAGASIN_141957#16541, COLL1#16498 AS MONTANT_FACTURE_141956#16543, COLL3#16500 AS NB_ARTICLE_141958#16545, COLL7#16504 AS N_CLIENT_141962#16547, COLL0#16497 AS N_FACTURE_141955#16549, COLL5#16502 AS VENDEUR_CMP_141960#16551]
+- Project [COLL0#16497, COLL1#16498, COLL2#16499, COLL3#16500, COLL4#16501, COLL5#16502, COLL6#16503, COLL7#16504]
+- Project [COLL0#16458 AS COLL0#16497, COLL1#16460 AS COLL1#16498, COLL2#16462 AS COLL2#16499, COLL3#16464 AS COLL3#16500, COLL4#16465 AS COLL4#16501, COLL5#16466 AS COLL5#16502, COLL6#16468 AS COLL6#16503, COLL7#16470 AS COLL7#16504]
+- Project [N° Facture#16426 AS COLL0#16458, Montant Facture#16428 AS COLL1#16460, Magasin#16430 AS COLL2#16462, Nb Article#16432 AS COLL3#16464, Code Article#16434 AS COLL4#16465, Vendeur-cmp#16436 AS COLL5#16466, Date Facture#16438 AS COLL6#16468, N° Client#16440 AS COLL7#16470]
+- Relation[N° Facture#16426,Montant Facture#16428,Magasin#16430,Nb Article#16432,Code Article#16434,Vendeur-cmp#16436,Date Facture#16438,N° Client#16440] JDBCRelation((SELECT "N° Facture", "Montant Facture", "Magasin", "Nb Article", "Code Article", "Vendeur-cmp", "Date Facture", "N° Client" FROM "formation"."fact_sje_filiale_4") as x) [numPartitions=1]
== Physical Plan ==
Execute CreateViewCommand
+- CreateViewCommand `FACT_SJE_FILIAL_141954118`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16537, DATE_FACTURE_141961#16539, MAGASIN_141957#16541, MONTANT_FACTURE_141956#16543, NB_ARTICLE_141958#16545, N_CLIENT_141962#16547, N_FACTURE_141955#16549, VENDEUR_CMP_141960#16551]
+- Project [COLL4#16501 AS CODE_ARTICLE_141959#16537, COLL6#16503 AS DATE_FACTURE_141961#16539, COLL2#16499 AS MAGASIN_141957#16541, COLL1#16498 AS MONTANT_FACTURE_141956#16543, COLL3#16500 AS NB_ARTICLE_141958#16545, COLL7#16504 AS N_CLIENT_141962#16547, COLL0#16497 AS N_FACTURE_141955#16549, COLL5#16502 AS VENDEUR_CMP_141960#16551]
+- Project [COLL0#16497, COLL1#16498, COLL2#16499, COLL3#16500, COLL4#16501, COLL5#16502, COLL6#16503, COLL7#16504]
+- Project [COLL0#16458 AS COLL0#16497, COLL1#16460 AS COLL1#16498, COLL2#16462 AS COLL2#16499, COLL3#16464 AS COLL3#16500, COLL4#16465 AS COLL4#16501, COLL5#16466 AS COLL5#16502, COLL6#16468 AS COLL6#16503, COLL7#16470 AS COLL7#16504]
+- Project [N° Facture#16426 AS COLL0#16458, Montant Facture#16428 AS COLL1#16460, Magasin#16430 AS COLL2#16462, Nb Article#16432 AS COLL3#16464, Code Article#16434 AS COLL4#16465, Vendeur-cmp#16436 AS COLL5#16466, Date Facture#16438 AS COLL6#16468, N° Client#16440 AS COLL7#16470]
+- Relation[N° Facture#16426,Montant Facture#16428,Magasin#16430,Nb Article#16432,Code Article#16434,Vendeur-cmp#16436,Date Facture#16438,N° Client#16440] JDBCRelation((SELECT "N° Facture", "Montant Facture", "Magasin", "Nb Article", "Code Article", "Vendeur-cmp", "Date Facture", "N° Client" FROM "formation"."fact_sje_filiale_4") as x) [numPartitions=1]
