SP1 - Details for Query 2346

Submitted Time: 2026/09/17 16:20:19
Duration: 2 s
Succeeded Jobs: 3405 3406 3409

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 0 ms number of written files: 1 job commit time: 15 ms number of output rows: 1,027 number of dynamic part: 0 written output: 79.4 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (11)\n \nduration: 362 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Generate number of output rows: 1,027"]; 10 [labelType="html" label=" Project "]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="Filter number of output rows: 877"]; } 15 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (10)\n \nduration: 735 ms"; 17 [labelType="html" label="Sort sort time: 8 ms peak memory: 18.0 MiB spill size: 0.0 B"]; 18 [labelType="html" label=" Project "]; 19 [labelType="html" label="SortMergeJoin number of output rows: 44,947 spill size: 0.0 B"]; } subgraph cluster20 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 323 ms"; 21 [labelType="html" label=" Project "]; 22 [labelType="html" label="Filter number of output rows: 18,970"]; } 23 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 726 ms"; 25 [labelType="html" label="Sort sort time: 13 ms peak memory: 18.0 MiB spill size: 0.0 B"]; 26 [labelType="html" label=" Project "]; } 27 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster28 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 447 ms"; 29 [labelType="html" label="Sort sort time: 13 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 30 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster31 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 242 ms"; 32 [labelType="html" label="Sort sort time: 22 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 33 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 643.1 KiB number of coalesced partitions: 1"]; 34 [labelType="html" label="Exchange shuffle records written: 70,654 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 3 ms (1 ms, 2 ms, 2 ms (stage 6999.0: task 9101)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 70,654 local bytes read: 611.3 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 7.7 MiB (3.1 MiB, 4.6 MiB, 4.6 MiB (stage 6999.0: task 9101)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 611.3 KiB (245.4 KiB, 365.9 KiB, 365.9 KiB (stage 6999.0: task 9101))"]; subgraph cluster35 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n581 ms (273 ms, 308 ms, 308 ms (stage 6999.0: task 9101))"; 36 [labelType="html" label=" Project "]; } 37 [labelType="html" label="CartesianProduct number of output rows: 70,654"]; subgraph cluster38 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n581 ms (273 ms, 308 ms, 308 ms (stage 6999.0: task 9101))"; 39 [labelType="html" label=" Project "]; 40 [labelType="html" label="ColumnarToRow number of output rows: 70,654 number of input batches: 18"]; } 41 [labelType="html" label="Scan parquet number of files read: 2 scan time total (min, med, max (stageId: taskId)) 8 ms (3 ms, 5 ms, 5 ms (stage 6999.0: task 9101)) metadata time: 0 ms size of files read: 2.3 MiB number of output rows: 70,654"]; subgraph cluster42 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n19 ms (5 ms, 14 ms, 14 ms (stage 6999.0: task 9102))"; 43 [labelType="html" label=" Project "]; 44 [labelType="html" label="Filter number of output rows: 2"]; } 45 [labelType="html" label="Scan csv number of output rows: 2 number of files read: 1 metadata time: 0 ms size of files read: 175.0 B"]; subgraph cluster46 { isCluster="true"; label="WholeStageCodegen (9)\n \nduration: 8.1 m"; 47 [labelType="html" label="Sort sort time: 18 ms peak memory: 18.0 MiB spill size: 0.0 B"]; } 48 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 413.7 KiB number of coalesced partitions: 1"]; 49 [labelType="html" label="Exchange shuffle records written: 56,805 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 32 ms (1 ms, 2 ms, 10 ms (stage 7000.0: task 9110)) remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 56,805 local bytes read: 394.3 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 10 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 5.8 MiB (561.9 KiB, 589.0 KiB, 628.1 KiB (stage 7000.0: task 9103)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 394.3 KiB (37.2 KiB, 39.4 KiB, 41.4 KiB (stage 7000.0: task 9103))"]; subgraph cluster50 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n1.0 s (36 ms, 116 ms, 126 ms (stage 7000.0: task 9109))"; 51 [labelType="html" label=" Project "]; 52 [labelType="html" label="Filter number of output rows: 56,805"]; 53 [labelType="html" label="ColumnarToRow number of output rows: 56,805 number of input batches: 20"]; } 54 [labelType="html" label="Scan parquet number of files read: 10 scan time total (min, med, max (stageId: taskId)) 75 ms (3 ms, 7 ms, 16 ms (stage 7000.0: task 9105)) metadata time: 0 ms size of files read: 4.0 MiB number of output rows: 56,805"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 9->8; 10->9; 11->10; 12->11; 13->12; 14->13; 15->14; 17->15; 18->17; 19->18; 21->19; 22->21; 23->22; 25->23; 26->25; 27->26; 29->27; 30->29; 32->30; 33->32; 34->33; 36->34; 37->36; 39->37; 40->39; 41->40; 43->37; 44->43; 45->44; 47->19; 48->47; 49->48; 51->49; 52->51; 53->52; 54->53; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081], Overwrite, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586, COL_D055870D_7682_4410_A82D_BC4C41964169, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26, COL_63CCC378_62A4_4226_A892_27ED03D11185, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_8081145F_99B8_4EEC_AAB4_325C38549922, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8, COL_032696D7_7058_44F0_ABC3_DB207100F75A, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D]

WriteFiles

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Ajout de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2)))), str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Suppression de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#586189, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 4), !, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule((((((COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734 <=> 2) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -) END), 1, ) AS COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_extract_key_value(COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 3))), VALUE), str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, str_list_as_str(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712) AS COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008]

Generate explode(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712), [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734], false, [COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762]

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, str_join(array(str_join(array(SIC/SIM Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523)), : ), str_join(array(SIC/SIM dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544)), : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336)), : )), - ) AS COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)) AS COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712]

Filter ((COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)))))

WholeStageCodegen (11)

Window [collect_set(COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST]

Sort [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST], false, 0

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888 AS COL_D055870D_7682_4410_A82D_BC4C41964169#585183, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926 AS COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927 AS COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]

SortMergeJoin [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892], LeftOuter

WholeStageCodegen (10)

Filter (COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619 <=> 1)

WholeStageCodegen (8)

Window [concatwithseparatorudaf(_w0#584499, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@1f06f236, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

Sort [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, str_list_as_str(COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251) AS COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, ARRAY_TO_STR_BEFORE_CONCAT(COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131) AS _w0#584499]

WholeStageCodegen (7)

Window [collect_set(COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228], [1 DESC NULLS LAST]

Sort [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (6)

Window [collect_set(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_63CCC378_62A4_4226_A892_27ED03D11185#584400], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

Sort [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, 10), ENSURE_REQUIREMENTS, [plan_id=361859]

Project [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140 AS COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, LEFT) AS COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, RIGHT) AS COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]

WholeStageCodegen (3)

CartesianProduct

Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742 AS COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783 AS COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775 AS COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790 AS COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742,COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775,COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_F45E0732_AB66_4936_AECE_1F9475288E1E:s...

Project [APPLICABLE#583722 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140]

Filter ((isnotnull(REGLES#583721) AND (RC-SIC/SIM = REGLES#583721)) AND (APPLICABLE#583722 <=> O))

WholeStageCodegen (2)

FileScan csv [REGLES#583721,APPLICABLE#583722] Batched: false, DataFilters: [isnotnull(REGLES#583721), (RC-SIC/SIM = REGLES#583721), (APPLICABLE#583722 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SIC/SIM), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>

Sort [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892 ASC NULLS FIRST], false, 0

WholeStageCodegen (9)

AQEShuffleRead coalesced

Exchange hashpartitioning(02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 10), ENSURE_REQUIREMENTS, [plan_id=361904]

Project [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852 AS 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856 AS 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890 AS 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891 AS 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]

Filter isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856)

ColumnarToRow

WholeStageCodegen (4)

FileScan parquet [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852,COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856,COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890,COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891] Batched: true, DataFilters: [isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_225697], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)], ReadSchema: struct<COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (82)
+- == Final Plan ==
   Execute InsertIntoHadoopFsRelationCommand (45)
   +- WriteFiles (44)
      +- * Project (43)
         +- * Project (42)
            +- * Project (41)
               +- * Project (40)
                  +- * Project (39)
                     +- * Generate (38)
                        +- * Project (37)
                           +- * Project (36)
                              +- * Project (35)
                                 +- * Project (34)
                                    +- * Filter (33)
                                       +- Window (32)
                                          +- * Sort (31)
                                             +- * Project (30)
                                                +- * SortMergeJoin LeftOuter (29)
                                                   :- * Project (20)
                                                   :  +- * Filter (19)
                                                   :     +- Window (18)
                                                   :        +- * Sort (17)
                                                   :           +- * Project (16)
                                                   :              +- Window (15)
                                                   :                 +- * Sort (14)
                                                   :                    +- Window (13)
                                                   :                       +- * Sort (12)
                                                   :                          +- AQEShuffleRead (11)
                                                   :                             +- ShuffleQueryStage (10), Statistics(sizeInBytes=7.7 MiB, rowCount=7.07E+4)
                                                   :                                +- Exchange (9)
                                                   :                                   +- * Project (8)
                                                   :                                      +- CartesianProduct Inner (7)
                                                   :                                         :- * Project (3)
                                                   :                                         :  +- * ColumnarToRow (2)
                                                   :                                         :     +- Scan parquet  (1)
                                                   :                                         +- * Project (6)
                                                   :                                            +- * Filter (5)
                                                   :                                               +- Scan csv  (4)
                                                   +- * Sort (28)
                                                      +- AQEShuffleRead (27)
                                                         +- ShuffleQueryStage (26), Statistics(sizeInBytes=5.8 MiB, rowCount=5.68E+4)
                                                            +- Exchange (25)
                                                               +- * Project (24)
                                                                  +- * Filter (23)
                                                                     +- * ColumnarToRow (22)
                                                                        +- Scan parquet  (21)
+- == Initial Plan ==
   Execute InsertIntoHadoopFsRelationCommand (81)
   +- WriteFiles (80)
      +- Project (79)
         +- Project (78)
            +- Project (77)
               +- Project (76)
                  +- Project (75)
                     +- Generate (74)
                        +- Project (73)
                           +- Project (72)
                              +- Project (71)
                                 +- Project (70)
                                    +- Filter (69)
                                       +- Window (68)
                                          +- Sort (67)
                                             +- Project (66)
                                                +- SortMergeJoin LeftOuter (65)
                                                   :- Project (60)
                                                   :  +- Filter (59)
                                                   :     +- Window (58)
                                                   :        +- Sort (57)
                                                   :           +- Project (56)
                                                   :              +- Window (55)
                                                   :                 +- Sort (54)
                                                   :                    +- Window (53)
                                                   :                       +- Sort (52)
                                                   :                          +- Exchange (51)
                                                   :                             +- Project (50)
                                                   :                                +- CartesianProduct Inner (49)
                                                   :                                   :- Project (46)
                                                   :                                   :  +- Scan parquet  (1)
                                                   :                                   +- Project (48)
                                                   :                                      +- Filter (47)
                                                   :                                         +- Scan csv  (4)
                                                   +- Sort (64)
                                                      +- Exchange (63)
                                                         +- Project (62)
                                                            +- Filter (61)
                                                               +- Scan parquet  (21)


(1) Scan parquet 
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_225863]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_F45E0732_AB66_4936_AECE_1F9475288E1E:string,COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>

(2) ColumnarToRow [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790]

(3) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742 AS COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783 AS COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775 AS COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790 AS COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790]

(4) Scan csv 
Output [2]: [REGLES#583721, APPLICABLE#583722]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_225515/REGLES-A-TTT new.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SIC/SIM), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>

(5) Filter [codegen id : 2]
Input [2]: [REGLES#583721, APPLICABLE#583722]
Condition : ((isnotnull(REGLES#583721) AND (RC-SIC/SIM = REGLES#583721)) AND (APPLICABLE#583722 <=> O))

(6) Project [codegen id : 2]
Output [1]: [APPLICABLE#583722 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140]
Input [2]: [REGLES#583721, APPLICABLE#583722]

(7) CartesianProduct
Join type: Inner
Join condition: None

(8) Project [codegen id : 3]
Output [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140 AS COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, LEFT) AS COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, RIGHT) AS COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Input [5]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140]

(9) Exchange
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: hashpartitioning(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, 10), ENSURE_REQUIREMENTS, [plan_id=361859]

(10) ShuffleQueryStage
Output [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: 0

(11) AQEShuffleRead
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: coalesced

(12) Sort [codegen id : 5]
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

(13) Window
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: [collect_set(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_63CCC378_62A4_4226_A892_27ED03D11185#584400], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

(14) Sort [codegen id : 6]
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(15) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400]
Arguments: [collect_set(COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228], [1 DESC NULLS LAST]

(16) Project [codegen id : 7]
Output [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, str_list_as_str(COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251) AS COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, ARRAY_TO_STR_BEFORE_CONCAT(COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131) AS _w0#584499]
Input [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251]

(17) Sort [codegen id : 7]
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

(18) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499]
Arguments: [concatwithseparatorudaf(_w0#584499, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@1f06f236, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

(19) Filter [codegen id : 8]
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619]
Condition : (COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619 <=> 1)

(20) Project [codegen id : 8]
Output [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151]
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619]

(21) Scan parquet 
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/02_A_ELIGIBLE_225697]
PushedFilters: [IsNotNull(COL_F76265AB_8748_4114_92B4_00E37DE25D34)]
ReadSchema: struct<COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB:string,COL_F76265AB_8748_4114_92B4_00E37DE25D34:string,COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF:array<string>,COL_AA499A88_B893_47E4_99C5_0EB9F6D69842:string>

(22) ColumnarToRow [codegen id : 4]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]

(23) Filter [codegen id : 4]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]
Condition : isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856)

(24) Project [codegen id : 4]
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852 AS 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856 AS 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890 AS 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891 AS 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]

(25) Exchange
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: hashpartitioning(02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 10), ENSURE_REQUIREMENTS, [plan_id=361904]

(26) ShuffleQueryStage
Output [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: 1

(27) AQEShuffleRead
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: coalesced

(28) Sort [codegen id : 9]
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892 ASC NULLS FIRST], false, 0

(29) SortMergeJoin [codegen id : 10]
Left keys [1]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128]
Right keys [1]: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892]
Join type: LeftOuter
Join condition: None

(30) Project [codegen id : 10]
Output [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888 AS COL_D055870D_7682_4410_A82D_BC4C41964169#585183, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926 AS COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927 AS COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Input [13]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]

(31) Sort [codegen id : 10]
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST], false, 0

(32) Window
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Arguments: [collect_set(COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST]

(33) Filter [codegen id : 11]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393]
Condition : ((COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)))))

(34) Project [codegen id : 11]
Output [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130) AS COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393]

(35) Project [codegen id : 11]
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, array_except(array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523, array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503)) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503]

(36) Project [codegen id : 11]
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, str_join(array(str_join(array(SIC/SIM Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523)),  : ), str_join(array(SIC/SIM dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336)),  : )),  - ) AS COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)) AS COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544]

(37) Project [codegen id : 11]
Output [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, size(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, true) AS COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712]

(38) Generate [codegen id : 11]
Input [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734]
Arguments: explode(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712), [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734], false, [COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762]

(39) Project [codegen id : 11]
Output [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, str_create(RC-SIC/SIM) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, str_remove_space(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911]
Input [17]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762]

(40) Project [codegen id : 11]
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_extract_key_value(COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 3))), VALUE), str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, str_list_as_str(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712) AS COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008]
Input [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911]

(41) Project [codegen id : 11]
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964) AS COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008]

(42) Project [codegen id : 11]
Output [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 4), !, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule((((((COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734 <=> 2) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -) END), 1, ) AS COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037]

(43) Project [codegen id : 11]
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Ajout de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2)))), str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Suppression de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#586189, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]
Input [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

(44) WriteFiles
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#586189, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

(45) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081], Overwrite, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586, COL_D055870D_7682_4410_A82D_BC4C41964169, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26, COL_63CCC378_62A4_4226_A892_27ED03D11185, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_8081145F_99B8_4EEC_AAB4_325C38549922, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8, COL_032696D7_7058_44F0_ABC3_DB207100F75A, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D]

(46) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742 AS COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783 AS COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775 AS COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790 AS COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#583742, COL_F45E0732_AB66_4936_AECE_1F9475288E1E#583775, COL_81B86243_0BBB_463E_BE7E_73AEE16D2DD0#583783, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#583790]

(47) Filter
Input [2]: [REGLES#583721, APPLICABLE#583722]
Condition : ((isnotnull(REGLES#583721) AND (RC-SIC/SIM = REGLES#583721)) AND (APPLICABLE#583722 <=> O))

(48) Project
Output [1]: [APPLICABLE#583722 AS REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140]
Input [2]: [REGLES#583721, APPLICABLE#583722]

(49) CartesianProduct
Join type: Inner
Join condition: None

(50) Project
Output [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140 AS COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, LEFT) AS COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, str_extract_by_str(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, *, RIGHT) AS COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Input [5]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, REGLES_A_APPLIQ_225642_APPLICABLE_225644#584140]

(51) Exchange
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: hashpartitioning(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, 10), ENSURE_REQUIREMENTS, [plan_id=361795]

(52) Sort
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

(53) Window
Input [7]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228]
Arguments: [collect_set(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_63CCC378_62A4_4226_A892_27ED03D11185#584400], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

(54) Sort
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(55) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400]
Arguments: [collect_set(COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228], [1 DESC NULLS LAST]

(56) Project
Output [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, str_list_as_str(COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251) AS COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, ARRAY_TO_STR_BEFORE_CONCAT(COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131) AS _w0#584499]
Input [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_78C988B2_E2FD_4525_8EDA_2C30D12E6A35#584220, COL_15562112_F77D_4D34_9215_7F07DD688A1B#584228, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_E15BC217_89FD_48B1_894D_633DA7FB5F82#584251]

(57) Sort
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST], false, 0

(58) Window
Input [8]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499]
Arguments: [concatwithseparatorudaf(_w0#584499, com.adb.hdh.spark.job.scala.utils.ConcatWithSeparatorUDAF@1f06f236, class[value[0]: string], class[value[0]: string], true, true, 0, 0, None) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130 ASC NULLS LAST]

(59) Filter
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619]
Condition : (COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619 <=> 1)

(60) Project
Output [9]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151]
Input [10]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, _w0#584499, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619]

(61) Filter
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]
Condition : isnotnull(COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856)

(62) Project
Output [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852 AS 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856 AS 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890 AS 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891 AS 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Input [4]: [COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#583852, COL_F76265AB_8748_4114_92B4_00E37DE25D34#583856, COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#583890, COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#583891]

(63) Exchange
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: hashpartitioning(02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 10), ENSURE_REQUIREMENTS, [plan_id=361809]

(64) Sort
Input [4]: [02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]
Arguments: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892 ASC NULLS FIRST], false, 0

(65) SortMergeJoin
Left keys [1]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128]
Right keys [1]: [02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892]
Join type: LeftOuter
Join condition: None

(66) Project
Output [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888 AS COL_D055870D_7682_4410_A82D_BC4C41964169#585183, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926 AS COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927 AS COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Input [13]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, 02_A_ELIGIBLE_225697_COL_F44B0D19_6A77_4497_88B3_B9698DF17BCB#584888, 02_A_ELIGIBLE_225697_COL_F76265AB_8748_4114_92B4_00E37DE25D34#584892, 02_A_ELIGIBLE_225697_COL_B8D0B7A4_71CB_4406_88C1_4791F02E29EF#584926, 02_A_ELIGIBLE_225697_COL_AA499A88_B893_47E4_99C5_0EB9F6D69842#584927]

(67) Sort
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Arguments: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128 ASC NULLS FIRST, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST], false, 0

(68) Window
Input [12]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185]
Arguments: [collect_set(COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, 0, 0) windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, row_number() windowspecdefinition(COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393], [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128], [COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185 DESC NULLS LAST]

(69) Filter
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393]
Condition : ((COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393 <=> 1) AND ((size(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)), true) > 0) AND isnotnull(str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184)), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130)))), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)))))

(70) Project
Output [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_if_with_rule(isnull(COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130), , COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130) AS COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_EB09F0CA_8A1F_4C0B_9948_FDB31E88D9C7#585393]

(71) Project
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, array_except(array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503), COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184) AS COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523, array_except(COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, array(COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503)) AS COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544]
Input [14]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_EF390B5B_D21B_462C_B13D_B1595E80ADEF#585503]

(72) Project
Output [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, str_join(array(str_join(array(SIC/SIM Déduit Infos Patient absent RSF, str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523)),  : ), str_join(array(SIC/SIM dans RSF et absent des Infos Patient, str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544)),  : ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336)),  : )),  - ) AS COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, str_list_union(str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523), [SIM,SIC], [SIM+,SIC+]), [[,",]], [,,]), ,), str_split(str_replace_extend(str_replace_extend(str_list_as_str(COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544), [SIM,SIC], [SIM-,SIC-]), [[,",]], [,,]), ,)) AS COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_2866C1E2_03BF_4FA0_9FA8_D6F663CFD2E7#585523, COL_B0D6496E_B0F2_4B34_A287_E3A96F7A3CEF#585544]

(73) Project
Output [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, size(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, true) AS COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734]
Input [15]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712]

(74) Generate
Input [16]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734]
Arguments: explode(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712), [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734], false, [COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762]

(75) Project
Output [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, str_create(RC-SIC/SIM) AS COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, str_remove_space(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, ALL) AS COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911]
Input [17]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762]

(76) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_extract_key_value(COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, ;, !, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 3), str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 3))), VALUE), str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT)) AS COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, str_list_as_str(COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712) AS COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008]
Input [19]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_C9106B81_8F34_4602_BD0C_4F0EED98B8C8#585712, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911]

(77) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, str_if_with_rule(CASE WHEN isnull(Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, ,)) THEN false ELSE Contains(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, ,) END, str_list_get(str_split(str_remove_extend(COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, [[,], ]), ,), 0), COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964) AS COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_1DE9F16A_CDC3_40A3_B39F_2E5935A39949#585964, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008]

(78) Project
Output [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, str_concat(array(str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, LEFT, 4), !, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, _, str_extract(COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, RIGHT, 2))) AS COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule((((((COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734 <=> 2) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIC) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, SIM) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, +) END) AND CASE WHEN isnull(Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -)) THEN false ELSE Contains(COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, -) END), 1, ) AS COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_52951A0A_93BF_4E9A_B761_E8E6DCE4DE60#585911, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037]

(79) Project
Output [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, str_if_with_rule(CASE WHEN isnull(Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +)) THEN false ELSE Contains(COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, +) END, str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Ajout de forfait@, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, @, str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2)))), str_if_with_rule((COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098 <=> 1), str_concat(array(Switch de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))), str_concat(array(Suppression de Forfait@, str_concat(array(str_extract_by_str(COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, !, RIGHT), @)), str_extract(COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, RIGHT, 2))))) AS COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#586189, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]
Input [21]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_3CCB47AD_5834_4DF7_9C15_97F35E752EA6#585762, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_09828A80_5710_4A69_8FAA_FFA497D3BDBA#586037, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

(80) WriteFiles
Input [20]: [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586#584128, COL_D055870D_7682_4410_A82D_BC4C41964169#585183, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5#584130, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26#584131, COL_63CCC378_62A4_4226_A892_27ED03D11185#584400, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6#584491, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854#585184, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C#585185, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77#585886, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2#586067, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30#586189, COL_8081145F_99B8_4EEC_AAB4_325C38549922#584619, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8#585646, COL_032696D7_7058_44F0_ABC3_DB207100F75A#584132, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D#585336, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358#584362, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B#584151, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46#585734, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165#586008, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D#586098]

(81) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR6_SIC_SIM_226081], Overwrite, [COL_32F739B2_1E09_4FE7_8AEE_4EAB7D20E586, COL_D055870D_7682_4410_A82D_BC4C41964169, COL_1C67BACF_1B65_4A59_B0AD_E458D86429D5, COL_658DDA2B_EB4A_460F_BDE0_BEB40D7FFD26, COL_63CCC378_62A4_4226_A892_27ED03D11185, COL_EC9C5E15_381A_4B20_8C15_EBE5E36720D6, COL_8A0D1AEA_708F_4608_A4E4_33445D2C0854, COL_DADBEFF1_C4E6_4B38_8C84_412222189B8C, COL_EDD3F0DE_BCA6_41F2_AA00_4FA398668A77, COL_800B4DCB_AD36_4EB0_9102_1CFF32E954E2, COL_4C6AEE3F_9B75_4BCF_8273_85E282B6FC30, COL_8081145F_99B8_4EEC_AAB4_325C38549922, COL_C7286809_1984_4EC7_AE1D_DBDAAD16E6E8, COL_032696D7_7058_44F0_ABC3_DB207100F75A, COL_AB2F274E_7EA4_4613_A9D9_D07AEEC5892D, COL_E7365694_DACE_4ABE_A9AA_A8D2C12B0358, COL_E6D2D4F2_F182_4E39_AE7F_5F932052634B, COL_1CBB4132_AC3B_4AB3_AE05_73C78F1DDA46, COL_B71A674B_07E8_43D5_B8EC_BCA24B06E165, COL_5A5A240B_0DBB_4F26_A909_8D075C53989D]

(82) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet