== Parsed Logical Plan ==
Aggregate [count(1) AS count#16738L]
+- Project [COL_N_FACTURE_141955#16649 AS COL_N_FACTURE_141955#16698, COL_MONTANT_FACTURE_141956#16651 AS COL_MONTANT_FACTURE_141956#16699, COL_MAGASIN_141957#16653 AS COL_MAGASIN_141957#16701, COL_NB_ARTICLE_141958#16655 AS COL_NB_ARTICLE_141958#16702, COL_CODE_ARTICLE_141959#16657 AS COL_CODE_ARTICLE_141959#16704, COL_VENDEUR_CMP_141960#16659 AS COL_VENDEUR_CMP_141960#16706, COL_DATE_FACTURE_141961#16661 AS COL_DATE_FACTURE_141961#16708, COL_N_CLIENT_141962#16663 AS COL_N_CLIENT_141962#16710]
+- Filter true
+- Project [COL_N_FACTURE_141955#16649, COL_MONTANT_FACTURE_141956#16651, COL_MAGASIN_141957#16653, COL_NB_ARTICLE_141958#16655, COL_CODE_ARTICLE_141959#16657, COL_VENDEUR_CMP_141960#16659, COL_DATE_FACTURE_141961#16661, COL_N_CLIENT_141962#16663]
+- Project [cast(FACT_SJE_FILIAL_141954_N_FACTURE_141955#16607 as string) AS COL_N_FACTURE_141955#16649, cast(FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16604 as double) AS COL_MONTANT_FACTURE_141956#16651, cast(FACT_SJE_FILIAL_141954_MAGASIN_141957#16603 as string) AS COL_MAGASIN_141957#16653, cast(FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16605 as double) AS COL_NB_ARTICLE_141958#16655, cast(FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16601 as string) AS COL_CODE_ARTICLE_141959#16657, cast(FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16608 as string) AS COL_VENDEUR_CMP_141960#16659, cast(FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16602 as timestamp) AS COL_DATE_FACTURE_141961#16661, cast(FACT_SJE_FILIAL_141954_N_CLIENT_141962#16606 as string) AS COL_N_CLIENT_141962#16663]
+- Project [CODE_ARTICLE_141959#16538 AS FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16601, DATE_FACTURE_141961#16540 AS FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16602, MAGASIN_141957#16542 AS FACT_SJE_FILIAL_141954_MAGASIN_141957#16603, MONTANT_FACTURE_141956#16544 AS FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16604, NB_ARTICLE_141958#16546 AS FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16605, N_CLIENT_141962#16548 AS FACT_SJE_FILIAL_141954_N_CLIENT_141962#16606, N_FACTURE_141955#16550 AS FACT_SJE_FILIAL_141954_N_FACTURE_141955#16607, VENDEUR_CMP_141960#16552 AS FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16608]
+- SubqueryAlias FACT_SJE_FILIAL_141954115
+- 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 ==
count: bigint
Aggregate [count(1) AS count#16738L]
+- Project [COL_N_FACTURE_141955#16649 AS COL_N_FACTURE_141955#16698, COL_MONTANT_FACTURE_141956#16651 AS COL_MONTANT_FACTURE_141956#16699, COL_MAGASIN_141957#16653 AS COL_MAGASIN_141957#16701, COL_NB_ARTICLE_141958#16655 AS COL_NB_ARTICLE_141958#16702, COL_CODE_ARTICLE_141959#16657 AS COL_CODE_ARTICLE_141959#16704, COL_VENDEUR_CMP_141960#16659 AS COL_VENDEUR_CMP_141960#16706, COL_DATE_FACTURE_141961#16661 AS COL_DATE_FACTURE_141961#16708, COL_N_CLIENT_141962#16663 AS COL_N_CLIENT_141962#16710]
+- Filter true
+- Project [COL_N_FACTURE_141955#16649, COL_MONTANT_FACTURE_141956#16651, COL_MAGASIN_141957#16653, COL_NB_ARTICLE_141958#16655, COL_CODE_ARTICLE_141959#16657, COL_VENDEUR_CMP_141960#16659, COL_DATE_FACTURE_141961#16661, COL_N_CLIENT_141962#16663]
+- Project [cast(FACT_SJE_FILIAL_141954_N_FACTURE_141955#16607 as string) AS COL_N_FACTURE_141955#16649, cast(FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16604 as double) AS COL_MONTANT_FACTURE_141956#16651, cast(FACT_SJE_FILIAL_141954_MAGASIN_141957#16603 as string) AS COL_MAGASIN_141957#16653, cast(FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16605 as double) AS COL_NB_ARTICLE_141958#16655, cast(FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16601 as string) AS COL_CODE_ARTICLE_141959#16657, cast(FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16608 as string) AS COL_VENDEUR_CMP_141960#16659, cast(FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16602 as timestamp) AS COL_DATE_FACTURE_141961#16661, cast(FACT_SJE_FILIAL_141954_N_CLIENT_141962#16606 as string) AS COL_N_CLIENT_141962#16663]
+- Project [CODE_ARTICLE_141959#16538 AS FACT_SJE_FILIAL_141954_CODE_ARTICLE_141959#16601, DATE_FACTURE_141961#16540 AS FACT_SJE_FILIAL_141954_DATE_FACTURE_141961#16602, MAGASIN_141957#16542 AS FACT_SJE_FILIAL_141954_MAGASIN_141957#16603, MONTANT_FACTURE_141956#16544 AS FACT_SJE_FILIAL_141954_MONTANT_FACTURE_141956#16604, NB_ARTICLE_141958#16546 AS FACT_SJE_FILIAL_141954_NB_ARTICLE_141958#16605, N_CLIENT_141962#16548 AS FACT_SJE_FILIAL_141954_N_CLIENT_141962#16606, N_FACTURE_141955#16550 AS FACT_SJE_FILIAL_141954_N_FACTURE_141955#16607, VENDEUR_CMP_141960#16552 AS FACT_SJE_FILIAL_141954_VENDEUR_CMP_141960#16608]
+- SubqueryAlias FACT_SJE_FILIAL_141954115
+- 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 ==
Aggregate [count(1) AS count#16738L]
+- Project
+- 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 ==
AdaptiveSparkPlan isFinalPlan=true
+- *(2) HashAggregate(keys=[], functions=[count(1)], output=[count#16738L])
+- ShuffleQueryStage 0
+- Exchange SinglePartition, true, [id=#1508]
+- *(1) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#16741L])
+- *(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] [] PushedFilters: [], ReadSchema: struct<>
