digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 10 ms<br>number of output rows: 1,063<br>number of dynamic part: 0<br>written output: 42.9 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (12)\n \nduration: 234 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<b>Generate</b><br><br>number of output rows: 1,063"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<br><b>Project</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
9 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 1,061<br>spill size: 0.0 B"];
}
subgraph cluster10 {
isCluster="true";
label="WholeStageCodegen (10)\n \nduration: 295 ms";
11 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.3 MiB<br>spill size: 0.0 B"];
12 [labelType="html" label="<br><b>Project</b><br><br>"];
13 [labelType="html" label="<br><b>Project</b><br><br>"];
}
14 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 10,616<br>time in aggregation build: 25 ms<br>spill size: 0.0 B<br>number of sort fallback tasks: 1"];
15 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 630.7 KiB<br>number of coalesced partitions: 1"];
16 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 10,616<br>local merged chunks fetched: 0<br>shuffle write time: 2 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 10,616<br>local bytes read: 597.1 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 2.3 MiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 597.1 KiB"];
17 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 10,616<br>time in aggregation build: 62 ms<br>spill size: 0.0 B<br>number of sort fallback tasks: 1"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (9)\n \nduration: 61 ms";
19 [labelType="html" label="<br><b>Project</b><br><br>"];
20 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 24,063<br>spill size: 0.0 B"];
}
subgraph cluster21 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 64 ms";
22 [labelType="html" label="<b>Sort</b><br><br>sort time: 4 ms<br>peak memory: 17.0 MiB<br>spill size: 0.0 B"];
}
23 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 590.3 KiB<br>number of coalesced partitions: 1"];
24 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 24,063<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>4 ms (2 ms, 2 ms, 2 ms (stage 14710.0: task 20411))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 24,063<br>local bytes read: 562.5 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 2<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>3.3 MiB (1671.3 KiB, 1704.2 KiB, 1704.2 KiB (stage 14710.0: task 20411))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>562.5 KiB (278.8 KiB, 283.7 KiB, 283.7 KiB (stage 14710.0: task 20411))"];
subgraph cluster25 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n137 ms (66 ms, 71 ms, 71 ms (stage 14710.0: task 20412))";
26 [labelType="html" label="<br><b>Project</b><br><br>"];
}
27 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 24,063"];
28 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 24,063"];
subgraph cluster29 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n138 ms (67 ms, 71 ms, 71 ms (stage 14710.0: task 20412))";
30 [labelType="html" label="<br><b>Project</b><br><br>"];
31 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 24,063"];
32 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 24,063<br>number of input batches: 6"];
}
33 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 2<br>scan time total (min, med, max (stageId: taskId))<br>45 ms (17 ms, 28 ms, 28 ms (stage 14710.0: task 20412))<br>metadata time: 0 ms<br>size of files read: 1518.7 KiB<br>number of output rows: 24,063"];
subgraph cluster34 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n9 ms (4 ms, 5 ms, 5 ms (stage 14710.0: task 20412))";
35 [labelType="html" label="<br><b>Project</b><br><br>"];
36 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
}
37 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 2<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.0 B"];
subgraph cluster38 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n14 ms (6 ms, 8 ms, 8 ms (stage 14710.0: task 20412))";
39 [labelType="html" label="<br><b>Project</b><br><br>"];
40 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 2"];
}
41 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 2<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 175.0 B"];
subgraph cluster42 {
isCluster="true";
label="WholeStageCodegen (8)\n \nduration: 62 ms";
43 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.3 MiB<br>spill size: 0.0 B"];
}
44 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 56.6 KiB<br>number of coalesced partitions: 1"];
45 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 5,638<br>local merged chunks fetched: 0<br>shuffle write time: 2 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 5,638<br>local bytes read: 54.0 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 256.2 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 54.0 KiB"];
subgraph cluster46 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 13 ms";
47 [labelType="html" label="<br><b>Project</b><br><br>"];
48 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 5,638"];
49 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 5,638<br>number of input batches: 2"];
}
50 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 5 ms<br>metadata time: 0 ms<br>size of files read: 35.4 KiB<br>number of output rows: 5,638"];
subgraph cluster51 {
isCluster="true";
label="WholeStageCodegen (11)\n \nduration: 0 ms";
52 [labelType="html" label="<b>Sort</b><br><br>sort time: 2 ms<br>peak memory: 16.3 MiB<br>spill size: 0.0 B"];
}
53 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 258.2 KiB<br>number of coalesced partitions: 1"];
54 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 10,259<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>115 ms (1 ms, 3 ms, 26 ms (stage 14712.0: task 20418))<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 10,259<br>local bytes read: 245.8 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 10<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>779.3 KiB (75.3 KiB, 78.0 KiB, 79.8 KiB (stage 14712.0: task 20416))<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written total (min, med, max (stageId: taskId))<br>245.8 KiB (23.9 KiB, 24.6 KiB, 25.2 KiB (stage 14712.0: task 20414))"];
subgraph cluster55 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n136 ms (4 ms, 13 ms, 41 ms (stage 14712.0: task 20415))";
56 [labelType="html" label="<br><b>Project</b><br><br>"];
57 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10,259"];
58 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 10,259<br>number of input batches: 10"];
}
59 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>91 ms (2 ms, 6 ms, 35 ms (stage 14712.0: task 20415))<br>metadata time: 0 ms<br>size of files read: 1869.8 KiB<br>number of output rows: 10,259"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
8->7;
9->8;
11->9;
12->11;
13->12;
14->13;
15->14;
16->15;
17->16;
19->17;
20->19;
22->20;
23->22;
24->23;
26->24;
27->26;
28->27;
30->28;
31->30;
32->31;
33->32;
35->28;
36->35;
37->36;
39->27;
40->39;
41->40;
43->20;
44->43;
45->44;
47->45;
48->47;
49->48;
50->49;
52->9;
53->52;
54->53;
56->54;
57->56;
58->57;
59->58;
}
60
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]
WriteFiles
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1144824, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1144826, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Generate explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699]
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650]
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600, str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611]
SortMergeJoin [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312], [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412], Inner, ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))
WholeStageCodegen (12)
Sort [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312 ASC NULLS FIRST], false, 0
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
Project [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320]
WholeStageCodegen (10)
ObjectHashAggregate(keys=[COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425], functions=[collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)])
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, 10), ENSURE_REQUIREMENTS, [plan_id=648518]
ObjectHashAggregate(keys=[COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425], functions=[partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)])
Project [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
SortMergeJoin [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427], [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842], LeftOuter
WholeStageCodegen (9)
Sort [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427 ASC NULLS FIRST], false, 0
WholeStageCodegen (7)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, 10), ENSURE_REQUIREMENTS, [plan_id=648163]
Project [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, REGLES_A_APPLIQ_172230_REGLES_172231#1143590 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
WholeStageCodegen (4)
CartesianProduct
CartesianProduct
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_172578], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990:s...
Project
Filter ((isnotnull(REGLES#1142957) AND (RC-SUF-SUN = REGLES#1142957)) AND (APPLICABLE#1142958 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#1142957,APPLICABLE#1142958] Batched: false, DataFilters: [isnotnull(REGLES#1142957), (RC-SUF-SUN = REGLES#1142957), (APPLICABLE#1142958 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUF-SUN), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
Project [REGLES#1143593 AS REGLES_A_APPLIQ_172230_REGLES_172231#1143590]
Filter (isnotnull(REGLES#1143593) AND (RC-SUN-AUTO = REGLES#1143593))
WholeStageCodegen (3)
FileScan csv [REGLES#1143593] Batched: false, DataFilters: [isnotnull(REGLES#1143593), (RC-SUN-AUTO = REGLES#1143593)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new..., PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO)], ReadSchema: struct<REGLES:string>
Sort [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842 ASC NULLS FIRST], false, 0
WholeStageCodegen (8)
AQEShuffleRead coalesced
Exchange hashpartitioning(00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 10), ENSURE_REQUIREMENTS, [plan_id=648201]
Project [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091 AS 00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093 AS 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Filter isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091)
ColumnarToRow
WholeStageCodegen (5)
FileScan parquet [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093] Batched: true, DataFilters: [isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_172443], PartitionFilters: [], PushedFilters: [IsNotNull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D)], ReadSchema: struct<COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D:string,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3:s...
Sort [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412 ASC NULLS FIRST], false, 0
WholeStageCodegen (11)
AQEShuffleRead coalesced
Exchange hashpartitioning(03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 10), ENSURE_REQUIREMENTS, [plan_id=648237]
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500 AS 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504 AS 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524 AS 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Filter isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504)
ColumnarToRow
WholeStageCodegen (6)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504,COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524] Batched: true, DataFilters: [isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_172408], PartitionFilters: [], PushedFilters: [IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)], ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:s...
== Physical Plan ==
AdaptiveSparkPlan (87)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (51)
+- WriteFiles (50)
+- * Project (49)
+- * Generate (48)
+- * Project (47)
+- * Project (46)
+- * Project (45)
+- * SortMergeJoin Inner (44)
:- * Sort (35)
: +- * Project (34)
: +- * Project (33)
: +- ObjectHashAggregate (32)
: +- AQEShuffleRead (31)
: +- ShuffleQueryStage (30), Statistics(sizeInBytes=2.3 MiB, rowCount=1.06E+4)
: +- Exchange (29)
: +- ObjectHashAggregate (28)
: +- * Project (27)
: +- * SortMergeJoin LeftOuter (26)
: :- * Sort (17)
: : +- AQEShuffleRead (16)
: : +- ShuffleQueryStage (15), Statistics(sizeInBytes=3.3 MiB, rowCount=2.41E+4)
: : +- Exchange (14)
: : +- * Project (13)
: : +- CartesianProduct Inner (12)
: : :- CartesianProduct Inner (8)
: : : :- * Project (4)
: : : : +- * Filter (3)
: : : : +- * ColumnarToRow (2)
: : : : +- Scan parquet (1)
: : : +- * Project (7)
: : : +- * Filter (6)
: : : +- Scan csv (5)
: : +- * Project (11)
: : +- * Filter (10)
: : +- Scan csv (9)
: +- * Sort (25)
: +- AQEShuffleRead (24)
: +- ShuffleQueryStage (23), Statistics(sizeInBytes=256.2 KiB, rowCount=5.64E+3)
: +- Exchange (22)
: +- * Project (21)
: +- * Filter (20)
: +- * ColumnarToRow (19)
: +- Scan parquet (18)
+- * Sort (43)
+- AQEShuffleRead (42)
+- ShuffleQueryStage (41), Statistics(sizeInBytes=779.3 KiB, rowCount=1.03E+4)
+- Exchange (40)
+- * Project (39)
+- * Filter (38)
+- * ColumnarToRow (37)
+- Scan parquet (36)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (86)
+- WriteFiles (85)
+- Project (84)
+- Generate (83)
+- Project (82)
+- Project (81)
+- Project (80)
+- SortMergeJoin Inner (79)
:- Sort (74)
: +- Project (73)
: +- Project (72)
: +- ObjectHashAggregate (71)
: +- Exchange (70)
: +- ObjectHashAggregate (69)
: +- Project (68)
: +- SortMergeJoin LeftOuter (67)
: :- Sort (62)
: : +- Exchange (61)
: : +- Project (60)
: : +- CartesianProduct Inner (59)
: : :- CartesianProduct Inner (56)
: : : :- Project (53)
: : : : +- Filter (52)
: : : : +- Scan parquet (1)
: : : +- Project (55)
: : : +- Filter (54)
: : : +- Scan csv (5)
: : +- Project (58)
: : +- Filter (57)
: : +- Scan csv (9)
: +- Sort (66)
: +- Exchange (65)
: +- Project (64)
: +- Filter (63)
: +- Scan parquet (18)
+- Sort (78)
+- Exchange (77)
+- Project (76)
+- Filter (75)
+- Scan parquet (36)
(1) Scan parquet
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_172578]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990:string,COL_60F0AF6F_D3F7_485E_B349_92A30BE52743:string,COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A:string>
(2) ColumnarToRow [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
(3) Filter [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046)
(4) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
(5) Scan csv
Output [2]: [REGLES#1142957, APPLICABLE#1142958]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new Aigle.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUF-SUN), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#1142957, APPLICABLE#1142958]
Condition : ((isnotnull(REGLES#1142957) AND (RC-SUF-SUN = REGLES#1142957)) AND (APPLICABLE#1142958 <=> O))
(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#1142957, APPLICABLE#1142958]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Scan csv
Output [1]: [REGLES#1143593]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_172102/REGLES-A-TTT new Aigle.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUN-AUTO)]
ReadSchema: struct<REGLES:string>
(10) Filter [codegen id : 3]
Input [1]: [REGLES#1143593]
Condition : (isnotnull(REGLES#1143593) AND (RC-SUN-AUTO = REGLES#1143593))
(11) Project [codegen id : 3]
Output [1]: [REGLES#1143593 AS REGLES_A_APPLIQ_172230_REGLES_172231#1143590]
Input [1]: [REGLES#1143593]
(12) CartesianProduct
Join type: Inner
Join condition: None
(13) Project [codegen id : 4]
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, REGLES_A_APPLIQ_172230_REGLES_172231#1143590 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, REGLES_A_APPLIQ_172230_REGLES_172231#1143590]
(14) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, 10), ENSURE_REQUIREMENTS, [plan_id=648163]
(15) ShuffleQueryStage
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: 0
(16) AQEShuffleRead
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: coalesced
(17) Sort [codegen id : 7]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427 ASC NULLS FIRST], false, 0
(18) Scan parquet
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_G_ACTES_AUTO_172443]
PushedFilters: [IsNotNull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D)]
ReadSchema: struct<COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D:string,COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3:string>
(19) ColumnarToRow [codegen id : 5]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
(20) Filter [codegen id : 5]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091)
(21) Project [codegen id : 5]
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091 AS 00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093 AS 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
(22) Exchange
Input [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: hashpartitioning(00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 10), ENSURE_REQUIREMENTS, [plan_id=648201]
(23) ShuffleQueryStage
Output [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: 1
(24) AQEShuffleRead
Input [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: coalesced
(25) Sort [codegen id : 8]
Input [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842 ASC NULLS FIRST], false, 0
(26) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427]
Right keys [1]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842]
Join type: LeftOuter
Join condition: None
(27) Project [codegen id : 9]
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797, 00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
(28) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)]
Aggregate Attributes [2]: [buf#1144835, buf#1146338]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
(29) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, 10), ENSURE_REQUIREMENTS, [plan_id=648518]
(30) ShuffleQueryStage
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Arguments: 3
(31) AQEShuffleRead
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Arguments: coalesced
(32) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0)#1144294, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)#1144296]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0)#1144294 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)#1144296 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
(33) Project [codegen id : 10]
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
(34) Project [codegen id : 10]
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320]
(35) Sort [codegen id : 10]
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312 ASC NULLS FIRST], false, 0
(36) Scan parquet
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_172408]
PushedFilters: [IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5:string>
(37) ColumnarToRow [codegen id : 6]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
(38) Filter [codegen id : 6]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504)
(39) Project [codegen id : 6]
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500 AS 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504 AS 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524 AS 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
(40) Exchange
Input [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: hashpartitioning(03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 10), ENSURE_REQUIREMENTS, [plan_id=648237]
(41) ShuffleQueryStage
Output [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: 2
(42) AQEShuffleRead
Input [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: coalesced
(43) Sort [codegen id : 11]
Input [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412 ASC NULLS FIRST], false, 0
(44) SortMergeJoin [codegen id : 12]
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312]
Right keys [1]: [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412]
Join type: Inner
Join condition: ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))
(45) Project [codegen id : 12]
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600, str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
(46) Project [codegen id : 12]
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611]
(47) Project [codegen id : 12]
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650]
(48) Generate [codegen id : 12]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699]
(49) Project [codegen id : 12]
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1144824, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1144826, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699]
(50) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1144824, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1144826, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
(51) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]
(52) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046)
(53) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046 AS COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048 AS COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083 AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094 AS COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#1143046, COL_B01E4E9C_9C1A_413D_9FB4_F0E1F49B4990#1143048, COL_60F0AF6F_D3F7_485E_B349_92A30BE52743#1143083, COL_F23CCCC8_5C4A_4FB8_A318_67291E42693A#1143094]
(54) Filter
Input [2]: [REGLES#1142957, APPLICABLE#1142958]
Condition : ((isnotnull(REGLES#1142957) AND (RC-SUF-SUN = REGLES#1142957)) AND (APPLICABLE#1142958 <=> O))
(55) Project
Output: []
Input [2]: [REGLES#1142957, APPLICABLE#1142958]
(56) CartesianProduct
Join type: Inner
Join condition: None
(57) Filter
Input [1]: [REGLES#1143593]
Condition : (isnotnull(REGLES#1143593) AND (RC-SUN-AUTO = REGLES#1143593))
(58) Project
Output [1]: [REGLES#1143593 AS REGLES_A_APPLIQ_172230_REGLES_172231#1143590]
Input [1]: [REGLES#1143593]
(59) CartesianProduct
Join type: Inner
Join condition: None
(60) Project
Output [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, REGLES_A_APPLIQ_172230_REGLES_172231#1143590 AS COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, REGLES_A_APPLIQ_172230_REGLES_172231#1143590]
(61) Exchange
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: hashpartitioning(COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, 10), ENSURE_REQUIREMENTS, [plan_id=648074]
(62) Sort
Input [5]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797]
Arguments: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427 ASC NULLS FIRST], false, 0
(63) Filter
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
Condition : isnotnull(COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091)
(64) Project
Output [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091 AS 00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093 AS 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Input [2]: [COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1141091, COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1141093]
(65) Exchange
Input [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: hashpartitioning(00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 10), ENSURE_REQUIREMENTS, [plan_id=648075]
(66) Sort
Input [2]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
Arguments: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842 ASC NULLS FIRST], false, 0
(67) SortMergeJoin
Left keys [1]: [COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427]
Right keys [1]: [00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842]
Join type: LeftOuter
Join condition: None
(68) Project
Output [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, str_if_with_rule((COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797 <=> RC-SUN-AUTO), 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460) AS COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Input [7]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_332A283C_1564_41E0_AC8C_5944B976139C#1143427, COL_C6711610_DFEE_4846_8053_60113001EF1E#1143460, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, COL_349660B8_7BFF_4AEB_98B5_2A4240CFC81A#1143797, 00_G_ACTES_AUTO_172443_COL_2A3D5A6F_DCA8_4837_B9B8_92AE34634C3D#1143842, 00_G_ACTES_AUTO_172443_COL_DFE20096_AA5B_4B8F_A2AA_0A5C221F0EC3#1143844]
(69) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425]
Functions [2]: [partial_collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), partial_collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)]
Aggregate Attributes [2]: [buf#1144835, buf#1146338]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
(70) Exchange
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Arguments: hashpartitioning(COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, 10), ENSURE_REQUIREMENTS, [plan_id=648082]
(71) ObjectHashAggregate
Input [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425, buf#1144837, buf#1146339]
Keys [1]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425]
Functions [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0), collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)]
Aggregate Attributes [2]: [collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0)#1144294, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)#1144296]
Results [3]: [COL_DB984266_CA2D_46A3_97EF_B562B2758847#1143425 AS COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, collect_set(COL_C6711610_DFEE_4846_8053_60113001EF1E#1144228, 0, 0)#1144294 AS COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, collect_set(COL_84AE107B_9ED4_40F6_A5F1_EC8781652CC1#1143462, 0, 0)#1144296 AS COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
(72) Project
Output [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_list_get(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, 0) AS COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320]
Input [3]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
(73) Project
Output [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, str_if_with_rule((NOT (COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320 <=> ) AND isnotnull(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320)), str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, LEFT), null) AS COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, str_extract_by_str(COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320, !, RIGHT) AS COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
Input [4]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_C6A68181_B39A_48AA_AE59_D5AFEA1D4CBD#1144320]
(74) Sort
Input [5]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315]
Arguments: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312 ASC NULLS FIRST], false, 0
(75) Filter
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
Condition : isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504)
(76) Project
Output [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500 AS 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504 AS 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524 AS 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Input [3]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1140500, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1140504, COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1140524]
(77) Exchange
Input [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: hashpartitioning(03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 10), ENSURE_REQUIREMENTS, [plan_id=648088]
(78) Sort
Input [3]: [03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
Arguments: [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412 ASC NULLS FIRST], false, 0
(79) SortMergeJoin
Left keys [1]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312]
Right keys [1]: [03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412]
Join type: Inner
Join condition: ((size(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,), true) > 0) AND isnotnull(str_split(str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null)), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null))), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,), ,)))
(80) Project
Output [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408 AS COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 AS COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, str_if_with_rule(NOT (03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432 <=> ), str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, LEFT), null) AS COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600, str_extract_by_str(03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432, !, RIGHT) AS COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, 03_PIVOT_INFORM_172408_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#1144408, 03_PIVOT_INFORM_172408_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#1144412, 03_PIVOT_INFORM_172408_COL_F8DBDC17_BE98_41AF_8CD3_D2487EC91EE5#1144432]
(81) Project
Output [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, str_replace(str_remove_space(str_join(array(str_replace_extend(str_list_get(array_except(array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600), array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357)), 0), [SUN,SUF], [SUN-,SUF-]), str_replace_extend(str_list_get(array_except(array(COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357), array(COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600)), 0), [SUF,SUN], [SUF+,SUN+])), ), ONLY_ONE), , ,) AS COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650]
Input [9]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_151BF080_3A49_4756_B3C3_4D50864EA325#1144357, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_7E1DB0AF_566A_44E4_A1C2_E4E2E41CE779#1144600, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611]
(82) Project
Output [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, str_split(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) AS COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665, str_join(array(str_join(array(str_remove_extend(str_list_as_str(COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314), [[,],,]), Déduit des Infos Patient), ), str_join(array(Présent dans le RSF , COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587), ), str_join(array(Acte - Spé - Date , str_list_as_str(COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315)), : )), - ) AS COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Input [8]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_281ACE9A_A79D_43A9_8DD8_D76F1761D285#1144587, COL_0031FBC7_95B6_4CED_82B3_F6B7070E7F6A#1144314, COL_0C310DCD_05AD_4BBA_8349_158B28256935#1144315, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650]
(83) Generate
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Arguments: explode(COL_BCE5C1E0_92AA_4602_8A43_0134A61F608D#1144665), [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681], false, [COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699]
(84) Project
Output [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, str_create(RC-SUF-SUN) AS COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1144824, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, str_if_with_rule(CASE WHEN isnull(Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,)) THEN false ELSE Contains(COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, ,) END, str_concat(array(Switch de forfait , COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, @, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, -) END, str_concat(array(Suppression de Forfait@, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611)), str_if_with_rule(CASE WHEN isnull(Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +)) THEN false ELSE Contains(COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, +) END, str_concat(array(Ajout de forfait@, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358)), null))) AS COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1144826, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
Input [7]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_4AB767CC_7E61_4F81_8512_47304B8AD22F#1144358, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_F4F7F9D3_EE47_4E54_B9E8_01FB09452A31#1144611, COL_8CCAF66F_C5D0_48EE_88DB_F76EBE2CDAC8#1144650, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699]
(85) WriteFiles
Input [6]: [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247#1144312, COL_680B8808_CA1F_43BB_9FD6_545FE101582E#1144586, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE#1144824, COL_D6EF6DFC_79A6_470E_BA52_073402820059#1144699, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F#1144826, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24#1144681]
(86) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR7_SUN_SUF_172562], Overwrite, [COL_4E30F557_0D51_42D5_8031_A4EAB6C1C247, COL_680B8808_CA1F_43BB_9FD6_545FE101582E, COL_C85C6E08_90B7_4393_94E6_7D80D91002DE, COL_D6EF6DFC_79A6_470E_BA52_073402820059, COL_7C996DEA_C14E_49A5_B230_77E504C67A0F, COL_394635B6_CBFF_48E1_A7F6_382580FC1E24]
(87) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true