DC2 - Details for Query 157

Details for Query 157

Submitted Time: 2025/11/07 08:59:15
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569116`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#51539 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#51760, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#51541 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#51761, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#51543 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#51762, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#51763, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#51538 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#51764, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#51537 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#51765, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#51766, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#51767, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#51768, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#51534 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#51769, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#51535 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#51770, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#51536 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#51771, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#51772, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#51542 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#51773, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#51774, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#51775, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#51776, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#51777, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#51778, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#51517 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#51779, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#51780, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#51781, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#51782, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#51783, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#51332 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#51510, ANNEECATEGORIEE_24936#51333 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511, ANNEEEFFECTIFSU_24932#51334 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512, CARACTEREEMPLOY_24951#51335 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#51513, CATEGORIEENTREP_24935#51336 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514, CATEGORIEJURIDI_24945#51337 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#51515, DATECREATIONUNI_24921#51338 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516, DATEDEBUT_24937#51339 AS SIREN_LEGAL_24917_DATEDEBUT_24937#51517, DATEDERNIERTRAI_24933#51340 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518, DENOMINATIONUNI_24941#51341 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519, DENOMINATIONUSU_24942#51342 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#51520, DENOMINATIONUSU_24943#51343 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#51521, DENOMINATIONUSU_24944#51344 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#51522, ECONOMIESOCIALE_24949#51345 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#51523, ETATADMINISTRAT_24938#51346 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524, IDENTIFIANTASSO_24930#51347 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525, NICSIEGEUNITELE_24948#51348 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#51526, NOMBREPERIODESU_24934#51349 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527, NOMENCLATUREACT_24947#51350 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#51528, NOMUNITELEGALE_24939#51351 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529, NOMUSAGEUNITELE_24940#51352 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530, PRENOM1UNITELEG_24924#51353 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531, PRENOM2UNITELEG_24925#51354 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532, PRENOM3UNITELEG_24926#51355 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917116
            +- Relation[ACTIVITEPRINCIP_24946#51332,ANNEECATEGORIEE_24936#51333,ANNEEEFFECTIFSU_24932#51334,CARACTEREEMPLOY_24951#51335,CATEGORIEENTREP_24935#51336,CATEGORIEJURIDI_24945#51337,DATECREATIONUNI_24921#51338,DATEDEBUT_24937#51339,DATEDERNIERTRAI_24933#51340,DENOMINATIONUNI_24941#51341,DENOMINATIONUSU_24942#51342,DENOMINATIONUSU_24943#51343,DENOMINATIONUSU_24944#51344,ECONOMIESOCIALE_24949#51345,ETATADMINISTRAT_24938#51346,IDENTIFIANTASSO_24930#51347,NICSIEGEUNITELE_24948#51348,NOMBREPERIODESU_24934#51349,NOMENCLATUREACT_24947#51350,NOMUNITELEGALE_24939#51351,NOMUSAGEUNITELE_24940#51352,PRENOM1UNITELEG_24924#51353,PRENOM2UNITELEG_24925#51354,PRENOM3UNITELEG_24926#51355,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569116`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#51539 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#51760, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#51541 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#51761, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#51543 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#51762, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#51763, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#51538 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#51764, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#51537 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#51765, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#51766, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#51767, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#51768, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#51534 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#51769, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#51535 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#51770, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#51536 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#51771, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#51772, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#51542 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#51773, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#51774, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#51775, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#51776, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#51777, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#51778, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#51517 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#51779, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#51780, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#51781, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#51782, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#51783, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#51332 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#51510, ANNEECATEGORIEE_24936#51333 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511, ANNEEEFFECTIFSU_24932#51334 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512, CARACTEREEMPLOY_24951#51335 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#51513, CATEGORIEENTREP_24935#51336 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514, CATEGORIEJURIDI_24945#51337 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#51515, DATECREATIONUNI_24921#51338 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516, DATEDEBUT_24937#51339 AS SIREN_LEGAL_24917_DATEDEBUT_24937#51517, DATEDERNIERTRAI_24933#51340 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518, DENOMINATIONUNI_24941#51341 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519, DENOMINATIONUSU_24942#51342 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#51520, DENOMINATIONUSU_24943#51343 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#51521, DENOMINATIONUSU_24944#51344 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#51522, ECONOMIESOCIALE_24949#51345 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#51523, ETATADMINISTRAT_24938#51346 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524, IDENTIFIANTASSO_24930#51347 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525, NICSIEGEUNITELE_24948#51348 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#51526, NOMBREPERIODESU_24934#51349 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527, NOMENCLATUREACT_24947#51350 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#51528, NOMUNITELEGALE_24939#51351 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529, NOMUSAGEUNITELE_24940#51352 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530, PRENOM1UNITELEG_24924#51353 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531, PRENOM2UNITELEG_24925#51354 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532, PRENOM3UNITELEG_24926#51355 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917116
            +- Relation[ACTIVITEPRINCIP_24946#51332,ANNEECATEGORIEE_24936#51333,ANNEEEFFECTIFSU_24932#51334,CARACTEREEMPLOY_24951#51335,CATEGORIEENTREP_24935#51336,CATEGORIEJURIDI_24945#51337,DATECREATIONUNI_24921#51338,DATEDEBUT_24937#51339,DATEDERNIERTRAI_24933#51340,DENOMINATIONUNI_24941#51341,DENOMINATIONUSU_24942#51342,DENOMINATIONUSU_24943#51343,DENOMINATIONUSU_24944#51344,ECONOMIESOCIALE_24949#51345,ETATADMINISTRAT_24938#51346,IDENTIFIANTASSO_24930#51347,NICSIEGEUNITELE_24948#51348,NOMBREPERIODESU_24934#51349,NOMENCLATUREACT_24947#51350,NOMUNITELEGALE_24939#51351,NOMUSAGEUNITELE_24940#51352,PRENOM1UNITELEG_24924#51353,PRENOM2UNITELEG_24925#51354,PRENOM3UNITELEG_24926#51355,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569116`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#51539 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#51760, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#51541 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#51761, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#51543 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#51762, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#51763, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#51538 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#51764, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#51537 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#51765, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#51766, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#51767, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#51768, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#51534 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#51769, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#51535 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#51770, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#51536 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#51771, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#51772, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#51542 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#51773, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#51774, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#51775, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#51776, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#51777, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#51778, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#51517 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#51779, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#51780, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#51781, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#51782, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#51783, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#51332 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#51510, ANNEECATEGORIEE_24936#51333 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511, ANNEEEFFECTIFSU_24932#51334 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512, CARACTEREEMPLOY_24951#51335 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#51513, CATEGORIEENTREP_24935#51336 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514, CATEGORIEJURIDI_24945#51337 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#51515, DATECREATIONUNI_24921#51338 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516, DATEDEBUT_24937#51339 AS SIREN_LEGAL_24917_DATEDEBUT_24937#51517, DATEDERNIERTRAI_24933#51340 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518, DENOMINATIONUNI_24941#51341 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519, DENOMINATIONUSU_24942#51342 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#51520, DENOMINATIONUSU_24943#51343 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#51521, DENOMINATIONUSU_24944#51344 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#51522, ECONOMIESOCIALE_24949#51345 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#51523, ETATADMINISTRAT_24938#51346 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524, IDENTIFIANTASSO_24930#51347 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525, NICSIEGEUNITELE_24948#51348 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#51526, NOMBREPERIODESU_24934#51349 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527, NOMENCLATUREACT_24947#51350 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#51528, NOMUNITELEGALE_24939#51351 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529, NOMUSAGEUNITELE_24940#51352 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530, PRENOM1UNITELEG_24924#51353 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531, PRENOM2UNITELEG_24925#51354 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532, PRENOM3UNITELEG_24926#51355 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917116
            +- Relation[ACTIVITEPRINCIP_24946#51332,ANNEECATEGORIEE_24936#51333,ANNEEEFFECTIFSU_24932#51334,CARACTEREEMPLOY_24951#51335,CATEGORIEENTREP_24935#51336,CATEGORIEJURIDI_24945#51337,DATECREATIONUNI_24921#51338,DATEDEBUT_24937#51339,DATEDERNIERTRAI_24933#51340,DENOMINATIONUNI_24941#51341,DENOMINATIONUSU_24942#51342,DENOMINATIONUSU_24943#51343,DENOMINATIONUSU_24944#51344,ECONOMIESOCIALE_24949#51345,ETATADMINISTRAT_24938#51346,IDENTIFIANTASSO_24930#51347,NICSIEGEUNITELE_24948#51348,NOMBREPERIODESU_24934#51349,NOMENCLATUREACT_24947#51350,NOMUNITELEGALE_24939#51351,NOMUSAGEUNITELE_24940#51352,PRENOM1UNITELEG_24924#51353,PRENOM2UNITELEG_24925#51354,PRENOM3UNITELEG_24926#51355,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569116`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#51539 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#51760, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#51541 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#51761, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#51543 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#51762, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#51763, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#51538 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#51764, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#51537 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#51765, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#51766, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#51767, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#51768, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#51534 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#51769, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#51535 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#51770, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#51536 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#51771, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#51772, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#51542 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#51773, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#51774, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#51775, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#51776, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#51777, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#51778, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#51517 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#51779, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#51780, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#51781, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#51782, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#51783, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#51332 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#51510, ANNEECATEGORIEE_24936#51333 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#51511, ANNEEEFFECTIFSU_24932#51334 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#51512, CARACTEREEMPLOY_24951#51335 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#51513, CATEGORIEENTREP_24935#51336 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#51514, CATEGORIEJURIDI_24945#51337 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#51515, DATECREATIONUNI_24921#51338 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#51516, DATEDEBUT_24937#51339 AS SIREN_LEGAL_24917_DATEDEBUT_24937#51517, DATEDERNIERTRAI_24933#51340 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#51518, DENOMINATIONUNI_24941#51341 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#51519, DENOMINATIONUSU_24942#51342 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#51520, DENOMINATIONUSU_24943#51343 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#51521, DENOMINATIONUSU_24944#51344 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#51522, ECONOMIESOCIALE_24949#51345 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#51523, ETATADMINISTRAT_24938#51346 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#51524, IDENTIFIANTASSO_24930#51347 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#51525, NICSIEGEUNITELE_24948#51348 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#51526, NOMBREPERIODESU_24934#51349 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#51527, NOMENCLATUREACT_24947#51350 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#51528, NOMUNITELEGALE_24939#51351 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#51529, NOMUSAGEUNITELE_24940#51352 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#51530, PRENOM1UNITELEG_24924#51353 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#51531, PRENOM2UNITELEG_24925#51354 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#51532, PRENOM3UNITELEG_24926#51355 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#51533, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917116
                  +- Relation[ACTIVITEPRINCIP_24946#51332,ANNEECATEGORIEE_24936#51333,ANNEEEFFECTIFSU_24932#51334,CARACTEREEMPLOY_24951#51335,CATEGORIEENTREP_24935#51336,CATEGORIEJURIDI_24945#51337,DATECREATIONUNI_24921#51338,DATEDEBUT_24937#51339,DATEDERNIERTRAI_24933#51340,DENOMINATIONUNI_24941#51341,DENOMINATIONUSU_24942#51342,DENOMINATIONUSU_24943#51343,DENOMINATIONUSU_24944#51344,ECONOMIESOCIALE_24949#51345,ETATADMINISTRAT_24938#51346,IDENTIFIANTASSO_24930#51347,NICSIEGEUNITELE_24948#51348,NOMBREPERIODESU_24934#51349,NOMENCLATUREACT_24947#51350,NOMUNITELEGALE_24939#51351,NOMUSAGEUNITELE_24940#51352,PRENOM1UNITELEG_24924#51353,PRENOM2UNITELEG_24925#51354,PRENOM3UNITELEG_24926#51355,... 10 more fields] parquet