DC2 - Details for Query 20

Details for Query 20

Submitted Time: 2025/11/03 07:22:29
Duration: 7 s
Succeeded Jobs: 27 28
Show the Stage ID and Task ID that corresponds to the max metric
digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; } 4 [labelType="html" label="BroadcastNestedLoopJoin number of output rows: 1,500"]; 5 [labelType="html" label="BroadcastExchange data size: 2.7 MiB time to collect: 6.8 s time to build: 8 ms time to broadcast: 20 ms"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 31 ms"; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label="ColumnarToRow number of output rows: 15,398 number of input batches: 4"]; } 9 [labelType="html" label="Scan parquet number of files read: 1 scan time: 7 ms metadata time: 0 ms size of files read: 478.2 KiB number of output rows: 15,398"]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="ColumnarToRow number of output rows: 4,096 number of input batches: 1"]; } 13 [labelType="html" label="Scan parquet number of files read: 7 scan time: 13 ms metadata time: 0 ms size of files read: 7.4 MiB number of output rows: 4,096"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 11->4; 12->11; 13->12; }
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 1500
Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#9213, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#9214, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#9215, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#9216, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#9217, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#9218, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#9219, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#9220, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#9221, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#9222, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#9223, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#9224, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, LEFT, 1) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#9225, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, LEFT, 1) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#9226, ... 15 more fields]
WholeStageCodegen (3)
BroadcastNestedLoopJoin BuildLeft, Cross
BroadcastExchange IdentityBroadcastMode, [id=#724]
Project [IPP_PATIENT_21792#7121 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, NOM_NAISSANCE_21793#7123 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, PRENOM_21794#7124 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, NOM_21795#7122 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, SEXE_21796#7125 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, DATENAISINT_21797#7120 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, CP_NAISSANCE_21798#7119 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, ADRESSE_21799#7117 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, CPO_21800#7118 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, VILLE_21801#7126 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [ADRESSE_21799#7117,CPO_21800#7118,CP_NAISSANCE_21798#7119,DATENAISINT_21797#7120,IPP_PATIENT_21792#7121,NOM_21795#7122,NOM_NAISSANCE_21793#7123,PRENOM_21794#7124,SEXE_21796#7125,VILLE_21801#7126] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_PATIENT_21791], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ADRESSE_21799:string,CPO_21800:string,CP_NAISSANCE_21798:string,DATENAISINT_21797:string,I...
Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931, COL_BE212348_11C6_412B_A80B_97C0091C8459#7704 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937, COL_043C0997_E848_48D4_A718_CB0593090678#7710 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945]
ColumnarToRow
WholeStageCodegen (2)
FileScan parquet [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701,COL_BE212348_11C6_412B_A80B_97C0091C8459#7704,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707,COL_043C0997_E848_48D4_A718_CB0593090678#7710,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_6335C019_5574_4384_9DF0_52A3633FA003:string,COL_FE9C9A74_804A_455A_8730_A79C680C46FA:s...
Details
== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#9203, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#9204, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#9205, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#9206, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#9207, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#9208, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#9209, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#9210, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#9211, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#9212, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#9213, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#9214, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#9215, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#9216, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#9217, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#9218, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#9219, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#9220, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#9221, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#9222, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#9223, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#9224, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#9225, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#9226, ... 15 more fields]
      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 15 more fields]
         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 14 more fields]
            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 13 more fields]
               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 12 more fields]
                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 11 more fields]
                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 10 more fields]
                        +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 9 more fields]
                           +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 8 more fields]
                              +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 7 more fields]
                                 +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 6 more fields]
                                    +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 5 more fields]
                                       +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 4 more fields]
                                          +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 3 more fields]
                                             +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 2 more fields]
                                                +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, str_if_with_rule((COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423 <=> COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432), cast(1 as string), cast(0 as string)) AS COL_78E288B2_7753_442C_B16A_E52F4C57C5CF#8508]
                                                   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8337 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8338 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8339 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8340 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8341 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8342 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8343 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8344 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8345 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8346 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8347 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8348 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8349 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8350 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8351 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8352 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8353 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8354 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8355 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8356 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8357 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8358 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8359 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8360 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445]
                                                      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8337, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8338, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8339, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8340, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8341, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8342, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8343, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8344, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8345, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8346, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8347, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8348, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8349, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8350, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8351, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8352, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8353, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8354, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8355, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8356, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8357, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8358, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8359, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8276 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8360]
                                                         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, cast(LEFT as string), cast(1 as bigint)) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8276]
                                                            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, cast(LEFT as string), cast(1 as bigint)) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217]
                                                               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8095 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8096 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8097 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8098 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8099 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8100 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8101 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8102 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8103 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8104 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8105 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8106 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8107 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8108 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8109 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8110 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8111 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8112 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8113 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8114 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8115 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8116 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193]
                                                                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8095, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8096, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8097, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8098, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8099, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8100, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8101, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8102, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8103, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8104, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8028 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8105, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8029 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8106, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8030 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8107, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8031 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8108, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8032 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8109, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8033 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8110, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8034 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8111, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8035 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8112, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8036 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8113, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8037 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8114, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8038 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8115, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8039 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8116]
                                                                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8028, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8029, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8030, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8031, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8032, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8033, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8034, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8035, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8036, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8037, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8038, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8039]
                                                                        +- Join Cross
                                                                           :- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7835 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7836 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7837 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7838 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7839 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7840 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7841 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7842 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7843 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7844 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894]
                                                                           :  +- Project [cast(BASE_PATIENT_21791_IPP_PATIENT_21792#7779 as string) AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7835, cast(BASE_PATIENT_21791_NOM_NAISSANCE_21793#7781 as string) AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7836, cast(BASE_PATIENT_21791_PRENOM_21794#7782 as string) AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7837, cast(BASE_PATIENT_21791_NOM_21795#7780 as string) AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7838, cast(BASE_PATIENT_21791_SEXE_21796#7783 as int) AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7839, cast(BASE_PATIENT_21791_DATENAISINT_21797#7778 as string) AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7840, cast(BASE_PATIENT_21791_CP_NAISSANCE_21798#7777 as string) AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7841, cast(BASE_PATIENT_21791_ADRESSE_21799#7775 as string) AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7842, cast(BASE_PATIENT_21791_CPO_21800#7776 as string) AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7843, cast(BASE_PATIENT_21791_VILLE_21801#7784 as string) AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7844]
                                                                           :     +- Project [ADRESSE_21799#7117 AS BASE_PATIENT_21791_ADRESSE_21799#7775, CPO_21800#7118 AS BASE_PATIENT_21791_CPO_21800#7776, CP_NAISSANCE_21798#7119 AS BASE_PATIENT_21791_CP_NAISSANCE_21798#7777, DATENAISINT_21797#7120 AS BASE_PATIENT_21791_DATENAISINT_21797#7778, IPP_PATIENT_21792#7121 AS BASE_PATIENT_21791_IPP_PATIENT_21792#7779, NOM_21795#7122 AS BASE_PATIENT_21791_NOM_21795#7780, NOM_NAISSANCE_21793#7123 AS BASE_PATIENT_21791_NOM_NAISSANCE_21793#7781, PRENOM_21794#7124 AS BASE_PATIENT_21791_PRENOM_21794#7782, SEXE_21796#7125 AS BASE_PATIENT_21791_SEXE_21796#7783, VILLE_21801#7126 AS BASE_PATIENT_21791_VILLE_21801#7784]
                                                                           :        +- SubqueryAlias BASE_PATIENT_21791114
                                                                           :           +- Relation[ADRESSE_21799#7117,CPO_21800#7118,CP_NAISSANCE_21798#7119,DATENAISINT_21797#7120,IPP_PATIENT_21792#7121,NOM_21795#7122,NOM_NAISSANCE_21793#7123,PRENOM_21794#7124,SEXE_21796#7125,VILLE_21801#7126] parquet
                                                                           +- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7697 AS BASE_INSEE_PERS_21802_COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7927, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928, COL_E841813D_AC74_4154_9681_2401BF551CEB#7699 AS BASE_INSEE_PERS_21802_COL_E841813D_AC74_4154_9681_2401BF551CEB#7929, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7702 AS BASE_INSEE_PERS_21802_COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7932, COL_894EC6EE_C475_4057_9220_CD3490C6C246#7703 AS BASE_INSEE_PERS_21802_COL_894EC6EE_C475_4057_9220_CD3490C6C246#7933, COL_BE212348_11C6_412B_A80B_97C0091C8459#7704 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7705 AS BASE_INSEE_PERS_21802_COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7935, COL_B9C166B6_7C93_44BB_B249_608260D22E08#7706 AS BASE_INSEE_PERS_21802_COL_B9C166B6_7C93_44BB_B249_608260D22E08#7936, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7708 AS BASE_INSEE_PERS_21802_COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7938, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7709 AS BASE_INSEE_PERS_21802_COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7939, COL_043C0997_E848_48D4_A718_CB0593090678#7710 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945]
                                                                              +- SubqueryAlias BASE_INSEE_PERS_21802114
                                                                                 +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7696,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7697,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698,COL_E841813D_AC74_4154_9681_2401BF551CEB#7699,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7702,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7703,COL_BE212348_11C6_412B_A80B_97C0091C8459#7704,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7705,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7706,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7708,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7709,COL_043C0997_E848_48D4_A718_CB0593090678#7710,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715] parquet

== Analyzed Logical Plan ==
COL_B90978C1_4532_451F_97F7_1AF18F0FEC91: string, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5: string, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071: string, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD: string, COL_41FD89D1_205F_425D_8E18_6118B8ED579D: int, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F: string, COL_62E47E79_B177_4A83_8069_CF7035D824BF: string, COL_08383D09_15F5_4A21_A763_3F9296BA4246: string, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D: string, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C: string, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D: string, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C: string, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B: string, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405: string, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14: string, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F: string, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D: string, COL_577ED51F_82CF_4FCF_9F31_BE8539108783: string, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B: string, COL_AD676D86_951F_4EAA_A649_D4EB88596605: string, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857: string, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D: string, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D: string, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F: string, ... 15 more fields
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#9203, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#9204, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#9205, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#9206, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#9207, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#9208, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#9209, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#9210, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#9211, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#9212, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#9213, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#9214, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#9215, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#9216, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#9217, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#9218, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#9219, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#9220, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#9221, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#9222, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#9223, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#9224, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#9225, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#9226, ... 15 more fields]
      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 15 more fields]
         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 14 more fields]
            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 13 more fields]
               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 12 more fields]
                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 11 more fields]
                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 10 more fields]
                        +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 9 more fields]
                           +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 8 more fields]
                              +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 7 more fields]
                                 +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 6 more fields]
                                    +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 5 more fields]
                                       +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 4 more fields]
                                          +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 3 more fields]
                                             +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, ... 2 more fields]
                                                +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445, str_if_with_rule((COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423 <=> COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432), cast(1 as string), cast(0 as string)) AS COL_78E288B2_7753_442C_B16A_E52F4C57C5CF#8508]
                                                   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8337 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8422, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8338 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8423, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8339 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8424, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8340 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8425, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8341 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8426, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8342 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8427, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8343 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8428, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8344 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8429, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8345 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8430, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8346 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8431, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8347 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8432, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8348 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8433, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8349 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8434, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8350 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8435, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8351 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8436, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8352 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8437, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8353 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8438, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8354 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8439, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8355 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8440, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8356 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8441, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8357 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8442, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8358 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8443, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8359 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8444, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8360 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8445]
                                                      +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8337, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8338, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8339, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8340, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8341, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8342, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8343, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8344, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8345, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8346, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8347, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8348, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8349, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8350, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8351, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8352, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8353, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8354, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8355, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8356, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8357, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8358, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217 AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8359, COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8276 AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8360]
                                                         +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193, COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, cast(LEFT as string), cast(1 as bigint)) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#8276]
                                                            +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, cast(LEFT as string), cast(1 as bigint)) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#8217]
                                                               +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8095 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8172, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8096 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8173, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8097 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8174, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8098 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8175, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8099 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8176, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8100 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8177, COL_62E47E79_B177_4A83_8069_CF7035D824BF#8101 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8178, COL_08383D09_15F5_4A21_A763_3F9296BA4246#8102 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8179, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8103 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8180, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8104 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8181, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8105 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8182, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8106 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8183, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8107 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8184, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8108 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8185, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8109 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8186, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8110 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8187, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8111 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8188, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8112 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8189, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8113 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8190, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8114 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8191, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8115 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8192, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8116 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8193]
                                                                  +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#8095, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#8096, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#8097, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#8098, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#8099, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#8100, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#8101, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#8102, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#8103, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#8104, COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8028 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8105, COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8029 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8106, COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8030 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8107, COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8031 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8108, COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8032 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8109, COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8033 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8110, COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8034 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8111, COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8035 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8112, COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8036 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8113, COL_AD676D86_951F_4EAA_A649_D4EB88596605#8037 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8114, COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8038 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8115, COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8039 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8116]
                                                                     +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#8028, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#8029, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#8030, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#8031, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#8032, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#8033, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#8034, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#8035, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#8036, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#8037, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#8038, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#8039]
                                                                        +- Join Cross
                                                                           :- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7835 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7836 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7837 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7838 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7839 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7840 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7841 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7842 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7843 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7844 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894]
                                                                           :  +- Project [cast(BASE_PATIENT_21791_IPP_PATIENT_21792#7779 as string) AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7835, cast(BASE_PATIENT_21791_NOM_NAISSANCE_21793#7781 as string) AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7836, cast(BASE_PATIENT_21791_PRENOM_21794#7782 as string) AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7837, cast(BASE_PATIENT_21791_NOM_21795#7780 as string) AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7838, cast(BASE_PATIENT_21791_SEXE_21796#7783 as int) AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7839, cast(BASE_PATIENT_21791_DATENAISINT_21797#7778 as string) AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7840, cast(BASE_PATIENT_21791_CP_NAISSANCE_21798#7777 as string) AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7841, cast(BASE_PATIENT_21791_ADRESSE_21799#7775 as string) AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7842, cast(BASE_PATIENT_21791_CPO_21800#7776 as string) AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7843, cast(BASE_PATIENT_21791_VILLE_21801#7784 as string) AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7844]
                                                                           :     +- Project [ADRESSE_21799#7117 AS BASE_PATIENT_21791_ADRESSE_21799#7775, CPO_21800#7118 AS BASE_PATIENT_21791_CPO_21800#7776, CP_NAISSANCE_21798#7119 AS BASE_PATIENT_21791_CP_NAISSANCE_21798#7777, DATENAISINT_21797#7120 AS BASE_PATIENT_21791_DATENAISINT_21797#7778, IPP_PATIENT_21792#7121 AS BASE_PATIENT_21791_IPP_PATIENT_21792#7779, NOM_21795#7122 AS BASE_PATIENT_21791_NOM_21795#7780, NOM_NAISSANCE_21793#7123 AS BASE_PATIENT_21791_NOM_NAISSANCE_21793#7781, PRENOM_21794#7124 AS BASE_PATIENT_21791_PRENOM_21794#7782, SEXE_21796#7125 AS BASE_PATIENT_21791_SEXE_21796#7783, VILLE_21801#7126 AS BASE_PATIENT_21791_VILLE_21801#7784]
                                                                           :        +- SubqueryAlias BASE_PATIENT_21791114
                                                                           :           +- Relation[ADRESSE_21799#7117,CPO_21800#7118,CP_NAISSANCE_21798#7119,DATENAISINT_21797#7120,IPP_PATIENT_21792#7121,NOM_21795#7122,NOM_NAISSANCE_21793#7123,PRENOM_21794#7124,SEXE_21796#7125,VILLE_21801#7126] parquet
                                                                           +- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926, COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7697 AS BASE_INSEE_PERS_21802_COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7927, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928, COL_E841813D_AC74_4154_9681_2401BF551CEB#7699 AS BASE_INSEE_PERS_21802_COL_E841813D_AC74_4154_9681_2401BF551CEB#7929, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931, COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7702 AS BASE_INSEE_PERS_21802_COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7932, COL_894EC6EE_C475_4057_9220_CD3490C6C246#7703 AS BASE_INSEE_PERS_21802_COL_894EC6EE_C475_4057_9220_CD3490C6C246#7933, COL_BE212348_11C6_412B_A80B_97C0091C8459#7704 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934, COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7705 AS BASE_INSEE_PERS_21802_COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7935, COL_B9C166B6_7C93_44BB_B249_608260D22E08#7706 AS BASE_INSEE_PERS_21802_COL_B9C166B6_7C93_44BB_B249_608260D22E08#7936, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937, COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7708 AS BASE_INSEE_PERS_21802_COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7938, COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7709 AS BASE_INSEE_PERS_21802_COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7939, COL_043C0997_E848_48D4_A718_CB0593090678#7710 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945]
                                                                              +- SubqueryAlias BASE_INSEE_PERS_21802114
                                                                                 +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7696,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7697,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698,COL_E841813D_AC74_4154_9681_2401BF551CEB#7699,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7702,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7703,COL_BE212348_11C6_412B_A80B_97C0091C8459#7704,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7705,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7706,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7708,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7709,COL_043C0997_E848_48D4_A718_CB0593090678#7710,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#9213, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#9214, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#9215, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#9216, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#9217, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#9218, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#9219, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#9220, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#9221, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#9222, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#9223, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#9224, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, LEFT, 1) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#9225, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, LEFT, 1) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#9226, ... 15 more fields]
      +- Join Cross
         :- Project [IPP_PATIENT_21792#7121 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, NOM_NAISSANCE_21793#7123 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, PRENOM_21794#7124 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, NOM_21795#7122 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, SEXE_21796#7125 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, DATENAISINT_21797#7120 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, CP_NAISSANCE_21798#7119 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, ADRESSE_21799#7117 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, CPO_21800#7118 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, VILLE_21801#7126 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894]
         :  +- Relation[ADRESSE_21799#7117,CPO_21800#7118,CP_NAISSANCE_21798#7119,DATENAISINT_21797#7120,IPP_PATIENT_21792#7121,NOM_21795#7122,NOM_NAISSANCE_21793#7123,PRENOM_21794#7124,SEXE_21796#7125,VILLE_21801#7126] parquet
         +- Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931, COL_BE212348_11C6_412B_A80B_97C0091C8459#7704 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937, COL_043C0997_E848_48D4_A718_CB0593090678#7710 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945]
            +- Relation[COL_6335C019_5574_4384_9DF0_52A3633FA003#7696,COL_6C77B74F_A061_415A_93F3_B145C4AA4E55#7697,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698,COL_E841813D_AC74_4154_9681_2401BF551CEB#7699,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701,COL_54B3BED1_B3CC_4154_8E63_CB26CD0941E2#7702,COL_894EC6EE_C475_4057_9220_CD3490C6C246#7703,COL_BE212348_11C6_412B_A80B_97C0091C8459#7704,COL_3B44E50F_A068_4D75_8862_C98FFB2A2F99#7705,COL_B9C166B6_7C93_44BB_B249_608260D22E08#7706,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707,COL_C894D30F_479E_48EC_B9E5_87740A99B0AB#7708,COL_1ED1087E_2BE1_4D32_95D6_64915F8865A3#7709,COL_043C0997_E848_48D4_A718_CB0593090678#7710,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- CollectLimit 1500
   +- *(3) Project [COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894, BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926 AS COL_A5545DCD_095F_4D85_B60B_5B016C1C538D#9213, BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928 AS COL_835D76BD_1F54_4C40_81F2_AE7702D8606C#9214, BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930 AS COL_91061AAD_8377_447E_B20A_3C8BF2A7A73B#9215, BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931 AS COL_36F56B5A_6F2C_40AC_89E6_BD877F2C8405#9216, BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934 AS COL_A6E6EABE_7120_4B22_89C1_788B4B9EED14#9217, BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937 AS COL_5252A18C_0832_4B2E_9BE7_FD1CEA49F21F#9218, BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940 AS COL_D0510CD9_F08C_4E14_A516_878FC3EEF87D#9219, BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941 AS COL_577ED51F_82CF_4FCF_9F31_BE8539108783#9220, BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942 AS COL_CDA946F9_2535_4FAA_9C05_41CCE9EBC48B#9221, BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943 AS COL_AD676D86_951F_4EAA_A649_D4EB88596605#9222, BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944 AS COL_3E9F0771_40BC_4A73_86BB_405D2D1AD857#9223, BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945 AS COL_AAE67BAE_ADF6_4F47_A774_FD8103ED7B0D#9224, str_extract(COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, LEFT, 1) AS COL_39ABE4B5_02BA_44A3_A6C5_21F766FD746D#9225, str_extract(COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, LEFT, 1) AS COL_AC9305D2_0CB1_47C8_9D94_28A7C83DE47F#9226, ... 15 more fields]
      +- BroadcastNestedLoopJoin BuildLeft, Cross
         :- BroadcastQueryStage 0
         :  +- BroadcastExchange IdentityBroadcastMode, [id=#724]
         :     +- *(1) Project [IPP_PATIENT_21792#7121 AS COL_B90978C1_4532_451F_97F7_1AF18F0FEC91#7885, NOM_NAISSANCE_21793#7123 AS COL_5E4E47E3_0CA9_4954_8BC5_30D63A0D80D5#7886, PRENOM_21794#7124 AS COL_517BEB2A_BA9F_4BC2_B7BA_3C921396F071#7887, NOM_21795#7122 AS COL_2F059322_CCC0_42B9_8327_08D7EEFF11BD#7888, SEXE_21796#7125 AS COL_41FD89D1_205F_425D_8E18_6118B8ED579D#7889, DATENAISINT_21797#7120 AS COL_7273593A_E6C2_472E_A2E2_5B533B30B23F#7890, CP_NAISSANCE_21798#7119 AS COL_62E47E79_B177_4A83_8069_CF7035D824BF#7891, ADRESSE_21799#7117 AS COL_08383D09_15F5_4A21_A763_3F9296BA4246#7892, CPO_21800#7118 AS COL_C98E08DB_A571_4578_ADBB_9E71C2E1EC9D#7893, VILLE_21801#7126 AS COL_8106BAA3_0BBE_4C9A_A425_20AF2886092C#7894]
         :        +- *(1) ColumnarToRow
         :           +- FileScan parquet [ADRESSE_21799#7117,CPO_21800#7118,CP_NAISSANCE_21798#7119,DATENAISINT_21797#7120,IPP_PATIENT_21792#7121,NOM_21795#7122,NOM_NAISSANCE_21793#7123,PRENOM_21794#7124,SEXE_21796#7125,VILLE_21801#7126] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/uet/BASE_PATIENT_21791], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<ADRESSE_21799:string,CPO_21800:string,CP_NAISSANCE_21798:string,DATENAISINT_21797:string,I...
         +- *(2) Project [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696 AS BASE_INSEE_PERS_21802_COL_6335C019_5574_4384_9DF0_52A3633FA003#7926, COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698 AS BASE_INSEE_PERS_21802_COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7928, COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700 AS BASE_INSEE_PERS_21802_COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7930, COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701 AS BASE_INSEE_PERS_21802_COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7931, COL_BE212348_11C6_412B_A80B_97C0091C8459#7704 AS BASE_INSEE_PERS_21802_COL_BE212348_11C6_412B_A80B_97C0091C8459#7934, COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707 AS BASE_INSEE_PERS_21802_COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7937, COL_043C0997_E848_48D4_A718_CB0593090678#7710 AS BASE_INSEE_PERS_21802_COL_043C0997_E848_48D4_A718_CB0593090678#7940, COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711 AS BASE_INSEE_PERS_21802_COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7941, COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712 AS BASE_INSEE_PERS_21802_COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7942, COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713 AS BASE_INSEE_PERS_21802_COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7943, COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714 AS BASE_INSEE_PERS_21802_COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7944, COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715 AS BASE_INSEE_PERS_21802_COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7945]
            +- *(2) ColumnarToRow
               +- FileScan parquet [COL_6335C019_5574_4384_9DF0_52A3633FA003#7696,COL_FE9C9A74_804A_455A_8730_A79C680C46FA#7698,COL_1CCF890C_20A2_43E7_82CA_409F2C9AF6C4#7700,COL_E6C9E4A7_52B2_4B09_B220_71E1A47F5339#7701,COL_BE212348_11C6_412B_A80B_97C0091C8459#7704,COL_221D72BC_3C77_433B_8DD9_56E7C6AD5C86#7707,COL_043C0997_E848_48D4_A718_CB0593090678#7710,COL_D10DF4C9_2551_416C_9B21_C4D820750AB7#7711,COL_ACF62F49_F143_46BA_B162_5AA4D6E01E41#7712,COL_576D14AE_0018_459C_95DF_6C92AF3B00A2#7713,COL_B829870E_F72A_4AB4_B459_5E652FDB6B94#7714,COL_D12C726C_7641_4F64_93D3_B32FD2A5044A#7715] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/output/cache/parquet/datablock/BASE_INSEE_PERS_21802], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_6335C019_5574_4384_9DF0_52A3633FA003:string,COL_FE9C9A74_804A_455A_8730_A79C680C46FA:s...