== Parsed Logical Plan ==
CreateViewCommand `FACT_SJE_FILIAL_141954115`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16538, DATE_FACTURE_141961#16540, MAGASIN_141957#16542, MONTANT_FACTURE_141956#16544, NB_ARTICLE_141958#16546, N_CLIENT_141962#16548, N_FACTURE_141955#16550, VENDEUR_CMP_141960#16552]
+- Project [COLL4#16493 AS CODE_ARTICLE_141959#16538, COLL6#16495 AS DATE_FACTURE_141961#16540, COLL2#16491 AS MAGASIN_141957#16542, COLL1#16490 AS MONTANT_FACTURE_141956#16544, COLL3#16492 AS NB_ARTICLE_141958#16546, COLL7#16496 AS N_CLIENT_141962#16548, COLL0#16489 AS N_FACTURE_141955#16550, COLL5#16494 AS VENDEUR_CMP_141960#16552]
+- Project [COLL0#16489, COLL1#16490, COLL2#16491, COLL3#16492, COLL4#16493, COLL5#16494, COLL6#16495, COLL7#16496]
+- Project [COLL0#16457 AS COLL0#16489, COLL1#16459 AS COLL1#16490, COLL2#16461 AS COLL2#16491, COLL3#16463 AS COLL3#16492, COLL4#16467 AS COLL4#16493, COLL5#16469 AS COLL5#16494, COLL6#16471 AS COLL6#16495, COLL7#16472 AS COLL7#16496]
+- Project [N° Facture#16425 AS COLL0#16457, Montant Facture#16427 AS COLL1#16459, Magasin#16429 AS COLL2#16461, Nb Article#16431 AS COLL3#16463, Code Article#16433 AS COLL4#16467, Vendeur-cmp#16435 AS COLL5#16469, Date Facture#16437 AS COLL6#16471, N° Client#16439 AS COLL7#16472]
+- Relation[N° Facture#16425,Montant Facture#16427,Magasin#16429,Nb Article#16431,Code Article#16433,Vendeur-cmp#16435,Date Facture#16437,N° Client#16439] 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_141954115`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16538, DATE_FACTURE_141961#16540, MAGASIN_141957#16542, MONTANT_FACTURE_141956#16544, NB_ARTICLE_141958#16546, N_CLIENT_141962#16548, N_FACTURE_141955#16550, VENDEUR_CMP_141960#16552]
+- Project [COLL4#16493 AS CODE_ARTICLE_141959#16538, COLL6#16495 AS DATE_FACTURE_141961#16540, COLL2#16491 AS MAGASIN_141957#16542, COLL1#16490 AS MONTANT_FACTURE_141956#16544, COLL3#16492 AS NB_ARTICLE_141958#16546, COLL7#16496 AS N_CLIENT_141962#16548, COLL0#16489 AS N_FACTURE_141955#16550, COLL5#16494 AS VENDEUR_CMP_141960#16552]
+- Project [COLL0#16489, COLL1#16490, COLL2#16491, COLL3#16492, COLL4#16493, COLL5#16494, COLL6#16495, COLL7#16496]
+- Project [COLL0#16457 AS COLL0#16489, COLL1#16459 AS COLL1#16490, COLL2#16461 AS COLL2#16491, COLL3#16463 AS COLL3#16492, COLL4#16467 AS COLL4#16493, COLL5#16469 AS COLL5#16494, COLL6#16471 AS COLL6#16495, COLL7#16472 AS COLL7#16496]
+- Project [N° Facture#16425 AS COLL0#16457, Montant Facture#16427 AS COLL1#16459, Magasin#16429 AS COLL2#16461, Nb Article#16431 AS COLL3#16463, Code Article#16433 AS COLL4#16467, Vendeur-cmp#16435 AS COLL5#16469, Date Facture#16437 AS COLL6#16471, N° Client#16439 AS COLL7#16472]
+- Relation[N° Facture#16425,Montant Facture#16427,Magasin#16429,Nb Article#16431,Code Article#16433,Vendeur-cmp#16435,Date Facture#16437,N° Client#16439] 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_141954115`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16538, DATE_FACTURE_141961#16540, MAGASIN_141957#16542, MONTANT_FACTURE_141956#16544, NB_ARTICLE_141958#16546, N_CLIENT_141962#16548, N_FACTURE_141955#16550, VENDEUR_CMP_141960#16552]
+- Project [COLL4#16493 AS CODE_ARTICLE_141959#16538, COLL6#16495 AS DATE_FACTURE_141961#16540, COLL2#16491 AS MAGASIN_141957#16542, COLL1#16490 AS MONTANT_FACTURE_141956#16544, COLL3#16492 AS NB_ARTICLE_141958#16546, COLL7#16496 AS N_CLIENT_141962#16548, COLL0#16489 AS N_FACTURE_141955#16550, COLL5#16494 AS VENDEUR_CMP_141960#16552]
+- Project [COLL0#16489, COLL1#16490, COLL2#16491, COLL3#16492, COLL4#16493, COLL5#16494, COLL6#16495, COLL7#16496]
+- Project [COLL0#16457 AS COLL0#16489, COLL1#16459 AS COLL1#16490, COLL2#16461 AS COLL2#16491, COLL3#16463 AS COLL3#16492, COLL4#16467 AS COLL4#16493, COLL5#16469 AS COLL5#16494, COLL6#16471 AS COLL6#16495, COLL7#16472 AS COLL7#16496]
+- Project [N° Facture#16425 AS COLL0#16457, Montant Facture#16427 AS COLL1#16459, Magasin#16429 AS COLL2#16461, Nb Article#16431 AS COLL3#16463, Code Article#16433 AS COLL4#16467, Vendeur-cmp#16435 AS COLL5#16469, Date Facture#16437 AS COLL6#16471, N° Client#16439 AS COLL7#16472]
+- Relation[N° Facture#16425,Montant Facture#16427,Magasin#16429,Nb Article#16431,Code Article#16433,Vendeur-cmp#16435,Date Facture#16437,N° Client#16439] 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_141954115`, false, true, LocalTempView
+- Project [CODE_ARTICLE_141959#16538, DATE_FACTURE_141961#16540, MAGASIN_141957#16542, MONTANT_FACTURE_141956#16544, NB_ARTICLE_141958#16546, N_CLIENT_141962#16548, N_FACTURE_141955#16550, VENDEUR_CMP_141960#16552]
+- Project [COLL4#16493 AS CODE_ARTICLE_141959#16538, COLL6#16495 AS DATE_FACTURE_141961#16540, COLL2#16491 AS MAGASIN_141957#16542, COLL1#16490 AS MONTANT_FACTURE_141956#16544, COLL3#16492 AS NB_ARTICLE_141958#16546, COLL7#16496 AS N_CLIENT_141962#16548, COLL0#16489 AS N_FACTURE_141955#16550, COLL5#16494 AS VENDEUR_CMP_141960#16552]
+- Project [COLL0#16489, COLL1#16490, COLL2#16491, COLL3#16492, COLL4#16493, COLL5#16494, COLL6#16495, COLL7#16496]
+- Project [COLL0#16457 AS COLL0#16489, COLL1#16459 AS COLL1#16490, COLL2#16461 AS COLL2#16491, COLL3#16463 AS COLL3#16492, COLL4#16467 AS COLL4#16493, COLL5#16469 AS COLL5#16494, COLL6#16471 AS COLL6#16495, COLL7#16472 AS COLL7#16496]
+- Project [N° Facture#16425 AS COLL0#16457, Montant Facture#16427 AS COLL1#16459, Magasin#16429 AS COLL2#16461, Nb Article#16431 AS COLL3#16463, Code Article#16433 AS COLL4#16467, Vendeur-cmp#16435 AS COLL5#16469, Date Facture#16437 AS COLL6#16471, N° Client#16439 AS COLL7#16472]
+- Relation[N° Facture#16425,Montant Facture#16427,Magasin#16429,Nb Article#16431,Code Article#16433,Vendeur-cmp#16435,Date Facture#16437,N° Client#16439] 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]