== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
+- Project [COL_N_FACTURE_141955#16650 AS COL_N_FACTURE_141955#16697, COL_MONTANT_FACTURE_141956#16652 AS COL_MONTANT_FACTURE_141956#16700, COL_MAGASIN_141957#16654 AS COL_MAGASIN_141957#16703, COL_NB_ARTICLE_141958#16656 AS COL_NB_ARTICLE_141958#16705, COL_CODE_ARTICLE_141959#16658 AS COL_CODE_ARTICLE_141959#16707, COL_VENDEUR_CMP_141960#16660 AS COL_VENDEUR_CMP_141960#16709, COL_DATE_FACTURE_141961#16662 AS COL_DATE_FACTURE_141961#16711, COL_N_CLIENT_141962#16664 AS COL_N_CLIENT_141962#16712]
+- Filter true
+- Project [COL_N_FACTURE_141955#16650, COL_MONTANT_FACTURE_141956#16652, COL_MAGASIN_141957#16654, COL_NB_ARTICLE_141958#16656, COL_CODE_ARTICLE_141959#16658, COL_VENDEUR_CMP_141960#16660, COL_DATE_FACTURE_141961#16662, COL_N_CLIENT_141962#16664]
+- Project [cast(FACT_SJE_FILIAL_141954_N_FACTURE_141955#16615 as string) AS COL_N_FACTURE_141955#16650, cast(FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16612 as double) AS COL_MONTANT_FACTURE_141956#16652, cast(FACT_SJE_FILIAL_141954_MAGASIN_141957#16611 as string) AS COL_MAGASIN_141957#16654, cast(FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16613 as double) AS COL_NB_ARTICLE_141958#16656, cast(FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16609 as string) AS COL_CODE_ARTICLE_141959#16658, cast(FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16616 as string) AS COL_VENDEUR_CMP_141960#16660, cast(FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16610 as timestamp) AS COL_DATE_FACTURE_141961#16662, cast(FACT_SJE_FILIAL_141954_N_CLIENT_141962#16614 as string) AS COL_N_CLIENT_141962#16664]
+- Project [CODE_ARTICLE_141959#16537 AS FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16609, DATE_FACTURE_141961#16539 AS FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16610, MAGASIN_141957#16541 AS FACT_SJE_FILIAL_141954_MAGASIN_141957#16611, MONTANT_FACTURE_141956#16543 AS FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16612, NB_ARTICLE_141958#16545 AS FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16613, N_CLIENT_141962#16547 AS FACT_SJE_FILIAL_141954_N_CLIENT_141962#16614, N_FACTURE_141955#16549 AS FACT_SJE_FILIAL_141954_N_FACTURE_141955#16615, VENDEUR_CMP_141960#16551 AS FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16616]
+- SubqueryAlias FACT_SJE_FILIAL_141954118
+- 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 ==
COL_N_FACTURE_141955: string, COL_MONTANT_FACTURE_141956: double, COL_MAGASIN_141957: string, COL_NB_ARTICLE_141958: double, COL_CODE_ARTICLE_141959: string, COL_VENDEUR_CMP_141960: string, COL_DATE_FACTURE_141961: timestamp, COL_N_CLIENT_141962: string
GlobalLimit 1500
+- LocalLimit 1500
+- Project [COL_N_FACTURE_141955#16650 AS COL_N_FACTURE_141955#16697, COL_MONTANT_FACTURE_141956#16652 AS COL_MONTANT_FACTURE_141956#16700, COL_MAGASIN_141957#16654 AS COL_MAGASIN_141957#16703, COL_NB_ARTICLE_141958#16656 AS COL_NB_ARTICLE_141958#16705, COL_CODE_ARTICLE_141959#16658 AS COL_CODE_ARTICLE_141959#16707, COL_VENDEUR_CMP_141960#16660 AS COL_VENDEUR_CMP_141960#16709, COL_DATE_FACTURE_141961#16662 AS COL_DATE_FACTURE_141961#16711, COL_N_CLIENT_141962#16664 AS COL_N_CLIENT_141962#16712]
+- Filter true
+- Project [COL_N_FACTURE_141955#16650, COL_MONTANT_FACTURE_141956#16652, COL_MAGASIN_141957#16654, COL_NB_ARTICLE_141958#16656, COL_CODE_ARTICLE_141959#16658, COL_VENDEUR_CMP_141960#16660, COL_DATE_FACTURE_141961#16662, COL_N_CLIENT_141962#16664]
+- Project [cast(FACT_SJE_FILIAL_141954_N_FACTURE_141955#16615 as string) AS COL_N_FACTURE_141955#16650, cast(FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16612 as double) AS COL_MONTANT_FACTURE_141956#16652, cast(FACT_SJE_FILIAL_141954_MAGASIN_141957#16611 as string) AS COL_MAGASIN_141957#16654, cast(FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16613 as double) AS COL_NB_ARTICLE_141958#16656, cast(FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16609 as string) AS COL_CODE_ARTICLE_141959#16658, cast(FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16616 as string) AS COL_VENDEUR_CMP_141960#16660, cast(FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16610 as timestamp) AS COL_DATE_FACTURE_141961#16662, cast(FACT_SJE_FILIAL_141954_N_CLIENT_141962#16614 as string) AS COL_N_CLIENT_141962#16664]
+- Project [CODE_ARTICLE_141959#16537 AS FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16609, DATE_FACTURE_141961#16539 AS FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16610, MAGASIN_141957#16541 AS FACT_SJE_FILIAL_141954_MAGASIN_141957#16611, MONTANT_FACTURE_141956#16543 AS FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16612, NB_ARTICLE_141958#16545 AS FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16613, N_CLIENT_141962#16547 AS FACT_SJE_FILIAL_141954_N_CLIENT_141962#16614, N_FACTURE_141955#16549 AS FACT_SJE_FILIAL_141954_N_FACTURE_141955#16615, VENDEUR_CMP_141960#16551 AS FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16616]
+- SubqueryAlias FACT_SJE_FILIAL_141954118
+- 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 ==
GlobalLimit 1500
+- LocalLimit 1500
+- Project [N° Facture#16426 AS COL_N_FACTURE_141955#16697, Montant Facture#16428 AS COL_MONTANT_FACTURE_141956#16700, Magasin#16430 AS COL_MAGASIN_141957#16703, Nb Article#16432 AS COL_NB_ARTICLE_141958#16705, Code Article#16434 AS COL_CODE_ARTICLE_141959#16707, Vendeur-cmp#16436 AS COL_VENDEUR_CMP_141960#16709, Date Facture#16438 AS COL_DATE_FACTURE_141961#16711, N° Client#16440 AS COL_N_CLIENT_141962#16712]
+- 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 ==
CollectLimit 1500
+- *(1) Project [N° Facture#16426 AS COL_N_FACTURE_141955#16697, Montant Facture#16428 AS COL_MONTANT_FACTURE_141956#16700, Magasin#16430 AS COL_MAGASIN_141957#16703, Nb Article#16432 AS COL_NB_ARTICLE_141958#16705, Code Article#16434 AS COL_CODE_ARTICLE_141959#16707, Vendeur-cmp#16436 AS COL_VENDEUR_CMP_141960#16709, Date Facture#16438 AS COL_DATE_FACTURE_141961#16711, N° Client#16440 AS COL_N_CLIENT_141962#16712]
+- *(1) Scan 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] [Vendeur-cmp#16436,N° Client#16440,Date Facture#16438,Montant Facture#16428,Code Article#16434,Nb Article#16432,Magasin#16430,N° Facture#16426] PushedFilters: [], ReadSchema: struct<Vendeur-cmp:string,N° Client:string,Date Facture:timestamp,Montant Facture:double,Code Art...
