DC2 - Details for Query 74

Details for Query 74

Submitted Time: 2026/03/05 07:14:06
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#16741 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#16814, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#16743 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#16815, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#16745 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#16816, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#16817, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#16740 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#16818, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#16739 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#16819, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#16820, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#16821, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#16822, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#16736 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#16823, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#16737 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#16824, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#16738 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#16825, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#16826, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#16744 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#16827, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#16828, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#16829, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#16830, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#16831, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#16832, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#16719 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#16833, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#16834, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#16835, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#16836, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#16837, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#16610 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#16712, ANNEECATEGORIEE_24936#16611 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713, ANNEEEFFECTIFSU_24932#16612 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714, CARACTEREEMPLOY_24951#16613 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#16715, CATEGORIEENTREP_24935#16614 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716, CATEGORIEJURIDI_24945#16615 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#16717, DATECREATIONUNI_24921#16616 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718, DATEDEBUT_24937#16617 AS SIREN_LEGAL_24917_DATEDEBUT_24937#16719, DATEDERNIERTRAI_24933#16618 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720, DENOMINATIONUNI_24941#16619 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721, DENOMINATIONUSU_24942#16620 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#16722, DENOMINATIONUSU_24943#16621 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#16723, DENOMINATIONUSU_24944#16622 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#16724, ECONOMIESOCIALE_24949#16623 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#16725, ETATADMINISTRAT_24938#16624 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726, IDENTIFIANTASSO_24930#16625 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727, NICSIEGEUNITELE_24948#16626 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#16728, NOMBREPERIODESU_24934#16627 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729, NOMENCLATUREACT_24947#16628 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#16730, NOMUNITELEGALE_24939#16629 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731, NOMUSAGEUNITELE_24940#16630 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732, PRENOM1UNITELEG_24924#16631 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733, PRENOM2UNITELEG_24925#16632 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734, PRENOM3UNITELEG_24926#16633 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#16610,ANNEECATEGORIEE_24936#16611,ANNEEEFFECTIFSU_24932#16612,CARACTEREEMPLOY_24951#16613,CATEGORIEENTREP_24935#16614,CATEGORIEJURIDI_24945#16615,DATECREATIONUNI_24921#16616,DATEDEBUT_24937#16617,DATEDERNIERTRAI_24933#16618,DENOMINATIONUNI_24941#16619,DENOMINATIONUSU_24942#16620,DENOMINATIONUSU_24943#16621,DENOMINATIONUSU_24944#16622,ECONOMIESOCIALE_24949#16623,ETATADMINISTRAT_24938#16624,IDENTIFIANTASSO_24930#16625,NICSIEGEUNITELE_24948#16626,NOMBREPERIODESU_24934#16627,NOMENCLATUREACT_24947#16628,NOMUNITELEGALE_24939#16629,NOMUSAGEUNITELE_24940#16630,PRENOM1UNITELEG_24924#16631,PRENOM2UNITELEG_24925#16632,PRENOM3UNITELEG_24926#16633,... 10 more fields] parquet

== Analyzed Logical Plan ==

CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#16741 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#16814, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#16743 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#16815, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#16745 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#16816, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#16817, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#16740 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#16818, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#16739 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#16819, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#16820, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#16821, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#16822, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#16736 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#16823, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#16737 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#16824, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#16738 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#16825, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#16826, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#16744 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#16827, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#16828, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#16829, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#16830, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#16831, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#16832, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#16719 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#16833, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#16834, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#16835, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#16836, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#16837, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#16610 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#16712, ANNEECATEGORIEE_24936#16611 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713, ANNEEEFFECTIFSU_24932#16612 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714, CARACTEREEMPLOY_24951#16613 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#16715, CATEGORIEENTREP_24935#16614 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716, CATEGORIEJURIDI_24945#16615 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#16717, DATECREATIONUNI_24921#16616 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718, DATEDEBUT_24937#16617 AS SIREN_LEGAL_24917_DATEDEBUT_24937#16719, DATEDERNIERTRAI_24933#16618 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720, DENOMINATIONUNI_24941#16619 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721, DENOMINATIONUSU_24942#16620 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#16722, DENOMINATIONUSU_24943#16621 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#16723, DENOMINATIONUSU_24944#16622 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#16724, ECONOMIESOCIALE_24949#16623 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#16725, ETATADMINISTRAT_24938#16624 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726, IDENTIFIANTASSO_24930#16625 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727, NICSIEGEUNITELE_24948#16626 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#16728, NOMBREPERIODESU_24934#16627 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729, NOMENCLATUREACT_24947#16628 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#16730, NOMUNITELEGALE_24939#16629 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731, NOMUSAGEUNITELE_24940#16630 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732, PRENOM1UNITELEG_24924#16631 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733, PRENOM2UNITELEG_24925#16632 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734, PRENOM3UNITELEG_24926#16633 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#16610,ANNEECATEGORIEE_24936#16611,ANNEEEFFECTIFSU_24932#16612,CARACTEREEMPLOY_24951#16613,CATEGORIEENTREP_24935#16614,CATEGORIEJURIDI_24945#16615,DATECREATIONUNI_24921#16616,DATEDEBUT_24937#16617,DATEDERNIERTRAI_24933#16618,DENOMINATIONUNI_24941#16619,DENOMINATIONUSU_24942#16620,DENOMINATIONUSU_24943#16621,DENOMINATIONUSU_24944#16622,ECONOMIESOCIALE_24949#16623,ETATADMINISTRAT_24938#16624,IDENTIFIANTASSO_24930#16625,NICSIEGEUNITELE_24948#16626,NOMBREPERIODESU_24934#16627,NOMENCLATUREACT_24947#16628,NOMUNITELEGALE_24939#16629,NOMUSAGEUNITELE_24940#16630,PRENOM1UNITELEG_24924#16631,PRENOM2UNITELEG_24925#16632,PRENOM3UNITELEG_24926#16633,... 10 more fields] parquet

== Optimized Logical Plan ==
CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
   +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#16741 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#16814, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#16743 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#16815, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#16745 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#16816, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#16817, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#16740 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#16818, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#16739 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#16819, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#16820, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#16821, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#16822, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#16736 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#16823, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#16737 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#16824, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#16738 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#16825, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#16826, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#16744 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#16827, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#16828, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#16829, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#16830, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#16831, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#16832, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#16719 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#16833, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#16834, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#16835, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#16836, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#16837, ... 10 more fields]
      +- Project [ACTIVITEPRINCIP_24946#16610 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#16712, ANNEECATEGORIEE_24936#16611 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713, ANNEEEFFECTIFSU_24932#16612 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714, CARACTEREEMPLOY_24951#16613 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#16715, CATEGORIEENTREP_24935#16614 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716, CATEGORIEJURIDI_24945#16615 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#16717, DATECREATIONUNI_24921#16616 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718, DATEDEBUT_24937#16617 AS SIREN_LEGAL_24917_DATEDEBUT_24937#16719, DATEDERNIERTRAI_24933#16618 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720, DENOMINATIONUNI_24941#16619 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721, DENOMINATIONUSU_24942#16620 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#16722, DENOMINATIONUSU_24943#16621 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#16723, DENOMINATIONUSU_24944#16622 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#16724, ECONOMIESOCIALE_24949#16623 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#16725, ETATADMINISTRAT_24938#16624 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726, IDENTIFIANTASSO_24930#16625 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727, NICSIEGEUNITELE_24948#16626 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#16728, NOMBREPERIODESU_24934#16627 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729, NOMENCLATUREACT_24947#16628 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#16730, NOMUNITELEGALE_24939#16629 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731, NOMUSAGEUNITELE_24940#16630 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732, PRENOM1UNITELEG_24924#16631 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733, PRENOM2UNITELEG_24925#16632 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734, PRENOM3UNITELEG_24926#16633 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735, ... 10 more fields]
         +- SubqueryAlias SIREN_LEGAL_24917115
            +- Relation[ACTIVITEPRINCIP_24946#16610,ANNEECATEGORIEE_24936#16611,ANNEEEFFECTIFSU_24932#16612,CARACTEREEMPLOY_24951#16613,CATEGORIEENTREP_24935#16614,CATEGORIEJURIDI_24945#16615,DATECREATIONUNI_24921#16616,DATEDEBUT_24937#16617,DATEDERNIERTRAI_24933#16618,DENOMINATIONUNI_24941#16619,DENOMINATIONUSU_24942#16620,DENOMINATIONUSU_24943#16621,DENOMINATIONUSU_24944#16622,ECONOMIESOCIALE_24949#16623,ETATADMINISTRAT_24938#16624,IDENTIFIANTASSO_24930#16625,NICSIEGEUNITELE_24948#16626,NOMBREPERIODESU_24934#16627,NOMENCLATUREACT_24947#16628,NOMUNITELEGALE_24939#16629,NOMUSAGEUNITELE_24940#16630,PRENOM1UNITELEG_24924#16631,PRENOM2UNITELEG_24925#16632,PRENOM3UNITELEG_24926#16633,... 10 more fields] parquet

== Physical Plan ==
Execute CreateViewCommand
   +- CreateViewCommand `SIREN_LEGAL_29569115`, false, true, LocalTempView
         +- Project [cast(SIREN_LEGAL_24917_SIREN_24918#16741 as string) AS COL_3EA614FF_8B23_49E5_B390_492DF8F02D1D#16814, cast(SIREN_LEGAL_24917_STATUTDIFFUSION_24919#16743 as string) AS COL_83BD3044_61CA_4883_9CA6_0FD7AD5EE11C#16815, cast(SIREN_LEGAL_24917_UNITEPURGEEUNIT_24920#16745 as string) AS COL_AD11B459_85E4_4A27_8551_DA3800C7FF9A#16816, cast(SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718 as string) AS COL_9D03419D_C865_4CC4_A995_6BBAF14344E0#16817, cast(SIREN_LEGAL_24917_SIGLEUNITELEGAL_24922#16740 as string) AS COL_085E02EF_921B_49CA_8CA7_00A5D1160F66#16818, cast(SIREN_LEGAL_24917_SEXEUNITELEGALE_24923#16739 as string) AS COL_6F6EF2F5_9835_421D_8DA1_2939DFCA4D12#16819, cast(SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733 as string) AS COL_BA56769C_4394_4D1A_B960_9E304C0A1B5E#16820, cast(SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734 as string) AS COL_6122CF14_D89F_43AA_A905_35F08D61DA4E#16821, cast(SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735 as string) AS COL_B327E461_F9E7_4966_AA28_1CEC92D2A58F#16822, cast(SIREN_LEGAL_24917_PRENOM4UNITELEG_24927#16736 as string) AS COL_16B64E7C_8B3A_4BF5_9BE7_5D982E843E04#16823, cast(SIREN_LEGAL_24917_PRENOMUSUELUNIT_24928#16737 as string) AS COL_1D70E23A_1DAC_44C6_9DDC_43103BF14079#16824, cast(SIREN_LEGAL_24917_PSEUDONYMEUNITE_24929#16738 as string) AS COL_D431E292_B4B2_40A6_8AF2_1995F7A4C3FC#16825, cast(SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727 as string) AS COL_43E4919F_E1A0_49C4_A164_1BE960A844E6#16826, cast(SIREN_LEGAL_24917_TRANCHEEFFECTIF_24931#16744 as string) AS COL_EDC3F4F2_AFD8_4B2C_9573_7E3AD8F58030#16827, cast(SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714 as string) AS COL_75790EB2_3E86_479A_97B0_0792EE9617C5#16828, cast(SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720 as string) AS COL_37832811_1004_417D_BE18_E54007827D5B#16829, cast(SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729 as string) AS COL_9E8C8A57_A8B3_4540_A17A_679F841A5EC7#16830, cast(SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716 as string) AS COL_413F4D5D_A903_4A56_ABE8_D3AC2DE06F3D#16831, cast(SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713 as string) AS COL_72C6215E_DB09_4B6A_B0EA_A639E2237081#16832, cast(SIREN_LEGAL_24917_DATEDEBUT_24937#16719 as string) AS COL_F41EB352_31ED_4326_B64F_3C26DDCE3B30#16833, cast(SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726 as string) AS COL_EF6C5463_426A_4433_9093_17FC0B37BBB2#16834, cast(SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731 as string) AS COL_06E08700_394C_49AC_A486_92313A554450#16835, cast(SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732 as string) AS COL_3FD30913_7825_4A64_826E_57F4BE00A78F#16836, cast(SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721 as string) AS COL_EE367F89_3F3D_4642_AEAA_6AFE602E2EDA#16837, ... 10 more fields]
            +- Project [ACTIVITEPRINCIP_24946#16610 AS SIREN_LEGAL_24917_ACTIVITEPRINCIP_24946#16712, ANNEECATEGORIEE_24936#16611 AS SIREN_LEGAL_24917_ANNEECATEGORIEE_24936#16713, ANNEEEFFECTIFSU_24932#16612 AS SIREN_LEGAL_24917_ANNEEEFFECTIFSU_24932#16714, CARACTEREEMPLOY_24951#16613 AS SIREN_LEGAL_24917_CARACTEREEMPLOY_24951#16715, CATEGORIEENTREP_24935#16614 AS SIREN_LEGAL_24917_CATEGORIEENTREP_24935#16716, CATEGORIEJURIDI_24945#16615 AS SIREN_LEGAL_24917_CATEGORIEJURIDI_24945#16717, DATECREATIONUNI_24921#16616 AS SIREN_LEGAL_24917_DATECREATIONUNI_24921#16718, DATEDEBUT_24937#16617 AS SIREN_LEGAL_24917_DATEDEBUT_24937#16719, DATEDERNIERTRAI_24933#16618 AS SIREN_LEGAL_24917_DATEDERNIERTRAI_24933#16720, DENOMINATIONUNI_24941#16619 AS SIREN_LEGAL_24917_DENOMINATIONUNI_24941#16721, DENOMINATIONUSU_24942#16620 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24942#16722, DENOMINATIONUSU_24943#16621 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24943#16723, DENOMINATIONUSU_24944#16622 AS SIREN_LEGAL_24917_DENOMINATIONUSU_24944#16724, ECONOMIESOCIALE_24949#16623 AS SIREN_LEGAL_24917_ECONOMIESOCIALE_24949#16725, ETATADMINISTRAT_24938#16624 AS SIREN_LEGAL_24917_ETATADMINISTRAT_24938#16726, IDENTIFIANTASSO_24930#16625 AS SIREN_LEGAL_24917_IDENTIFIANTASSO_24930#16727, NICSIEGEUNITELE_24948#16626 AS SIREN_LEGAL_24917_NICSIEGEUNITELE_24948#16728, NOMBREPERIODESU_24934#16627 AS SIREN_LEGAL_24917_NOMBREPERIODESU_24934#16729, NOMENCLATUREACT_24947#16628 AS SIREN_LEGAL_24917_NOMENCLATUREACT_24947#16730, NOMUNITELEGALE_24939#16629 AS SIREN_LEGAL_24917_NOMUNITELEGALE_24939#16731, NOMUSAGEUNITELE_24940#16630 AS SIREN_LEGAL_24917_NOMUSAGEUNITELE_24940#16732, PRENOM1UNITELEG_24924#16631 AS SIREN_LEGAL_24917_PRENOM1UNITELEG_24924#16733, PRENOM2UNITELEG_24925#16632 AS SIREN_LEGAL_24917_PRENOM2UNITELEG_24925#16734, PRENOM3UNITELEG_24926#16633 AS SIREN_LEGAL_24917_PRENOM3UNITELEG_24926#16735, ... 10 more fields]
               +- SubqueryAlias SIREN_LEGAL_24917115
                  +- Relation[ACTIVITEPRINCIP_24946#16610,ANNEECATEGORIEE_24936#16611,ANNEEEFFECTIFSU_24932#16612,CARACTEREEMPLOY_24951#16613,CATEGORIEENTREP_24935#16614,CATEGORIEJURIDI_24945#16615,DATECREATIONUNI_24921#16616,DATEDEBUT_24937#16617,DATEDERNIERTRAI_24933#16618,DENOMINATIONUNI_24941#16619,DENOMINATIONUSU_24942#16620,DENOMINATIONUSU_24943#16621,DENOMINATIONUSU_24944#16622,ECONOMIESOCIALE_24949#16623,ETATADMINISTRAT_24938#16624,IDENTIFIANTASSO_24930#16625,NICSIEGEUNITELE_24948#16626,NOMBREPERIODESU_24934#16627,NOMENCLATUREACT_24947#16628,NOMUNITELEGALE_24939#16629,NOMUSAGEUNITELE_24940#16630,PRENOM1UNITELEG_24924#16631,PRENOM2UNITELEG_24925#16632,PRENOM3UNITELEG_24926#16633,... 10 more fields] parquet