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 total (min, med, max (stageId: taskId))<br>3 ms (0 ms, 0 ms, 3 ms (stage 30816.0: task 36658))<br>number of written files: 4<br>job commit time: 8 ms<br>number of output rows: 15,592<br>number of dynamic part: 0<br>written output: 869.7 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: total (min, med, max (stageId: taskId))\n5.7 s (1.0 s, 1.6 s, 1.8 s (stage 30816.0: task 36654))";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<br><b>Project</b><br><br>"];
8 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 15,592<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30816.0: task 36663))"];
}
subgraph cluster9 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 0 ms";
10 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 30816.0: task 36663))<br>peak memory total (min, med, max (stageId: taskId))<br>67.0 MiB (16.5 MiB, 17.0 MiB, 17.0 MiB (stage 30816.0: task 36658))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30816.0: task 36663))"];
}
11 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 87,514<br>time in aggregation build total (min, med, max (stageId: taskId))<br>230 ms (17 ms, 35 ms, 146 ms (stage 30816.0: task 36658))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30816.0: task 36663))<br>number of sort fallback tasks: 4"];
12 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 4<br>partition data size total (min, med, max (stageId: taskId))<br>1194.1 KiB (241.0 KiB, 350.6 KiB, 361.5 KiB (driver))<br>number of coalesced partitions: 4"];
13 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 87,514<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>10 ms (0 ms, 1 ms, 1 ms (stage 30805.0: task 36631))<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: 87,514<br>local bytes read total (min, med, max (stageId: taskId))<br>1118.8 KiB (224.3 KiB, 333.8 KiB, 335.3 KiB (stage 30816.0: task 36658))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 30816.0: task 36663))<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>8.7 MiB (867.8 KiB, 889.5 KiB, 906.1 KiB (stage 30805.0: task 36604))<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>1118.8 KiB (109.5 KiB, 111.7 KiB, 113.9 KiB (stage 30805.0: task 36604))"];
14 [labelType="html" label="<b>ObjectHashAggregate</b><br><br>number of output rows: 87,514<br>time in aggregation build total (min, med, max (stageId: taskId))<br>2.0 s (149 ms, 181 ms, 408 ms (stage 30805.0: task 36604))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30805.0: task 36604))<br>number of sort fallback tasks: 10"];
subgraph cluster15 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (148 ms, 178 ms, 406 ms (stage 30805.0: task 36604))";
16 [labelType="html" label="<br><b>Project</b><br><br>"];
}
17 [labelType="html" label="<b>CartesianProduct</b><br><br>number of output rows: 591,883"];
subgraph cluster18 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n2.0 s (148 ms, 179 ms, 406 ms (stage 30805.0: task 36604))";
19 [labelType="html" label="<br><b>Project</b><br><br>"];
20 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 591,883"];
21 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 591,883<br>number of input batches: 150"];
}
22 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>46 ms (3 ms, 4 ms, 8 ms (stage 30805.0: task 36630))<br>metadata time: 0 ms<br>size of files read: 14.2 MiB<br>number of output rows: 591,883"];
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n31 ms (3 ms, 3 ms, 4 ms (stage 30805.0: task 36630))";
24 [labelType="html" label="<br><b>Project</b><br><br>"];
25 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 10"];
}
26 [labelType="html" label="<b>Scan csv </b><br><br>number of output rows: 10<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 163.0 B"];
subgraph cluster27 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: total (min, med, max (stageId: taskId))\n13.0 s (2.1 s, 3.3 s, 4.4 s (stage 30816.0: task 36654))";
28 [labelType="html" label="<b>Sort</b><br><br>sort time total (min, med, max (stageId: taskId))<br>15 ms (2 ms, 3 ms, 8 ms (stage 30816.0: task 36654))<br>peak memory total (min, med, max (stageId: taskId))<br>65.5 MiB (16.3 MiB, 16.5 MiB, 16.5 MiB (stage 30816.0: task 36658))<br>spill size total (min, med, max (stageId: taskId))<br>0.0 B (0.0 B, 0.0 B, 0.0 B (stage 30816.0: task 36663))"];
}
29 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 4<br>partition data size total (min, med, max (stageId: taskId))<br>3.8 MiB (783.3 KiB, 1171.8 KiB, 1172.8 KiB (driver))<br>number of coalesced partitions: 4"];
30 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 48,615<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>44 ms (2 ms, 3 ms, 7 ms (stage 30806.0: task 36621))<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: 48,615<br>local bytes read total (min, med, max (stageId: taskId))<br>3.7 MiB (749.7 KiB, 1119.4 KiB, 1123.4 KiB (stage 30816.0: task 36658))<br>fetch wait time total (min, med, max (stageId: taskId))<br>0 ms (0 ms, 0 ms, 0 ms (stage 30816.0: task 36663))<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 40<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>12.1 MiB (1195.4 KiB, 1240.4 KiB, 1264.8 KiB (stage 30806.0: task 36612))<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>3.7 MiB (363.1 KiB, 375.5 KiB, 382.8 KiB (stage 30806.0: task 36612))"];
subgraph cluster31 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: total (min, med, max (stageId: taskId))\n375 ms (23 ms, 33 ms, 71 ms (stage 30806.0: task 36621))";
32 [labelType="html" label="<br><b>Project</b><br><br>"];
33 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 48,615"];
34 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 48,615<br>number of input batches: 20"];
}
35 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 10<br>scan time total (min, med, max (stageId: taskId))<br>61 ms (5 ms, 6 ms, 10 ms (stage 30806.0: task 36621))<br>metadata time: 0 ms<br>size of files read: 7.8 MiB<br>number of output rows: 48,615"];
1->0;
2->1;
4->2;
5->4;
6->5;
7->6;
8->7;
10->8;
11->10;
12->11;
13->12;
14->13;
16->14;
17->16;
19->17;
20->19;
21->20;
22->21;
24->17;
25->24;
26->25;
28->8;
29->28;
30->29;
32->30;
33->32;
34->33;
35->34;
}
36
AdaptiveSparkPlan isFinalPlan=true
Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]
WriteFiles
Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#2340291, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208]
Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012)), : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, RIGHT, 4)), -)), : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, RIGHT, 4)), -)), : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826)), : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)), - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Project [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025]
SortMergeJoin [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823], [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874], Inner, (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))
WholeStageCodegen (7)
Sort [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823 ASC NULLS FIRST], false, 0
WholeStageCodegen (5)
ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481], functions=[min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)])
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, 10), ENSURE_REQUIREMENTS, [plan_id=1162841]
ObjectHashAggregate(keys=[COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481], functions=[partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)])
Project [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751]
WholeStageCodegen (3)
CartesianProduct
Project [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501]
Filter isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106] Batched: true, DataFilters: [isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_161749], PartitionFilters: [], PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)], ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:s...
Project
Filter ((isnotnull(REGLES#2338892) AND (RC-SUB = REGLES#2338892)) AND (APPLICABLE#2338893 <=> O))
WholeStageCodegen (2)
FileScan csv [REGLES#2338892,APPLICABLE#2338893] Batched: false, DataFilters: [isnotnull(REGLES#2338892), (RC-SUB = REGLES#2338892), (APPLICABLE#2338893 <=> O)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/tmp/REGLES_APPLICAB_161411/REGLES-A-TTT.csv], PartitionFilters: [], PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUB), EqualNullSafe(APPLICABLE,O)], ReadSchema: struct<REGLES:string,APPLICABLE:string>
Sort [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874 ASC NULLS FIRST], false, 0
WholeStageCodegen (6)
AQEShuffleRead coalesced
Exchange hashpartitioning(03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 10), ENSURE_REQUIREMENTS, [plan_id=1162882]
Project [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196 AS 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199 AS 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200 AS 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201 AS 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203 AS 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208 AS 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211 AS 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Filter (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200))
ColumnarToRow
WholeStageCodegen (4)
FileScan parquet [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196,COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203,COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211] Batched: true, DataFilters: [isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196), isnotnull(COL_582B8737_1AAE_44AC_AF..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_161568], PartitionFilters: [], PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A..., ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:s...
== Physical Plan ==
AdaptiveSparkPlan (52)
+- == Final Plan ==
Execute InsertIntoHadoopFsRelationCommand (30)
+- WriteFiles (29)
+- * Project (28)
+- * Project (27)
+- * Project (26)
+- * Project (25)
+- * SortMergeJoin Inner (24)
:- * Sort (15)
: +- ObjectHashAggregate (14)
: +- AQEShuffleRead (13)
: +- ShuffleQueryStage (12), Statistics(sizeInBytes=8.7 MiB, rowCount=8.75E+4)
: +- Exchange (11)
: +- ObjectHashAggregate (10)
: +- * Project (9)
: +- CartesianProduct Inner (8)
: :- * Project (4)
: : +- * Filter (3)
: : +- * ColumnarToRow (2)
: : +- Scan parquet (1)
: +- * Project (7)
: +- * Filter (6)
: +- Scan csv (5)
+- * Sort (23)
+- AQEShuffleRead (22)
+- ShuffleQueryStage (21), Statistics(sizeInBytes=12.1 MiB, rowCount=4.86E+4)
+- Exchange (20)
+- * Project (19)
+- * Filter (18)
+- * ColumnarToRow (17)
+- Scan parquet (16)
+- == Initial Plan ==
Execute InsertIntoHadoopFsRelationCommand (51)
+- WriteFiles (50)
+- Project (49)
+- Project (48)
+- Project (47)
+- Project (46)
+- SortMergeJoin Inner (45)
:- Sort (40)
: +- ObjectHashAggregate (39)
: +- Exchange (38)
: +- ObjectHashAggregate (37)
: +- Project (36)
: +- CartesianProduct Inner (35)
: :- Project (32)
: : +- Filter (31)
: : +- Scan parquet (1)
: +- Project (34)
: +- Filter (33)
: +- Scan csv (5)
+- Sort (44)
+- Exchange (43)
+- Project (42)
+- Filter (41)
+- Scan parquet (16)
(1) Scan parquet
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/00_B_ACTES_PATI_161749]
PushedFilters: [IsNotNull(COL_64ED17E5_A991_405B_AEED_8A2977283F76)]
ReadSchema: struct<COL_64ED17E5_A991_405B_AEED_8A2977283F76:string,COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C:string,COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE:string,COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799:string>
(2) ColumnarToRow [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
(3) Filter [codegen id : 1]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062)
(4) Project [codegen id : 1]
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
(5) Scan csv
Output [2]: [REGLES#2338892, APPLICABLE#2338893]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/tmp/REGLES_APPLICAB_161411/REGLES-A-TTT.csv]
PushedFilters: [IsNotNull(REGLES), EqualTo(REGLES,RC-SUB), EqualNullSafe(APPLICABLE,O)]
ReadSchema: struct<REGLES:string,APPLICABLE:string>
(6) Filter [codegen id : 2]
Input [2]: [REGLES#2338892, APPLICABLE#2338893]
Condition : ((isnotnull(REGLES#2338892) AND (RC-SUB = REGLES#2338892)) AND (APPLICABLE#2338893 <=> O))
(7) Project [codegen id : 2]
Output: []
Input [2]: [REGLES#2338892, APPLICABLE#2338893]
(8) CartesianProduct
Join type: Inner
Join condition: None
(9) Project [codegen id : 3]
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501]
(10) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)]
Aggregate Attributes [3]: [min#2340323, buf#2344399, buf#2344400]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
(11) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, 10), ENSURE_REQUIREMENTS, [plan_id=1162841]
(12) ShuffleQueryStage
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Arguments: 0
(13) AQEShuffleRead
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Arguments: coalesced
(14) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751)#2339799, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0)#2339801, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)#2339803]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751)#2339799 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0)#2339801 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)#2339803 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(15) Sort [codegen id : 5]
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823 ASC NULLS FIRST], false, 0
(16) Scan parquet
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/03_PIVOT_INFORM_161568]
PushedFilters: [IsNotNull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F), IsNotNull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8)]
ReadSchema: struct<COL_F1E7803C_F059_4667_8E32_963E2B3DA65F:string,COL_8761272F_9915_40EB_8429_20EFEF6A9A31:string,COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8:string,COL_5F8E1D72_6344_42AB_A08C_3B4735439F46:string,COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A:double,COL_60F7C888_9836_4535_A22F_D43D2994E019:string,COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3:array<string>>
(17) ColumnarToRow [codegen id : 4]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
(18) Filter [codegen id : 4]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200))
(19) Project [codegen id : 4]
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196 AS 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199 AS 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200 AS 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201 AS 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203 AS 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208 AS 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211 AS 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
(20) Exchange
Input [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: hashpartitioning(03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 10), ENSURE_REQUIREMENTS, [plan_id=1162882]
(21) ShuffleQueryStage
Output [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: 1
(22) AQEShuffleRead
Input [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: coalesced
(23) Sort [codegen id : 6]
Input [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874 ASC NULLS FIRST], false, 0
(24) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823]
Right keys [1]: [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))
(25) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
(26) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012)), : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, RIGHT, 4)), -)), : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, RIGHT, 4)), -)), : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826)), : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)), - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025]
(27) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(28) Project [codegen id : 7]
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#2340291, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208]
(29) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#2340291, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(30) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]
(31) Filter
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
Condition : isnotnull(COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062)
(32) Project
Output [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062 AS COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080 AS COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081 AS COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106 AS COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501]
Input [4]: [COL_64ED17E5_A991_405B_AEED_8A2977283F76#2339062, COL_BDB05EC9_9A57_48FC_837C_09C53AD9A07C#2339080, COL_5DB1C0F0_D430_4466_9E87_F8BC455AAECE#2339081, COL_8C34F4D9_05C7_45D2_B420_EFFD9D772799#2339106]
(33) Filter
Input [2]: [REGLES#2338892, APPLICABLE#2338893]
Condition : ((isnotnull(REGLES#2338892) AND (RC-SUB = REGLES#2338892)) AND (APPLICABLE#2338893 <=> O))
(34) Project
Output: []
Input [2]: [REGLES#2338892, APPLICABLE#2338893]
(35) CartesianProduct
Join type: Inner
Join condition: None
(36) Project
Output [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, str_to_datez(COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, yyyy-MM-dd HH:mm:ss, Europe/Paris, fr_FR) AS COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751]
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_0AA37D1F_FF1A_45B4_BEC8_A7718DEFC923#2339485, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501]
(37) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481]
Functions [3]: [partial_min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), partial_collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), partial_collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)]
Aggregate Attributes [3]: [min#2340323, buf#2344399, buf#2344400]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
(38) Exchange
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Arguments: hashpartitioning(COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, 10), ENSURE_REQUIREMENTS, [plan_id=1162790]
(39) ObjectHashAggregate
Input [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481, min#2340326, buf#2344401, buf#2344402]
Keys [1]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481]
Functions [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751), collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0), collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)]
Aggregate Attributes [3]: [min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751)#2339799, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0)#2339801, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)#2339803]
Results [4]: [COL_349903B5_AFC1_48C4_8BB8_D9B5B650168A#2339481 AS COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, min(COL_70F8A126_AF61_4C58_9D26_A08A0F242B32#2339751)#2339799 AS COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, collect_set(COL_C23A949E_4371_43E0_A0D5_B8DBD65EC34E#2339500, 0, 0)#2339801 AS COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, collect_set(COL_427A45E8_88A8_445B_A1AC_8ED61818CB2B#2339501, 0, 0)#2339803 AS COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(40) Sort
Input [4]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Arguments: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823 ASC NULLS FIRST], false, 0
(41) Filter
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
Condition : (isnotnull(COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196) AND isnotnull(COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200))
(42) Project
Output [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196 AS 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199 AS 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200 AS 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201 AS 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203 AS 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208 AS 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211 AS 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Input [7]: [COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339196, COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339199, COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339200, COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339201, COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339203, COL_60F7C888_9836_4535_A22F_D43D2994E019#2339208, COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339211]
(43) Exchange
Input [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: hashpartitioning(03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 10), ENSURE_REQUIREMENTS, [plan_id=1162794]
(44) Sort
Input [7]: [03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
Arguments: [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874 ASC NULLS FIRST], false, 0
(45) SortMergeJoin
Left keys [1]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823]
Right keys [1]: [03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874]
Join type: Inner
Join condition: (isnotnull(str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null))))) AND NOT (str_if_with_rule((isnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), null, str_if_with_rule((str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0) <=> str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), null, str_if_with_rule((isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)) AND isnull(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0))), str_concat(array(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), str_if_with_rule(NOT (str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null) <=> str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0)), str_concat(array(str_list_get(str_list_intersect_fixed(str_split(03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, ;), [SUB,SB2,SB3]), 0), -, str_if_with_rule(isnotnull(str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null)), str_concat(array(,, str_if_with_rule((str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) <=> 1), str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99))) THEN false ELSE ((03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 16.0) AND (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877) THEN false ELSE (03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 >= 45.0) END, SB3, null))), null), +)), null))), null)))) <=> ))
(46) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870 AS COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873 AS COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875 AS COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877 AS COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882 AS COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885 AS COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, str_list_get(COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, 0) AS COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025]
Input [11]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_504D9344_0D6D_448F_B93B_8070A8498F87#2339825, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, 03_PIVOT_INFORM_161568_COL_F1E7803C_F059_4667_8E32_963E2B3DA65F#2339870, 03_PIVOT_INFORM_161568_COL_8761272F_9915_40EB_8429_20EFEF6A9A31#2339873, 03_PIVOT_INFORM_161568_COL_582B8737_1AAE_44AC_AF57_EB71A05E19B8#2339874, 03_PIVOT_INFORM_161568_COL_5F8E1D72_6344_42AB_A08C_3B4735439F46#2339875, 03_PIVOT_INFORM_161568_COL_5DF719CA_DD10_4841_ACAE_B085DE2FDD8A#2339877, 03_PIVOT_INFORM_161568_COL_60F7C888_9836_4535_A22F_D43D2994E019#2339882, 03_PIVOT_INFORM_161568_COL_090106A5_73E4_4A2F_B079_EA4B1A7BC0D3#2339885]
(47) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 15.99) END, SUB, str_if_with_rule(CASE WHEN isnull(((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99))) THEN false ELSE ((COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 16.0) AND (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 <= 44.99)) END, SB2, str_if_with_rule(CASE WHEN isnull(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012) THEN false ELSE (COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012 >= 45.0) END, SB3, null))), null) AS COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, str_list_get(str_list_intersect_fixed(str_split(COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, ;), [SUB,SB2,SB3]), 0) AS COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, date_time_to_str(COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, ddMMyyyy, Europe/Paris, fr_FR) AS COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, str_join(array(str_join(array(Age (en Année) , dec_to_str(COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012)), : ), , str_join(array(Date Naissance , str_join(array(str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, LEFT, 2), str_extract_middle(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, 3, 2), str_extract(COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, RIGHT, 4)), -)), : ), str_join(array(Date Entrée, str_join(array(str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, LEFT, 2), str_extract_middle(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, 3, 2), str_extract(COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, RIGHT, 4)), -)), : ), str_join(array(Date Biologie, str_list_as_str(COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826)), : ), str_if_with_rule((COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025 <=> 1), Eligible Bio : OUI, Eligible Bio : NON)), - ) AS COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_F225C13E_208F_4CF0_BE07_DC369B2E94B3#2339824, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_50001E33_210D_4379_9D53_00CD383D4C9E#2340012, COL_DE369305_2AC3_4292_BDBA_0C892A133BDA#2340013, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_96321FCF_A971_41B7_9AB1_AEBDDC36A54A#2340025]
(48) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, str_if_with_rule((isnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), null, str_if_with_rule((COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171 <=> COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), null, str_if_with_rule((isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170) AND isnull(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171)), str_concat(array(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), str_if_with_rule(NOT (COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170 <=> COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171), str_concat(array(COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, -, str_if_with_rule(isnotnull(COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170), str_concat(array(,, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, +)), null))), null)))) AS COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_create(RC-SUB) AS COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_5FBE30A1_AFD9_4037_B848_6C939797E947#2340170, COL_D75A61BA_D28A_4FAC_B65A_85D8875DBE11#2340171, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(49) Project
Output [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, str_if_with_rule((isnotnull(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192) AND NOT (COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192 <=> )), str_join(array(str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, +) END, str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Switch de forfait (SU Bio*), Ajout de forfait), str_if_with_rule(CASE WHEN isnull(Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -)) THEN false ELSE Contains(COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, -) END, Suppression de Forfait, )), COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172), @), ) AS COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#2340291, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6103FE3D_2FE0_4C0F_A1C3_617C29A9537E#2340172, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208]
(50) WriteFiles
Input [10]: [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC#2339823, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA#2340009, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672#2340208, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990#2340192, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08#2340291, COL_46598A01_D8BC_436B_975B_00D168E3C4D6#2340173, COL_2F038993_76B5_4030_8D3B_7718F322492A#2340010, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590#2340011, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22#2340014, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9#2339826]
(51) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709, false, Parquet, [path=file:///data/output/cache/parquet/datablock/05_GR3_SUB_SB2__161709], Overwrite, [COL_B45BA917_3E2B_4F4C_A7B1_0BA6603AADCC, COL_2B90C0A8_2BA1_4A69_8C03_2672E65BA8AA, COL_6F246EF6_0483_44FA_BBEE_C94D4DE26672, COL_AEB59E62_D5A7_47CF_8CBE_F91E2E374990, COL_6425C53C_6469_4002_9B2C_22D29F3F3B08, COL_46598A01_D8BC_436B_975B_00D168E3C4D6, COL_2F038993_76B5_4030_8D3B_7718F322492A, COL_1E97357D_CC7A_4C59_9725_C34CB91B0590, COL_B95ADF41_FAB8_4380_9E03_E5AE31F68C22, COL_30BDA73B_B5D9_4882_AA33_5F32E726EFD9]
(52) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true