== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
+- Project [COL_NIVEAU_CODE_2777#1790 AS COL_NIVEAU_CODE_2777#1817, COL_ATC_CODE_2778#1791 AS COL_ATC_CODE_2778#1818, COL_ATC_CODEPERE_2779#1792 AS COL_ATC_CODEPERE_2779#1819, COL_LIBELLE_ANGLAIS_2780#1793 AS COL_LIBELLE_ANGLAIS_2780#1820, COL_LIBELLE_FRANCAI_2781#1794 AS COL_LIBELLE_FRANCAI_2781#1821, COL_COMMENTAIRES_2782#1795 AS COL_COMMENTAIRES_2782#1822, COL_CREATION_2783#1796 AS COL_CREATION_2783#1823, COL_MODIFICATION_2784#1797 AS COL_MODIFICATION_2784#1824, COL_INACTIVATION_2785#1798 AS COL_INACTIVATION_2785#1825]
+- Filter true
+- Project [COL_NIVEAU_CODE_2777#1790, COL_ATC_CODE_2778#1791, COL_ATC_CODEPERE_2779#1792, COL_LIBELLE_ANGLAIS_2780#1793, COL_LIBELLE_FRANCAI_2781#1794, COL_COMMENTAIRES_2782#1795, COL_CREATION_2783#1796, COL_MODIFICATION_2784#1797, COL_INACTIVATION_2785#1798]
+- Project [cast(ATC_2776_NIVEAU_CODE_2777#1771 as string) AS COL_NIVEAU_CODE_2777#1790, cast(ATC_2776_ATC_CODE_2778#1764 as string) AS COL_ATC_CODE_2778#1791, cast(ATC_2776_ATC_CODEPERE_2779#1763 as string) AS COL_ATC_CODEPERE_2779#1792, cast(ATC_2776_LIBELLE_ANGLAIS_2780#1768 as string) AS COL_LIBELLE_ANGLAIS_2780#1793, cast(ATC_2776_LIBELLE_FRANCAI_2781#1769 as string) AS COL_LIBELLE_FRANCAI_2781#1794, cast(ATC_2776_COMMENTAIRES_2782#1765 as string) AS COL_COMMENTAIRES_2782#1795, cast(ATC_2776_CREATION_2783#1766 as string) AS COL_CREATION_2783#1796, cast(ATC_2776_MODIFICATION_2784#1770 as string) AS COL_MODIFICATION_2784#1797, cast(ATC_2776_INACTIVATION_2785#1767 as string) AS COL_INACTIVATION_2785#1798]
+- Project [ATC_CODEPERE_2779#1727 AS ATC_2776_ATC_CODEPERE_2779#1763, ATC_CODE_2778#1728 AS ATC_2776_ATC_CODE_2778#1764, COMMENTAIRES_2782#1729 AS ATC_2776_COMMENTAIRES_2782#1765, CREATION_2783#1730 AS ATC_2776_CREATION_2783#1766, INACTIVATION_2785#1731 AS ATC_2776_INACTIVATION_2785#1767, LIBELLE_ANGLAIS_2780#1732 AS ATC_2776_LIBELLE_ANGLAIS_2780#1768, LIBELLE_FRANCAI_2781#1733 AS ATC_2776_LIBELLE_FRANCAI_2781#1769, MODIFICATION_2784#1734 AS ATC_2776_MODIFICATION_2784#1770, NIVEAU_CODE_2777#1735 AS ATC_2776_NIVEAU_CODE_2777#1771]
+- SubqueryAlias ATC_2776110
+- Project [ATC_CODEPERE_2779#1727, ATC_CODE_2778#1728, COMMENTAIRES_2782#1729, CREATION_2783#1730, INACTIVATION_2785#1731, LIBELLE_ANGLAIS_2780#1732, LIBELLE_FRANCAI_2781#1733, MODIFICATION_2784#1734, NIVEAU_CODE_2777#1735]
+- Project [ATC_codePere#1699 AS ATC_CODEPERE_2779#1727, ATC_code#1698 AS ATC_CODE_2778#1728, Commentaires#1702 AS COMMENTAIRES_2782#1729, Création#1703 AS CREATION_2783#1730, Inactivation#1705 AS INACTIVATION_2785#1731, Libellé anglais#1700 AS LIBELLE_ANGLAIS_2780#1732, Libellé français#1701 AS LIBELLE_FRANCAI_2781#1733, Modification#1704 AS MODIFICATION_2784#1734, Niveau code#1697 AS NIVEAU_CODE_2777#1735]
+- Project [Niveau code#1697, ATC_code#1698, ATC_codePere#1699, Libellé anglais#1700, Libellé français#1701, Commentaires#1702, Création#1703, Modification#1704, Inactivation#1705, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1706]
+- Project [Niveau code#1587 AS Niveau code#1697, ATC_code#1598 AS ATC_code#1698, ATC_codePere#1609 AS ATC_codePere#1699, Libellé anglais#1620 AS Libellé anglais#1700, Libellé français#1631 AS Libellé français#1701, Commentaires#1642 AS Commentaires#1702, Création#1653 AS Création#1703, Modification#1664 AS Modification#1704, Inactivation#1675 AS Inactivation#1705, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1686 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1706]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1664, Inactivation#1675, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1686]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1664, Inactivation#1575 AS Inactivation#1675, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1574 AS Modification#1664, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Cr%C3%A9ation#1573 AS Création#1653, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1572 AS Commentaires#1642, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libell%C3%A9+fran%C3%A7ais#1571 AS Libellé français#1631, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libell%C3%A9+anglais#1570 AS Libellé anglais#1620, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1569 AS ATC_codePere#1609, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1568 AS ATC_code#1598, ATC_codePere#1569, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau+code#1567 AS Niveau code#1587, ATC_code#1568, ATC_codePere#1569, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Relation[Niveau+code#1567,ATC_code#1568,ATC_codePere#1569,Libell%C3%A9+anglais#1570,Libell%C3%A9+fran%C3%A7ais#1571,Commentaires#1572,Cr%C3%A9ation#1573,Modification#1574,Inactivation#1575,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576] parquet
== Analyzed Logical Plan ==
COL_NIVEAU_CODE_2777: string, COL_ATC_CODE_2778: string, COL_ATC_CODEPERE_2779: string, COL_LIBELLE_ANGLAIS_2780: string, COL_LIBELLE_FRANCAI_2781: string, COL_COMMENTAIRES_2782: string, COL_CREATION_2783: string, COL_MODIFICATION_2784: string, COL_INACTIVATION_2785: string
GlobalLimit 1500
+- LocalLimit 1500
+- Project [COL_NIVEAU_CODE_2777#1790 AS COL_NIVEAU_CODE_2777#1817, COL_ATC_CODE_2778#1791 AS COL_ATC_CODE_2778#1818, COL_ATC_CODEPERE_2779#1792 AS COL_ATC_CODEPERE_2779#1819, COL_LIBELLE_ANGLAIS_2780#1793 AS COL_LIBELLE_ANGLAIS_2780#1820, COL_LIBELLE_FRANCAI_2781#1794 AS COL_LIBELLE_FRANCAI_2781#1821, COL_COMMENTAIRES_2782#1795 AS COL_COMMENTAIRES_2782#1822, COL_CREATION_2783#1796 AS COL_CREATION_2783#1823, COL_MODIFICATION_2784#1797 AS COL_MODIFICATION_2784#1824, COL_INACTIVATION_2785#1798 AS COL_INACTIVATION_2785#1825]
+- Filter true
+- Project [COL_NIVEAU_CODE_2777#1790, COL_ATC_CODE_2778#1791, COL_ATC_CODEPERE_2779#1792, COL_LIBELLE_ANGLAIS_2780#1793, COL_LIBELLE_FRANCAI_2781#1794, COL_COMMENTAIRES_2782#1795, COL_CREATION_2783#1796, COL_MODIFICATION_2784#1797, COL_INACTIVATION_2785#1798]
+- Project [cast(ATC_2776_NIVEAU_CODE_2777#1771 as string) AS COL_NIVEAU_CODE_2777#1790, cast(ATC_2776_ATC_CODE_2778#1764 as string) AS COL_ATC_CODE_2778#1791, cast(ATC_2776_ATC_CODEPERE_2779#1763 as string) AS COL_ATC_CODEPERE_2779#1792, cast(ATC_2776_LIBELLE_ANGLAIS_2780#1768 as string) AS COL_LIBELLE_ANGLAIS_2780#1793, cast(ATC_2776_LIBELLE_FRANCAI_2781#1769 as string) AS COL_LIBELLE_FRANCAI_2781#1794, cast(ATC_2776_COMMENTAIRES_2782#1765 as string) AS COL_COMMENTAIRES_2782#1795, cast(ATC_2776_CREATION_2783#1766 as string) AS COL_CREATION_2783#1796, cast(ATC_2776_MODIFICATION_2784#1770 as string) AS COL_MODIFICATION_2784#1797, cast(ATC_2776_INACTIVATION_2785#1767 as string) AS COL_INACTIVATION_2785#1798]
+- Project [ATC_CODEPERE_2779#1727 AS ATC_2776_ATC_CODEPERE_2779#1763, ATC_CODE_2778#1728 AS ATC_2776_ATC_CODE_2778#1764, COMMENTAIRES_2782#1729 AS ATC_2776_COMMENTAIRES_2782#1765, CREATION_2783#1730 AS ATC_2776_CREATION_2783#1766, INACTIVATION_2785#1731 AS ATC_2776_INACTIVATION_2785#1767, LIBELLE_ANGLAIS_2780#1732 AS ATC_2776_LIBELLE_ANGLAIS_2780#1768, LIBELLE_FRANCAI_2781#1733 AS ATC_2776_LIBELLE_FRANCAI_2781#1769, MODIFICATION_2784#1734 AS ATC_2776_MODIFICATION_2784#1770, NIVEAU_CODE_2777#1735 AS ATC_2776_NIVEAU_CODE_2777#1771]
+- SubqueryAlias ATC_2776110
+- Project [ATC_CODEPERE_2779#1727, ATC_CODE_2778#1728, COMMENTAIRES_2782#1729, CREATION_2783#1730, INACTIVATION_2785#1731, LIBELLE_ANGLAIS_2780#1732, LIBELLE_FRANCAI_2781#1733, MODIFICATION_2784#1734, NIVEAU_CODE_2777#1735]
+- Project [ATC_codePere#1699 AS ATC_CODEPERE_2779#1727, ATC_code#1698 AS ATC_CODE_2778#1728, Commentaires#1702 AS COMMENTAIRES_2782#1729, Création#1703 AS CREATION_2783#1730, Inactivation#1705 AS INACTIVATION_2785#1731, Libellé anglais#1700 AS LIBELLE_ANGLAIS_2780#1732, Libellé français#1701 AS LIBELLE_FRANCAI_2781#1733, Modification#1704 AS MODIFICATION_2784#1734, Niveau code#1697 AS NIVEAU_CODE_2777#1735]
+- Project [Niveau code#1697, ATC_code#1698, ATC_codePere#1699, Libellé anglais#1700, Libellé français#1701, Commentaires#1702, Création#1703, Modification#1704, Inactivation#1705, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1706]
+- Project [Niveau code#1587 AS Niveau code#1697, ATC_code#1598 AS ATC_code#1698, ATC_codePere#1609 AS ATC_codePere#1699, Libellé anglais#1620 AS Libellé anglais#1700, Libellé français#1631 AS Libellé français#1701, Commentaires#1642 AS Commentaires#1702, Création#1653 AS Création#1703, Modification#1664 AS Modification#1704, Inactivation#1675 AS Inactivation#1705, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1686 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1706]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1664, Inactivation#1675, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576 AS 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1686]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1664, Inactivation#1575 AS Inactivation#1675, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Création#1653, Modification#1574 AS Modification#1664, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1642, Cr%C3%A9ation#1573 AS Création#1653, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libellé français#1631, Commentaires#1572 AS Commentaires#1642, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libellé anglais#1620, Libell%C3%A9+fran%C3%A7ais#1571 AS Libellé français#1631, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1609, Libell%C3%A9+anglais#1570 AS Libellé anglais#1620, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1598, ATC_codePere#1569 AS ATC_codePere#1609, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau code#1587, ATC_code#1568 AS ATC_code#1598, ATC_codePere#1569, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Project [Niveau+code#1567 AS Niveau code#1587, ATC_code#1568, ATC_codePere#1569, Libell%C3%A9+anglais#1570, Libell%C3%A9+fran%C3%A7ais#1571, Commentaires#1572, Cr%C3%A9ation#1573, Modification#1574, Inactivation#1575, 693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576]
+- Relation[Niveau+code#1567,ATC_code#1568,ATC_codePere#1569,Libell%C3%A9+anglais#1570,Libell%C3%A9+fran%C3%A7ais#1571,Commentaires#1572,Cr%C3%A9ation#1573,Modification#1574,Inactivation#1575,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576] parquet
== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
+- Project [Niveau+code#1567 AS COL_NIVEAU_CODE_2777#1817, ATC_code#1568 AS COL_ATC_CODE_2778#1818, ATC_codePere#1569 AS COL_ATC_CODEPERE_2779#1819, Libell%C3%A9+anglais#1570 AS COL_LIBELLE_ANGLAIS_2780#1820, Libell%C3%A9+fran%C3%A7ais#1571 AS COL_LIBELLE_FRANCAI_2781#1821, Commentaires#1572 AS COL_COMMENTAIRES_2782#1822, Cr%C3%A9ation#1573 AS COL_CREATION_2783#1823, Modification#1574 AS COL_MODIFICATION_2784#1824, Inactivation#1575 AS COL_INACTIVATION_2785#1825]
+- Relation[Niveau+code#1567,ATC_code#1568,ATC_codePere#1569,Libell%C3%A9+anglais#1570,Libell%C3%A9+fran%C3%A7ais#1571,Commentaires#1572,Cr%C3%A9ation#1573,Modification#1574,Inactivation#1575,693D1968_C0BA_4D71_AD27_BFE39CB5F506HEADER_COL_DETAIL_DEPOT#1576] parquet
== Physical Plan ==
CollectLimit 1500
+- *(1) Project [Niveau+code#1567 AS COL_NIVEAU_CODE_2777#1817, ATC_code#1568 AS COL_ATC_CODE_2778#1818, ATC_codePere#1569 AS COL_ATC_CODEPERE_2779#1819, Libell%C3%A9+anglais#1570 AS COL_LIBELLE_ANGLAIS_2780#1820, Libell%C3%A9+fran%C3%A7ais#1571 AS COL_LIBELLE_FRANCAI_2781#1821, Commentaires#1572 AS COL_COMMENTAIRES_2782#1822, Cr%C3%A9ation#1573 AS COL_CREATION_2783#1823, Modification#1574 AS COL_MODIFICATION_2784#1824, Inactivation#1575 AS COL_INACTIVATION_2785#1825]
+- *(1) ColumnarToRow
+- FileScan parquet [Niveau+code#1567,ATC_code#1568,ATC_codePere#1569,Libell%C3%A9+anglais#1570,Libell%C3%A9+fran%C3%A7ais#1571,Commentaires#1572,Cr%C3%A9ation#1573,Modification#1574,Inactivation#1575] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/excel/cache/693D1968_C0BA_4D71_AD27_BFE39CB5F506_993619b..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<Niveau+code:string,ATC_code:string,ATC_codePere:string,Libell%C3%A9+anglais:string,Libell%...