DC2 - Details for Query 119

Details for Query 119

Submitted Time: 2025/11/07 08:58:49
Duration: 0 ms
Show the Stage ID and Task ID that corresponds to the max metric
Details
== Parsed Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569118`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#33501 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#33574, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#33503 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#33575, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#33505 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#33576, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#33577, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#33500 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#33578, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#33499 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#33579, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#33580, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#33581, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#33582, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#33496 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#33583, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#33497 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#33584, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#33498 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#33585, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#33586, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#33504 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#33587, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#33588, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#33589, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#33590, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#33591, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#33592, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#33479 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#33593, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#33594, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#33595, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#33596, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#33597, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#33370 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#33472, ANNEECATEGORIEE_24936#33371 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473, ANNEEEFFECTIFSU_24932#33372 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474, CARACTEREEMPLOY_24951#33373 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#33475, CATEGORIEENTREP_24935#33374 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476, CATEGORIEJURIDI_24945#33375 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#33477, DATECREATIONUNI_24921#33376 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478, DATEDEBUT_24937#33377 AS SIREN_LEGAL_24917_DATEDEBUT_24937#33479, DATEDERNIERTRAI_24933#33378 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480, DENOMINATIONUNI_24941#33379 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481, DENOMINATIONUSU_24942#33380 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#33482, DENOMINATIONUSU_24943#33381 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#33483, DENOMINATIONUSU_24944#33382 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#33484, ECONOMIESOCIALE_24949#33383 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#33485, ETATADMINISTRAT_24938#33384 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486, IDENTIFIANTASSO_24930#33385 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487, NICSIEGEUNITELE_24948#33386 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#33488, NOMBREPERIODESU_24934#33387 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489, NOMENCLATUREACT_24947#33388 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#33490, NOMUNITELEGALE_24939#33389 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491, NOMUSAGEUNITELE_24940#33390 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492, PRENOM1UNITELEG_24924#33391 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493, PRENOM2UNITELEG_24925#33392 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494, PRENOM3UNITELEG_24926#33393 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917118
            +- Relation[ACTIVITEPRINCIP_24946#33370,ANNEECATEGORIEE_24936#33371,ANNEEEFFECTIFSU_24932#33372,CARACTEREEMPLOY_24951#33373,CATEGORIEENTREP_24935#33374,CATEGORIEJURIDI_24945#33375,DATECREATIONUNI_24921#33376,DATEDEBUT_24937#33377,DATEDERNIERTRAI_24933#33378,DENOMINATIONUNI_24941#33379,DENOMINATIONUSU_24942#33380,DENOMINATIONUSU_24943#33381,DENOMINATIONUSU_24944#33382,ECONOMIESOCIALE_24949#33383,ETATADMINISTRAT_24938#33384,IDENTIFIANTASSO_24930#33385,NICSIEGEUNITELE_24948#33386,NOMBREPERIODESU_24934#33387,NOMENCLATUREACT_24947#33388,NOMUNITELEGALE_24939#33389,NOMUSAGEUNITELE_24940#33390,PRENOM1UNITELEG_24924#33391,PRENOM2UNITELEG_24925#33392,PRENOM3UNITELEG_24926#33393,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569118`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#33501 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#33574, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#33503 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#33575, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#33505 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#33576, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#33577, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#33500 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#33578, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#33499 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#33579, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#33580, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#33581, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#33582, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#33496 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#33583, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#33497 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#33584, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#33498 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#33585, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#33586, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#33504 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#33587, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#33588, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#33589, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#33590, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#33591, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#33592, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#33479 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#33593, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#33594, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#33595, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#33596, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#33597, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#33370 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#33472, ANNEECATEGORIEE_24936#33371 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473, ANNEEEFFECTIFSU_24932#33372 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474, CARACTEREEMPLOY_24951#33373 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#33475, CATEGORIEENTREP_24935#33374 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476, CATEGORIEJURIDI_24945#33375 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#33477, DATECREATIONUNI_24921#33376 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478, DATEDEBUT_24937#33377 AS SIREN_LEGAL_24917_DATEDEBUT_24937#33479, DATEDERNIERTRAI_24933#33378 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480, DENOMINATIONUNI_24941#33379 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481, DENOMINATIONUSU_24942#33380 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#33482, DENOMINATIONUSU_24943#33381 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#33483, DENOMINATIONUSU_24944#33382 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#33484, ECONOMIESOCIALE_24949#33383 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#33485, ETATADMINISTRAT_24938#33384 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486, IDENTIFIANTASSO_24930#33385 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487, NICSIEGEUNITELE_24948#33386 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#33488, NOMBREPERIODESU_24934#33387 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489, NOMENCLATUREACT_24947#33388 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#33490, NOMUNITELEGALE_24939#33389 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491, NOMUSAGEUNITELE_24940#33390 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492, PRENOM1UNITELEG_24924#33391 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493, PRENOM2UNITELEG_24925#33392 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494, PRENOM3UNITELEG_24926#33393 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917118
            +- Relation[ACTIVITEPRINCIP_24946#33370,ANNEECATEGORIEE_24936#33371,ANNEEEFFECTIFSU_24932#33372,CARACTEREEMPLOY_24951#33373,CATEGORIEENTREP_24935#33374,CATEGORIEJURIDI_24945#33375,DATECREATIONUNI_24921#33376,DATEDEBUT_24937#33377,DATEDERNIERTRAI_24933#33378,DENOMINATIONUNI_24941#33379,DENOMINATIONUSU_24942#33380,DENOMINATIONUSU_24943#33381,DENOMINATIONUSU_24944#33382,ECONOMIESOCIALE_24949#33383,ETATADMINISTRAT_24938#33384,IDENTIFIANTASSO_24930#33385,NICSIEGEUNITELE_24948#33386,NOMBREPERIODESU_24934#33387,NOMENCLATUREACT_24947#33388,NOMUNITELEGALE_24939#33389,NOMUSAGEUNITELE_24940#33390,PRENOM1UNITELEG_24924#33391,PRENOM2UNITELEG_24925#33392,PRENOM3UNITELEG_24926#33393,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569118`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#33501 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#33574, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#33503 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#33575, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#33505 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#33576, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#33577, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#33500 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#33578, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#33499 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#33579, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#33580, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#33581, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#33582, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#33496 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#33583, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#33497 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#33584, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#33498 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#33585, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#33586, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#33504 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#33587, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#33588, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#33589, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#33590, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#33591, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#33592, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#33479 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#33593, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#33594, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#33595, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#33596, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#33597, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#33370 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#33472, ANNEECATEGORIEE_24936#33371 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473, ANNEEEFFECTIFSU_24932#33372 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474, CARACTEREEMPLOY_24951#33373 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#33475, CATEGORIEENTREP_24935#33374 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476, CATEGORIEJURIDI_24945#33375 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#33477, DATECREATIONUNI_24921#33376 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478, DATEDEBUT_24937#33377 AS SIREN_LEGAL_24917_DATEDEBUT_24937#33479, DATEDERNIERTRAI_24933#33378 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480, DENOMINATIONUNI_24941#33379 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481, DENOMINATIONUSU_24942#33380 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#33482, DENOMINATIONUSU_24943#33381 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#33483, DENOMINATIONUSU_24944#33382 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#33484, ECONOMIESOCIALE_24949#33383 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#33485, ETATADMINISTRAT_24938#33384 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486, IDENTIFIANTASSO_24930#33385 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487, NICSIEGEUNITELE_24948#33386 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#33488, NOMBREPERIODESU_24934#33387 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489, NOMENCLATUREACT_24947#33388 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#33490, NOMUNITELEGALE_24939#33389 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491, NOMUSAGEUNITELE_24940#33390 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492, PRENOM1UNITELEG_24924#33391 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493, PRENOM2UNITELEG_24925#33392 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494, PRENOM3UNITELEG_24926#33393 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917118
            +- Relation[ACTIVITEPRINCIP_24946#33370,ANNEECATEGORIEE_24936#33371,ANNEEEFFECTIFSU_24932#33372,CARACTEREEMPLOY_24951#33373,CATEGORIEENTREP_24935#33374,CATEGORIEJURIDI_24945#33375,DATECREATIONUNI_24921#33376,DATEDEBUT_24937#33377,DATEDERNIERTRAI_24933#33378,DENOMINATIONUNI_24941#33379,DENOMINATIONUSU_24942#33380,DENOMINATIONUSU_24943#33381,DENOMINATIONUSU_24944#33382,ECONOMIESOCIALE_24949#33383,ETATADMINISTRAT_24938#33384,IDENTIFIANTASSO_24930#33385,NICSIEGEUNITELE_24948#33386,NOMBREPERIODESU_24934#33387,NOMENCLATUREACT_24947#33388,NOMUNITELEGALE_24939#33389,NOMUSAGEUNITELE_24940#33390,PRENOM1UNITELEG_24924#33391,PRENOM2UNITELEG_24925#33392,PRENOM3UNITELEG_24926#33393,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569118`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#33501 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#33574, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#33503 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#33575, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#33505 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#33576, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#33577, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#33500 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#33578, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#33499 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#33579, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#33580, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#33581, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#33582, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#33496 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#33583, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#33497 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#33584, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#33498 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#33585, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#33586, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#33504 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#33587, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#33588, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#33589, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#33590, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#33591, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#33592, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#33479 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#33593, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#33594, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#33595, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#33596, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#33597, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#33370 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#33472, ANNEECATEGORIEE_24936#33371 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#33473, ANNEEEFFECTIFSU_24932#33372 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#33474, CARACTEREEMPLOY_24951#33373 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#33475, CATEGORIEENTREP_24935#33374 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#33476, CATEGORIEJURIDI_24945#33375 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#33477, DATECREATIONUNI_24921#33376 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#33478, DATEDEBUT_24937#33377 AS SIREN_LEGAL_24917_DATEDEBUT_24937#33479, DATEDERNIERTRAI_24933#33378 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#33480, DENOMINATIONUNI_24941#33379 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#33481, DENOMINATIONUSU_24942#33380 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#33482, DENOMINATIONUSU_24943#33381 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#33483, DENOMINATIONUSU_24944#33382 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#33484, ECONOMIESOCIALE_24949#33383 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#33485, ETATADMINISTRAT_24938#33384 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#33486, IDENTIFIANTASSO_24930#33385 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#33487, NICSIEGEUNITELE_24948#33386 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#33488, NOMBREPERIODESU_24934#33387 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#33489, NOMENCLATUREACT_24947#33388 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#33490, NOMUNITELEGALE_24939#33389 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#33491, NOMUSAGEUNITELE_24940#33390 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#33492, PRENOM1UNITELEG_24924#33391 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#33493, PRENOM2UNITELEG_24925#33392 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#33494, PRENOM3UNITELEG_24926#33393 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#33495, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917118
                  +- Relation[ACTIVITEPRINCIP_24946#33370,ANNEECATEGORIEE_24936#33371,ANNEEEFFECTIFSU_24932#33372,CARACTEREEMPLOY_24951#33373,CATEGORIEENTREP_24935#33374,CATEGORIEJURIDI_24945#33375,DATECREATIONUNI_24921#33376,DATEDEBUT_24937#33377,DATEDERNIERTRAI_24933#33378,DENOMINATIONUNI_24941#33379,DENOMINATIONUSU_24942#33380,DENOMINATIONUSU_24943#33381,DENOMINATIONUSU_24944#33382,ECONOMIESOCIALE_24949#33383,ETATADMINISTRAT_24938#33384,IDENTIFIANTASSO_24930#33385,NICSIEGEUNITELE_24948#33386,NOMBREPERIODESU_24934#33387,NOMENCLATUREACT_24947#33388,NOMUNITELEGALE_24939#33389,NOMUSAGEUNITELE_24940#33390,PRENOM1UNITELEG_24924#33391,PRENOM2UNITELEG_24925#33392,PRENOM3UNITELEG_24926#33393,... 10 more fields] parquet