DC2 - Details for Query 140

Details for Query 140

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_29569115`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45209 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45351, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45211 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45352, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45213 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45353, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45354, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45208 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45355, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45207 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45356, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45357, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45358, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45359, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45204 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45360, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45205 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45361, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45206 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45362, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45363, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45212 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45364, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45365, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45366, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45367, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45368, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45369, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45187 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45370, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45371, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45372, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45373, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45374, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44926 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45180, ANNEECATEGORIEE_24936#44927 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181, ANNEEEFFECTIFSU_24932#44928 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182, CARACTEREEMPLOY_24951#44929 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45183, CATEGORIEENTREP_24935#44930 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184, CATEGORIEJURIDI_24945#44931 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45185, DATECREATIONUNI_24921#44932 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186, DATEDEBUT_24937#44933 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45187, DATEDERNIERTRAI_24933#44934 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188, DENOMINATIONUNI_24941#44935 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189, DENOMINATIONUSU_24942#44936 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45190, DENOMINATIONUSU_24943#44937 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45191, DENOMINATIONUSU_24944#44938 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45192, ECONOMIESOCIALE_24949#44939 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45193, ETATADMINISTRAT_24938#44940 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194, IDENTIFIANTASSO_24930#44941 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195, NICSIEGEUNITELE_24948#44942 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45196, NOMBREPERIODESU_24934#44943 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197, NOMENCLATUREACT_24947#44944 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45198, NOMUNITELEGALE_24939#44945 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199, NOMUSAGEUNITELE_24940#44946 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200, PRENOM1UNITELEG_24924#44947 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201, PRENOM2UNITELEG_24925#44948 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202, PRENOM3UNITELEG_24926#44949 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#44926,ANNEECATEGORIEE_24936#44927,ANNEEEFFECTIFSU_24932#44928,CARACTEREEMPLOY_24951#44929,CATEGORIEENTREP_24935#44930,CATEGORIEJURIDI_24945#44931,DATECREATIONUNI_24921#44932,DATEDEBUT_24937#44933,DATEDERNIERTRAI_24933#44934,DENOMINATIONUNI_24941#44935,DENOMINATIONUSU_24942#44936,DENOMINATIONUSU_24943#44937,DENOMINATIONUSU_24944#44938,ECONOMIESOCIALE_24949#44939,ETATADMINISTRAT_24938#44940,IDENTIFIANTASSO_24930#44941,NICSIEGEUNITELE_24948#44942,NOMBREPERIODESU_24934#44943,NOMENCLATUREACT_24947#44944,NOMUNITELEGALE_24939#44945,NOMUSAGEUNITELE_24940#44946,PRENOM1UNITELEG_24924#44947,PRENOM2UNITELEG_24925#44948,PRENOM3UNITELEG_24926#44949,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45209 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45351, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45211 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45352, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45213 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45353, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45354, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45208 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45355, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45207 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45356, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45357, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45358, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45359, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45204 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45360, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45205 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45361, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45206 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45362, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45363, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45212 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45364, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45365, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45366, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45367, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45368, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45369, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45187 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45370, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45371, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45372, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45373, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45374, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44926 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45180, ANNEECATEGORIEE_24936#44927 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181, ANNEEEFFECTIFSU_24932#44928 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182, CARACTEREEMPLOY_24951#44929 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45183, CATEGORIEENTREP_24935#44930 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184, CATEGORIEJURIDI_24945#44931 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45185, DATECREATIONUNI_24921#44932 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186, DATEDEBUT_24937#44933 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45187, DATEDERNIERTRAI_24933#44934 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188, DENOMINATIONUNI_24941#44935 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189, DENOMINATIONUSU_24942#44936 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45190, DENOMINATIONUSU_24943#44937 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45191, DENOMINATIONUSU_24944#44938 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45192, ECONOMIESOCIALE_24949#44939 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45193, ETATADMINISTRAT_24938#44940 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194, IDENTIFIANTASSO_24930#44941 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195, NICSIEGEUNITELE_24948#44942 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45196, NOMBREPERIODESU_24934#44943 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197, NOMENCLATUREACT_24947#44944 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45198, NOMUNITELEGALE_24939#44945 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199, NOMUSAGEUNITELE_24940#44946 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200, PRENOM1UNITELEG_24924#44947 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201, PRENOM2UNITELEG_24925#44948 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202, PRENOM3UNITELEG_24926#44949 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#44926,ANNEECATEGORIEE_24936#44927,ANNEEEFFECTIFSU_24932#44928,CARACTEREEMPLOY_24951#44929,CATEGORIEENTREP_24935#44930,CATEGORIEJURIDI_24945#44931,DATECREATIONUNI_24921#44932,DATEDEBUT_24937#44933,DATEDERNIERTRAI_24933#44934,DENOMINATIONUNI_24941#44935,DENOMINATIONUSU_24942#44936,DENOMINATIONUSU_24943#44937,DENOMINATIONUSU_24944#44938,ECONOMIESOCIALE_24949#44939,ETATADMINISTRAT_24938#44940,IDENTIFIANTASSO_24930#44941,NICSIEGEUNITELE_24948#44942,NOMBREPERIODESU_24934#44943,NOMENCLATUREACT_24947#44944,NOMUNITELEGALE_24939#44945,NOMUSAGEUNITELE_24940#44946,PRENOM1UNITELEG_24924#44947,PRENOM2UNITELEG_24925#44948,PRENOM3UNITELEG_24926#44949,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45209 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45351, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45211 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45352, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45213 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45353, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45354, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45208 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45355, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45207 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45356, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45357, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45358, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45359, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45204 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45360, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45205 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45361, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45206 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45362, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45363, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45212 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45364, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45365, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45366, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45367, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45368, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45369, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45187 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45370, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45371, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45372, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45373, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45374, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#44926 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45180, ANNEECATEGORIEE_24936#44927 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181, ANNEEEFFECTIFSU_24932#44928 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182, CARACTEREEMPLOY_24951#44929 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45183, CATEGORIEENTREP_24935#44930 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184, CATEGORIEJURIDI_24945#44931 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45185, DATECREATIONUNI_24921#44932 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186, DATEDEBUT_24937#44933 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45187, DATEDERNIERTRAI_24933#44934 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188, DENOMINATIONUNI_24941#44935 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189, DENOMINATIONUSU_24942#44936 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45190, DENOMINATIONUSU_24943#44937 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45191, DENOMINATIONUSU_24944#44938 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45192, ECONOMIESOCIALE_24949#44939 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45193, ETATADMINISTRAT_24938#44940 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194, IDENTIFIANTASSO_24930#44941 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195, NICSIEGEUNITELE_24948#44942 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45196, NOMBREPERIODESU_24934#44943 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197, NOMENCLATUREACT_24947#44944 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45198, NOMUNITELEGALE_24939#44945 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199, NOMUSAGEUNITELE_24940#44946 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200, PRENOM1UNITELEG_24924#44947 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201, PRENOM2UNITELEG_24925#44948 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202, PRENOM3UNITELEG_24926#44949 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#44926,ANNEECATEGORIEE_24936#44927,ANNEEEFFECTIFSU_24932#44928,CARACTEREEMPLOY_24951#44929,CATEGORIEENTREP_24935#44930,CATEGORIEJURIDI_24945#44931,DATECREATIONUNI_24921#44932,DATEDEBUT_24937#44933,DATEDERNIERTRAI_24933#44934,DENOMINATIONUNI_24941#44935,DENOMINATIONUSU_24942#44936,DENOMINATIONUSU_24943#44937,DENOMINATIONUSU_24944#44938,ECONOMIESOCIALE_24949#44939,ETATADMINISTRAT_24938#44940,IDENTIFIANTASSO_24930#44941,NICSIEGEUNITELE_24948#44942,NOMBREPERIODESU_24934#44943,NOMENCLATUREACT_24947#44944,NOMUNITELEGALE_24939#44945,NOMUSAGEUNITELE_24940#44946,PRENOM1UNITELEG_24924#44947,PRENOM2UNITELEG_24925#44948,PRENOM3UNITELEG_24926#44949,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45209 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45351, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45211 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45352, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45213 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45353, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45354, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45208 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45355, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45207 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45356, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45357, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45358, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45359, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45204 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45360, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45205 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45361, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45206 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45362, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45363, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45212 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45364, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45365, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45366, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45367, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45368, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45369, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45187 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45370, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45371, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45372, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45373, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45374, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#44926 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45180, ANNEECATEGORIEE_24936#44927 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45181, ANNEEEFFECTIFSU_24932#44928 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45182, CARACTEREEMPLOY_24951#44929 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45183, CATEGORIEENTREP_24935#44930 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45184, CATEGORIEJURIDI_24945#44931 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45185, DATECREATIONUNI_24921#44932 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45186, DATEDEBUT_24937#44933 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45187, DATEDERNIERTRAI_24933#44934 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45188, DENOMINATIONUNI_24941#44935 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45189, DENOMINATIONUSU_24942#44936 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45190, DENOMINATIONUSU_24943#44937 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45191, DENOMINATIONUSU_24944#44938 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45192, ECONOMIESOCIALE_24949#44939 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45193, ETATADMINISTRAT_24938#44940 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45194, IDENTIFIANTASSO_24930#44941 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45195, NICSIEGEUNITELE_24948#44942 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45196, NOMBREPERIODESU_24934#44943 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45197, NOMENCLATUREACT_24947#44944 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45198, NOMUNITELEGALE_24939#44945 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45199, NOMUSAGEUNITELE_24940#44946 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45200, PRENOM1UNITELEG_24924#44947 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45201, PRENOM2UNITELEG_24925#44948 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45202, PRENOM3UNITELEG_24926#44949 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45203, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917115
                  +- Relation[ACTIVITEPRINCIP_24946#44926,ANNEECATEGORIEE_24936#44927,ANNEEEFFECTIFSU_24932#44928,CARACTEREEMPLOY_24951#44929,CATEGORIEENTREP_24935#44930,CATEGORIEJURIDI_24945#44931,DATECREATIONUNI_24921#44932,DATEDEBUT_24937#44933,DATEDERNIERTRAI_24933#44934,DENOMINATIONUNI_24941#44935,DENOMINATIONUSU_24942#44936,DENOMINATIONUSU_24943#44937,DENOMINATIONUSU_24944#44938,ECONOMIESOCIALE_24949#44939,ETATADMINISTRAT_24938#44940,IDENTIFIANTASSO_24930#44941,NICSIEGEUNITELE_24948#44942,NOMBREPERIODESU_24934#44943,NOMENCLATUREACT_24947#44944,NOMUNITELEGALE_24939#44945,NOMUSAGEUNITELE_24940#44946,PRENOM1UNITELEG_24924#44947,PRENOM2UNITELEG_24925#44948,PRENOM3UNITELEG_24926#44949,... 10 more fields] parquet