DC2 - Details for Query 139

Details for Query 139

Submitted Time: 2025/11/07 08:59:14
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569117`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45057 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45214, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45059 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45215, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45061 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45216, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45217, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45056 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45218, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45055 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45219, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45220, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45221, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45222, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45052 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45223, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45053 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45224, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45054 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45225, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45226, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45060 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45227, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45228, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45229, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45230, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45231, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45232, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45035 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45233, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45234, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45235, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45236, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45237, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44858 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45028, ANNEECATEGORIEE_24936#44859 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029, ANNEEEFFECTIFSU_24932#44860 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030, CARACTEREEMPLOY_24951#44861 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45031, CATEGORIEENTREP_24935#44862 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032, CATEGORIEJURIDI_24945#44863 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45033, DATECREATIONUNI_24921#44864 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034, DATEDEBUT_24937#44865 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45035, DATEDERNIERTRAI_24933#44866 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036, DENOMINATIONUNI_24941#44867 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037, DENOMINATIONUSU_24942#44868 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45038, DENOMINATIONUSU_24943#44869 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45039, DENOMINATIONUSU_24944#44870 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45040, ECONOMIESOCIALE_24949#44871 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45041, ETATADMINISTRAT_24938#44872 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042, IDENTIFIANTASSO_24930#44873 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043, NICSIEGEUNITELE_24948#44874 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45044, NOMBREPERIODESU_24934#44875 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045, NOMENCLATUREACT_24947#44876 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45046, NOMUNITELEGALE_24939#44877 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047, NOMUSAGEUNITELE_24940#44878 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048, PRENOM1UNITELEG_24924#44879 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049, PRENOM2UNITELEG_24925#44880 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050, PRENOM3UNITELEG_24926#44881 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917117
            +- Relation[ACTIVITEPRINCIP_24946#44858,ANNEECATEGORIEE_24936#44859,ANNEEEFFECTIFSU_24932#44860,CARACTEREEMPLOY_24951#44861,CATEGORIEENTREP_24935#44862,CATEGORIEJURIDI_24945#44863,DATECREATIONUNI_24921#44864,DATEDEBUT_24937#44865,DATEDERNIERTRAI_24933#44866,DENOMINATIONUNI_24941#44867,DENOMINATIONUSU_24942#44868,DENOMINATIONUSU_24943#44869,DENOMINATIONUSU_24944#44870,ECONOMIESOCIALE_24949#44871,ETATADMINISTRAT_24938#44872,IDENTIFIANTASSO_24930#44873,NICSIEGEUNITELE_24948#44874,NOMBREPERIODESU_24934#44875,NOMENCLATUREACT_24947#44876,NOMUNITELEGALE_24939#44877,NOMUSAGEUNITELE_24940#44878,PRENOM1UNITELEG_24924#44879,PRENOM2UNITELEG_24925#44880,PRENOM3UNITELEG_24926#44881,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569117`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45057 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45214, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45059 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45215, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45061 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45216, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45217, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45056 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45218, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45055 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45219, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45220, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45221, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45222, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45052 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45223, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45053 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45224, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45054 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45225, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45226, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45060 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45227, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45228, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45229, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45230, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45231, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45232, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45035 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45233, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45234, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45235, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45236, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45237, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44858 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45028, ANNEECATEGORIEE_24936#44859 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029, ANNEEEFFECTIFSU_24932#44860 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030, CARACTEREEMPLOY_24951#44861 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45031, CATEGORIEENTREP_24935#44862 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032, CATEGORIEJURIDI_24945#44863 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45033, DATECREATIONUNI_24921#44864 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034, DATEDEBUT_24937#44865 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45035, DATEDERNIERTRAI_24933#44866 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036, DENOMINATIONUNI_24941#44867 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037, DENOMINATIONUSU_24942#44868 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45038, DENOMINATIONUSU_24943#44869 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45039, DENOMINATIONUSU_24944#44870 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45040, ECONOMIESOCIALE_24949#44871 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45041, ETATADMINISTRAT_24938#44872 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042, IDENTIFIANTASSO_24930#44873 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043, NICSIEGEUNITELE_24948#44874 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45044, NOMBREPERIODESU_24934#44875 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045, NOMENCLATUREACT_24947#44876 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45046, NOMUNITELEGALE_24939#44877 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047, NOMUSAGEUNITELE_24940#44878 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048, PRENOM1UNITELEG_24924#44879 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049, PRENOM2UNITELEG_24925#44880 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050, PRENOM3UNITELEG_24926#44881 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917117
            +- Relation[ACTIVITEPRINCIP_24946#44858,ANNEECATEGORIEE_24936#44859,ANNEEEFFECTIFSU_24932#44860,CARACTEREEMPLOY_24951#44861,CATEGORIEENTREP_24935#44862,CATEGORIEJURIDI_24945#44863,DATECREATIONUNI_24921#44864,DATEDEBUT_24937#44865,DATEDERNIERTRAI_24933#44866,DENOMINATIONUNI_24941#44867,DENOMINATIONUSU_24942#44868,DENOMINATIONUSU_24943#44869,DENOMINATIONUSU_24944#44870,ECONOMIESOCIALE_24949#44871,ETATADMINISTRAT_24938#44872,IDENTIFIANTASSO_24930#44873,NICSIEGEUNITELE_24948#44874,NOMBREPERIODESU_24934#44875,NOMENCLATUREACT_24947#44876,NOMUNITELEGALE_24939#44877,NOMUSAGEUNITELE_24940#44878,PRENOM1UNITELEG_24924#44879,PRENOM2UNITELEG_24925#44880,PRENOM3UNITELEG_24926#44881,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569117`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45057 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45214, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45059 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45215, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45061 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45216, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45217, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45056 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45218, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45055 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45219, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45220, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45221, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45222, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45052 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45223, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45053 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45224, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45054 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45225, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45226, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45060 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45227, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45228, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45229, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45230, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45231, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45232, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45035 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45233, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45234, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45235, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45236, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45237, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44858 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45028, ANNEECATEGORIEE_24936#44859 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029, ANNEEEFFECTIFSU_24932#44860 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030, CARACTEREEMPLOY_24951#44861 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45031, CATEGORIEENTREP_24935#44862 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032, CATEGORIEJURIDI_24945#44863 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45033, DATECREATIONUNI_24921#44864 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034, DATEDEBUT_24937#44865 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45035, DATEDERNIERTRAI_24933#44866 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036, DENOMINATIONUNI_24941#44867 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037, DENOMINATIONUSU_24942#44868 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45038, DENOMINATIONUSU_24943#44869 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45039, DENOMINATIONUSU_24944#44870 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45040, ECONOMIESOCIALE_24949#44871 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45041, ETATADMINISTRAT_24938#44872 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042, IDENTIFIANTASSO_24930#44873 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043, NICSIEGEUNITELE_24948#44874 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45044, NOMBREPERIODESU_24934#44875 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045, NOMENCLATUREACT_24947#44876 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45046, NOMUNITELEGALE_24939#44877 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047, NOMUSAGEUNITELE_24940#44878 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048, PRENOM1UNITELEG_24924#44879 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049, PRENOM2UNITELEG_24925#44880 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050, PRENOM3UNITELEG_24926#44881 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917117
            +- Relation[ACTIVITEPRINCIP_24946#44858,ANNEECATEGORIEE_24936#44859,ANNEEEFFECTIFSU_24932#44860,CARACTEREEMPLOY_24951#44861,CATEGORIEENTREP_24935#44862,CATEGORIEJURIDI_24945#44863,DATECREATIONUNI_24921#44864,DATEDEBUT_24937#44865,DATEDERNIERTRAI_24933#44866,DENOMINATIONUNI_24941#44867,DENOMINATIONUSU_24942#44868,DENOMINATIONUSU_24943#44869,DENOMINATIONUSU_24944#44870,ECONOMIESOCIALE_24949#44871,ETATADMINISTRAT_24938#44872,IDENTIFIANTASSO_24930#44873,NICSIEGEUNITELE_24948#44874,NOMBREPERIODESU_24934#44875,NOMENCLATUREACT_24947#44876,NOMUNITELEGALE_24939#44877,NOMUSAGEUNITELE_24940#44878,PRENOM1UNITELEG_24924#44879,PRENOM2UNITELEG_24925#44880,PRENOM3UNITELEG_24926#44881,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569117`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45057 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45214, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45059 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45215, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45061 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45216, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45217, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45056 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45218, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45055 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45219, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45220, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45221, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45222, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45052 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45223, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45053 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45224, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45054 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45225, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45226, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45060 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45227, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45228, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45229, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45230, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45231, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45232, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45035 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45233, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45234, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45235, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45236, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45237, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#44858 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45028, ANNEECATEGORIEE_24936#44859 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45029, ANNEEEFFECTIFSU_24932#44860 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45030, CARACTEREEMPLOY_24951#44861 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45031, CATEGORIEENTREP_24935#44862 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45032, CATEGORIEJURIDI_24945#44863 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45033, DATECREATIONUNI_24921#44864 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45034, DATEDEBUT_24937#44865 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45035, DATEDERNIERTRAI_24933#44866 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45036, DENOMINATIONUNI_24941#44867 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45037, DENOMINATIONUSU_24942#44868 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45038, DENOMINATIONUSU_24943#44869 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45039, DENOMINATIONUSU_24944#44870 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45040, ECONOMIESOCIALE_24949#44871 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45041, ETATADMINISTRAT_24938#44872 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45042, IDENTIFIANTASSO_24930#44873 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45043, NICSIEGEUNITELE_24948#44874 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45044, NOMBREPERIODESU_24934#44875 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45045, NOMENCLATUREACT_24947#44876 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45046, NOMUNITELEGALE_24939#44877 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45047, NOMUSAGEUNITELE_24940#44878 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45048, PRENOM1UNITELEG_24924#44879 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45049, PRENOM2UNITELEG_24925#44880 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45050, PRENOM3UNITELEG_24926#44881 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45051, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917117
                  +- Relation[ACTIVITEPRINCIP_24946#44858,ANNEECATEGORIEE_24936#44859,ANNEEEFFECTIFSU_24932#44860,CARACTEREEMPLOY_24951#44861,CATEGORIEENTREP_24935#44862,CATEGORIEJURIDI_24945#44863,DATECREATIONUNI_24921#44864,DATEDEBUT_24937#44865,DATEDERNIERTRAI_24933#44866,DENOMINATIONUNI_24941#44867,DENOMINATIONUSU_24942#44868,DENOMINATIONUSU_24943#44869,DENOMINATIONUSU_24944#44870,ECONOMIESOCIALE_24949#44871,ETATADMINISTRAT_24938#44872,IDENTIFIANTASSO_24930#44873,NICSIEGEUNITELE_24948#44874,NOMBREPERIODESU_24934#44875,NOMENCLATUREACT_24947#44876,NOMUNITELEGALE_24939#44877,NOMUSAGEUNITELE_24940#44878,PRENOM1UNITELEG_24924#44879,PRENOM2UNITELEG_24925#44880,PRENOM3UNITELEG_24926#44881,... 10 more fields] parquet