DC2 - Details for Query 142

Details for Query 142

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_29569114`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45607 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45755, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45609 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45756, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45611 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45757, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45758, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45606 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45759, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45605 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45760, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45761, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45762, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45763, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45602 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45764, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45603 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45765, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45604 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45766, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45767, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45610 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45768, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45769, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45770, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45771, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45772, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45773, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45585 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45774, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45775, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45776, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45777, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45778, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#45437 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45578, ANNEECATEGORIEE_24936#45438 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579, ANNEEEFFECTIFSU_24932#45439 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580, CARACTEREEMPLOY_24951#45440 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45581, CATEGORIEENTREP_24935#45441 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582, CATEGORIEJURIDI_24945#45442 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45583, DATECREATIONUNI_24921#45443 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584, DATEDEBUT_24937#45444 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45585, DATEDERNIERTRAI_24933#45445 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586, DENOMINATIONUNI_24941#45446 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587, DENOMINATIONUSU_24942#45447 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45588, DENOMINATIONUSU_24943#45448 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45589, DENOMINATIONUSU_24944#45449 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45590, ECONOMIESOCIALE_24949#45450 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45591, ETATADMINISTRAT_24938#45451 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592, IDENTIFIANTASSO_24930#45452 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593, NICSIEGEUNITELE_24948#45453 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45594, NOMBREPERIODESU_24934#45454 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595, NOMENCLATUREACT_24947#45455 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45596, NOMUNITELEGALE_24939#45456 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597, NOMUSAGEUNITELE_24940#45457 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598, PRENOM1UNITELEG_24924#45458 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599, PRENOM2UNITELEG_24925#45459 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600, PRENOM3UNITELEG_24926#45460 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917114
            +- Relation[ACTIVITEPRINCIP_24946#45437,ANNEECATEGORIEE_24936#45438,ANNEEEFFECTIFSU_24932#45439,CARACTEREEMPLOY_24951#45440,CATEGORIEENTREP_24935#45441,CATEGORIEJURIDI_24945#45442,DATECREATIONUNI_24921#45443,DATEDEBUT_24937#45444,DATEDERNIERTRAI_24933#45445,DENOMINATIONUNI_24941#45446,DENOMINATIONUSU_24942#45447,DENOMINATIONUSU_24943#45448,DENOMINATIONUSU_24944#45449,ECONOMIESOCIALE_24949#45450,ETATADMINISTRAT_24938#45451,IDENTIFIANTASSO_24930#45452,NICSIEGEUNITELE_24948#45453,NOMBREPERIODESU_24934#45454,NOMENCLATUREACT_24947#45455,NOMUNITELEGALE_24939#45456,NOMUSAGEUNITELE_24940#45457,PRENOM1UNITELEG_24924#45458,PRENOM2UNITELEG_24925#45459,PRENOM3UNITELEG_24926#45460,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569114`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45607 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45755, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45609 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45756, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45611 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45757, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45758, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45606 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45759, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45605 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45760, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45761, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45762, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45763, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45602 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45764, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45603 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45765, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45604 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45766, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45767, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45610 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45768, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45769, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45770, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45771, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45772, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45773, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45585 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45774, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45775, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45776, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45777, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45778, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#45437 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45578, ANNEECATEGORIEE_24936#45438 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579, ANNEEEFFECTIFSU_24932#45439 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580, CARACTEREEMPLOY_24951#45440 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45581, CATEGORIEENTREP_24935#45441 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582, CATEGORIEJURIDI_24945#45442 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45583, DATECREATIONUNI_24921#45443 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584, DATEDEBUT_24937#45444 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45585, DATEDERNIERTRAI_24933#45445 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586, DENOMINATIONUNI_24941#45446 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587, DENOMINATIONUSU_24942#45447 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45588, DENOMINATIONUSU_24943#45448 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45589, DENOMINATIONUSU_24944#45449 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45590, ECONOMIESOCIALE_24949#45450 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45591, ETATADMINISTRAT_24938#45451 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592, IDENTIFIANTASSO_24930#45452 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593, NICSIEGEUNITELE_24948#45453 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45594, NOMBREPERIODESU_24934#45454 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595, NOMENCLATUREACT_24947#45455 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45596, NOMUNITELEGALE_24939#45456 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597, NOMUSAGEUNITELE_24940#45457 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598, PRENOM1UNITELEG_24924#45458 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599, PRENOM2UNITELEG_24925#45459 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600, PRENOM3UNITELEG_24926#45460 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917114
            +- Relation[ACTIVITEPRINCIP_24946#45437,ANNEECATEGORIEE_24936#45438,ANNEEEFFECTIFSU_24932#45439,CARACTEREEMPLOY_24951#45440,CATEGORIEENTREP_24935#45441,CATEGORIEJURIDI_24945#45442,DATECREATIONUNI_24921#45443,DATEDEBUT_24937#45444,DATEDERNIERTRAI_24933#45445,DENOMINATIONUNI_24941#45446,DENOMINATIONUSU_24942#45447,DENOMINATIONUSU_24943#45448,DENOMINATIONUSU_24944#45449,ECONOMIESOCIALE_24949#45450,ETATADMINISTRAT_24938#45451,IDENTIFIANTASSO_24930#45452,NICSIEGEUNITELE_24948#45453,NOMBREPERIODESU_24934#45454,NOMENCLATUREACT_24947#45455,NOMUNITELEGALE_24939#45456,NOMUSAGEUNITELE_24940#45457,PRENOM1UNITELEG_24924#45458,PRENOM2UNITELEG_24925#45459,PRENOM3UNITELEG_24926#45460,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569114`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45607 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45755, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45609 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45756, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45611 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45757, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45758, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45606 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45759, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45605 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45760, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45761, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45762, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45763, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45602 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45764, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45603 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45765, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45604 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45766, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45767, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45610 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45768, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45769, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45770, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45771, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45772, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45773, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45585 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45774, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45775, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45776, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45777, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45778, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#45437 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45578, ANNEECATEGORIEE_24936#45438 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579, ANNEEEFFECTIFSU_24932#45439 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580, CARACTEREEMPLOY_24951#45440 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45581, CATEGORIEENTREP_24935#45441 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582, CATEGORIEJURIDI_24945#45442 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45583, DATECREATIONUNI_24921#45443 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584, DATEDEBUT_24937#45444 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45585, DATEDERNIERTRAI_24933#45445 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586, DENOMINATIONUNI_24941#45446 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587, DENOMINATIONUSU_24942#45447 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45588, DENOMINATIONUSU_24943#45448 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45589, DENOMINATIONUSU_24944#45449 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45590, ECONOMIESOCIALE_24949#45450 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45591, ETATADMINISTRAT_24938#45451 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592, IDENTIFIANTASSO_24930#45452 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593, NICSIEGEUNITELE_24948#45453 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45594, NOMBREPERIODESU_24934#45454 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595, NOMENCLATUREACT_24947#45455 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45596, NOMUNITELEGALE_24939#45456 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597, NOMUSAGEUNITELE_24940#45457 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598, PRENOM1UNITELEG_24924#45458 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599, PRENOM2UNITELEG_24925#45459 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600, PRENOM3UNITELEG_24926#45460 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917114
            +- Relation[ACTIVITEPRINCIP_24946#45437,ANNEECATEGORIEE_24936#45438,ANNEEEFFECTIFSU_24932#45439,CARACTEREEMPLOY_24951#45440,CATEGORIEENTREP_24935#45441,CATEGORIEJURIDI_24945#45442,DATECREATIONUNI_24921#45443,DATEDEBUT_24937#45444,DATEDERNIERTRAI_24933#45445,DENOMINATIONUNI_24941#45446,DENOMINATIONUSU_24942#45447,DENOMINATIONUSU_24943#45448,DENOMINATIONUSU_24944#45449,ECONOMIESOCIALE_24949#45450,ETATADMINISTRAT_24938#45451,IDENTIFIANTASSO_24930#45452,NICSIEGEUNITELE_24948#45453,NOMBREPERIODESU_24934#45454,NOMENCLATUREACT_24947#45455,NOMUNITELEGALE_24939#45456,NOMUSAGEUNITELE_24940#45457,PRENOM1UNITELEG_24924#45458,PRENOM2UNITELEG_24925#45459,PRENOM3UNITELEG_24926#45460,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569114`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#45607 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#45755, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#45609 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#45756, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#45611 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#45757, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#45758, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#45606 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#45759, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#45605 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#45760, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#45761, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#45762, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#45763, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#45602 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#45764, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#45603 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#45765, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#45604 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#45766, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#45767, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#45610 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#45768, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#45769, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#45770, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#45771, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#45772, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#45773, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#45585 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#45774, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#45775, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#45776, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#45777, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#45778, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#45437 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#45578, ANNEECATEGORIEE_24936#45438 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#45579, ANNEEEFFECTIFSU_24932#45439 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#45580, CARACTEREEMPLOY_24951#45440 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#45581, CATEGORIEENTREP_24935#45441 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#45582, CATEGORIEJURIDI_24945#45442 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#45583, DATECREATIONUNI_24921#45443 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#45584, DATEDEBUT_24937#45444 AS SIREN_LEGAL_24917_DATEDEBUT_24937#45585, DATEDERNIERTRAI_24933#45445 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#45586, DENOMINATIONUNI_24941#45446 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#45587, DENOMINATIONUSU_24942#45447 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#45588, DENOMINATIONUSU_24943#45448 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#45589, DENOMINATIONUSU_24944#45449 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#45590, ECONOMIESOCIALE_24949#45450 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#45591, ETATADMINISTRAT_24938#45451 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#45592, IDENTIFIANTASSO_24930#45452 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#45593, NICSIEGEUNITELE_24948#45453 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#45594, NOMBREPERIODESU_24934#45454 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#45595, NOMENCLATUREACT_24947#45455 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#45596, NOMUNITELEGALE_24939#45456 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#45597, NOMUSAGEUNITELE_24940#45457 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#45598, PRENOM1UNITELEG_24924#45458 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#45599, PRENOM2UNITELEG_24925#45459 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#45600, PRENOM3UNITELEG_24926#45460 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#45601, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917114
                  +- Relation[ACTIVITEPRINCIP_24946#45437,ANNEECATEGORIEE_24936#45438,ANNEEEFFECTIFSU_24932#45439,CARACTEREEMPLOY_24951#45440,CATEGORIEENTREP_24935#45441,CATEGORIEJURIDI_24945#45442,DATECREATIONUNI_24921#45443,DATEDEBUT_24937#45444,DATEDERNIERTRAI_24933#45445,DENOMINATIONUNI_24941#45446,DENOMINATIONUSU_24942#45447,DENOMINATIONUSU_24943#45448,DENOMINATIONUSU_24944#45449,ECONOMIESOCIALE_24949#45450,ETATADMINISTRAT_24938#45451,IDENTIFIANTASSO_24930#45452,NICSIEGEUNITELE_24948#45453,NOMBREPERIODESU_24934#45454,NOMENCLATUREACT_24947#45455,NOMUNITELEGALE_24939#45456,NOMUSAGEUNITELE_24940#45457,PRENOM1UNITELEG_24924#45458,PRENOM2UNITELEG_24925#45459,PRENOM3UNITELEG_24926#45460,... 10 more fields] parquet