digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster2 {
isCluster="true";
label="WholeStageCodegen (7)\n \nduration: 37 ms";
3 [labelType="html" label="<br><b>Project</b><br><br>"];
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 493<br>spill size: 0.0 B"];
}
subgraph cluster7 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 144 ms";
8 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
9 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 83.9 KiB<br>number of coalesced partitions: 1"];
10 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 744<br>local merged chunks fetched: 0<br>shuffle write time: 7 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 744<br>local bytes read: 80.0 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 232.5 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 80.0 KiB"];
11 [labelType="html" label="<br><b>Project</b><br><br>"];
12 [labelType="html" label="<br><b>Project</b><br><br>"];
13 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 744"];
subgraph cluster14 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 254 ms";
15 [labelType="html" label="<b>Generate</b><br><br>number of output rows: 1,002"];
}
16 [labelType="html" label="<br><b>Project</b><br><br>"];
17 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
18 [labelType="html" label="<b>Scan text </b><br><br>number of output rows: 1<br>number of files read: 1<br>metadata time: 0 ms<br>size of files read: 599.5 KiB"];
subgraph cluster19 {
isCluster="true";
label="WholeStageCodegen (6)\n \nduration: 0 ms";
20 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
21 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 18.3 KiB<br>number of coalesced partitions: 1"];
22 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1,505<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 1,505<br>local bytes read: 17.3 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 47.0 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 17.3 KiB"];
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 32 ms";
24 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build: 5 ms<br>peak memory: 256.0 KiB<br>number of output rows: 1,505<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
}
25 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 128.6 KiB<br>number of coalesced partitions: 1"];
26 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1,505<br>local merged chunks fetched: 0<br>shuffle write time total (min, med, max (stageId: taskId))<br>13 ms (1 ms, 2 ms, 2 ms (stage 2096.0: task 2498))<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: 1,505<br>local bytes read: 123.2 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 6<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size total (min, med, max (stageId: taskId))<br>184.0 KiB (880.0 B, 36.6 KiB, 37.1 KiB (stage 2096.0: task 2497))<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>123.2 KiB (1008.0 B, 24.4 KiB, 24.7 KiB (stage 2096.0: task 2497))"];
subgraph cluster27 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n454 ms (41 ms, 52 ms, 60 ms (stage 2096.0: task 2498))";
28 [labelType="html" label="<b>HashAggregate</b><br><br>spill size: 0.0 B<br>time in aggregation build total (min, med, max (stageId: taskId))<br>123 ms (6 ms, 15 ms, 22 ms (stage 2096.0: task 2498))<br>peak memory total (min, med, max (stageId: taskId))<br>2.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 2096.0: task 2505))<br>number of output rows: 1,505<br>number of sort fallback tasks: 0<br>avg hash probes per key: 0"];
}
29 [labelType="html" label="<br><b>Project</b><br><br>"];
subgraph cluster30 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n833 ms (84 ms, 94 ms, 101 ms (stage 2096.0: task 2498))";
31 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1,505"];
32 [labelType="html" label="<b>Generate</b><br><br>number of output rows: 1,507"];
}
33 [labelType="html" label="<br><b>Project</b><br><br>"];
34 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 16"];
35 [labelType="html" label="<b>Scan text </b><br><br>number of output rows: 30<br>number of files read: 30<br>metadata time: 0 ms<br>size of files read: 266.0 KiB"];
1->0;
3->1;
4->3;
5->4;
6->5;
8->6;
9->8;
10->9;
11->10;
12->11;
13->12;
15->13;
16->15;
17->16;
18->17;
20->6;
21->20;
22->21;
24->22;
25->24;
26->25;
28->26;
29->28;
31->29;
32->31;
33->32;
34->33;
35->34;
}
36
AdaptiveSparkPlan isFinalPlan=true
CollectLimit 500000
Project [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_8A096969_1374_4168_B930_C219BC1F0591#312524 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527 AS COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890 AS COL_4305A823_7359_41A9_9127_BF4929F37005#313266, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, ... 2 more fields]
Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#312893]
Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742]
SortMergeJoin [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523], [INFORMATION_STA_119303_STATIONCODE_119307#312568], Inner, CASE WHEN isnull(dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2))) THEN false ELSE (dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) > 20) END
WholeStageCodegen (7)
Sort [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 ASC NULLS FIRST], false, 0
WholeStageCodegen (5)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, 10), ENSURE_REQUIREMENTS, [plan_id=38177]
Project [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#312524, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Project [root#312061.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, to_json(root#312061.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, root#312061.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289]
Filter ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.stationcode)))
Generate explode(root#312058), false, [root#312061]
WholeStageCodegen (1)
Project [from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC)) AS root#312058]
Filter ((size(from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC)), true) > 0) AND isnotnull(from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC))))
FileScan text [value#312043] Batched: false, DataFilters: [(size(from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,S..., Format: Text, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/json/tmp/VLIB_JSON_119256168/HTTP_FILE_0.json], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<value:string>
Sort [INFORMATION_STA_119303_STATIONCODE_119307#312568 ASC NULLS FIRST], false, 0
WholeStageCodegen (6)
AQEShuffleRead coalesced
Exchange hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#312568, 10), ENSURE_REQUIREMENTS, [plan_id=38279]
HashAggregate(keys=[CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231], functions=[])
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231, 10), ENSURE_REQUIREMENTS, [plan_id=38219]
HashAggregate(keys=[CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231], functions=[])
WholeStageCodegen (3)
Project [root#312195.capacity AS CAPACITY_119304#312228L, to_json(root#312195.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#312229, root#312195.name AS NAME_119306#312230, root#312195.stationcode AS STATIONCODE_119307#312231]
Filter (CASE WHEN isnull(bigint_to_int(root#312195.capacity)) THEN false ELSE (bigint_to_int(root#312195.capacity) > 0) END AND isnotnull(root#312195.stationcode))
Generate explode(root#312192), false, [root#312195]
WholeStageCodegen (2)
Project [from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC)) AS root#312192]
Filter ((size(from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC)), true) > 0) AND isnotnull(from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC))))
FileScan text [value#312177] Batched: false, DataFilters: [(size(from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees..., Format: Text, Location: InMemoryFileIndex(30 paths)[file:/data/input/depot/json/tmp/INFORMATION_STA_119302168/HTTP_FILE_0..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<value:string>
== Physical Plan ==
AdaptiveSparkPlan (51)
+- == Final Plan ==
CollectLimit (31)
+- * Project (30)
+- * Project (29)
+- * Project (28)
+- * SortMergeJoin Inner (27)
:- * Sort (11)
: +- AQEShuffleRead (10)
: +- ShuffleQueryStage (9), Statistics(sizeInBytes=232.5 KiB, rowCount=744)
: +- Exchange (8)
: +- Project (7)
: +- Project (6)
: +- Filter (5)
: +- * Generate (4)
: +- Project (3)
: +- Filter (2)
: +- Scan text (1)
+- * Sort (26)
+- AQEShuffleRead (25)
+- ShuffleQueryStage (24), Statistics(sizeInBytes=47.0 KiB, rowCount=1.51E+3)
+- Exchange (23)
+- * HashAggregate (22)
+- AQEShuffleRead (21)
+- ShuffleQueryStage (20), Statistics(sizeInBytes=184.0 KiB, rowCount=1.51E+3)
+- Exchange (19)
+- * HashAggregate (18)
+- Project (17)
+- * Filter (16)
+- * Generate (15)
+- Project (14)
+- Filter (13)
+- Scan text (12)
+- == Initial Plan ==
CollectLimit (50)
+- Project (49)
+- Project (48)
+- Project (47)
+- SortMergeJoin Inner (46)
:- Sort (37)
: +- Exchange (36)
: +- Project (35)
: +- Project (34)
: +- Filter (33)
: +- Generate (32)
: +- Project (3)
: +- Filter (2)
: +- Scan text (1)
+- Sort (45)
+- Exchange (44)
+- HashAggregate (43)
+- Exchange (42)
+- HashAggregate (41)
+- Project (40)
+- Filter (39)
+- Generate (38)
+- Project (14)
+- Filter (13)
+- Scan text (12)
(1) Scan text
Output [1]: [value#312043]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/json/tmp/VLIB_JSON_119256168/HTTP_FILE_0.json]
ReadSchema: struct<value:string>
(2) Filter
Input [1]: [value#312043]
Condition : ((size(from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC)), true) > 0) AND isnotnull(from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC))))
(3) Project
Output [1]: [from_json(ArrayType(StructType(StructField(datasetid,StringType,true),StructField(fields,StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,ArrayType(DoubleType,true),true),StructField(duedate,StringType,true),StructField(ebike,LongType,true),StructField(is_installed,StringType,true),StructField(is_renting,StringType,true),StructField(is_returning,StringType,true),StructField(mechanical,LongType,true),StructField(name,StringType,true),StructField(nom_arrondissement_communes,StringType,true),StructField(numbikesavailable,LongType,true),StructField(numdocksavailable,LongType,true),StructField(stationcode,StringType,true)),true),StructField(geometry,StructType(StructField(coordinates,ArrayType(DoubleType,true),true),StructField(type,StringType,true)),true),StructField(record_timestamp,StringType,true),StructField(recordid,StringType,true)),true), get_json_object(value#312043, $.records), Some(Etc/UTC)) AS root#312058]
Input [1]: [value#312043]
(4) Generate [codegen id : 1]
Input [1]: [root#312058]
Arguments: explode(root#312058), false, [root#312061]
(5) Filter
Input [1]: [root#312061]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.stationcode)))
(6) Project
Output [3]: [root#312061.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, to_json(root#312061.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, root#312061.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289]
Input [1]: [root#312061]
(7) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#312524, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289]
(8) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, 10), ENSURE_REQUIREMENTS, [plan_id=38177]
(9) ShuffleQueryStage
Output [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: 0
(10) AQEShuffleRead
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: coalesced
(11) Sort [codegen id : 5]
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 ASC NULLS FIRST], false, 0
(12) Scan text
Output [1]: [value#312177]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/json/tmp/INFORMATION_STA_119302168/HTTP_FILE_0.json, ... 29 entries]
ReadSchema: struct<value:string>
(13) Filter
Input [1]: [value#312177]
Condition : ((size(from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC)), true) > 0) AND isnotnull(from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC))))
(14) Project
Output [1]: [from_json(ArrayType(StructType(StructField(capacity,LongType,true),StructField(coordonnees_geo,StructType(StructField(lat,DoubleType,true),StructField(lon,DoubleType,true)),true),StructField(name,StringType,true),StructField(station_opening_hours,StringType,true),StructField(stationcode,StringType,true)),true), get_json_object(value#312177, $.results), Some(Etc/UTC)) AS root#312192]
Input [1]: [value#312177]
(15) Generate [codegen id : 2]
Input [1]: [root#312192]
Arguments: explode(root#312192), false, [root#312195]
(16) Filter [codegen id : 2]
Input [1]: [root#312195]
Condition : (CASE WHEN isnull(bigint_to_int(root#312195.capacity)) THEN false ELSE (bigint_to_int(root#312195.capacity) > 0) END AND isnotnull(root#312195.stationcode))
(17) Project
Output [4]: [root#312195.capacity AS CAPACITY_119304#312228L, to_json(root#312195.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#312229, root#312195.name AS NAME_119306#312230, root#312195.stationcode AS STATIONCODE_119307#312231]
Input [1]: [root#312195]
(18) HashAggregate [codegen id : 3]
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Keys [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
(19) Exchange
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Arguments: hashpartitioning(CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231, 10), ENSURE_REQUIREMENTS, [plan_id=38219]
(20) ShuffleQueryStage
Output [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Arguments: 1
(21) AQEShuffleRead
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Arguments: coalesced
(22) HashAggregate [codegen id : 4]
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Keys [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#312228L AS INFORMATION_STA_119303_CAPACITY_119304#312565L, STATIONCODE_119307#312231 AS INFORMATION_STA_119303_STATIONCODE_119307#312568]
(23) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#312568, 10), ENSURE_REQUIREMENTS, [plan_id=38279]
(24) ShuffleQueryStage
Output [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: 2
(25) AQEShuffleRead
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: coalesced
(26) Sort [codegen id : 6]
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#312568 ASC NULLS FIRST], false, 0
(27) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#312568]
Join type: Inner
Join condition: CASE WHEN isnull(dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2))) THEN false ELSE (dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) > 20) END
(28) Project [codegen id : 7]
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
(29) Project [codegen id : 7]
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#312893]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742]
(30) Project [codegen id : 7]
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_8A096969_1374_4168_B930_C219BC1F0591#312524 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527 AS COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890 AS COL_4305A823_7359_41A9_9127_BF4929F37005#313266, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#313270, COL_69842CB9_D407_4477_8F44_680AF6209358#312893 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#313271]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_69842CB9_D407_4477_8F44_680AF6209358#312893]
(31) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_4305A823_7359_41A9_9127_BF4929F37005#313266, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#313270, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#313271]
Arguments: 500000
(32) Generate
Input [1]: [root#312058]
Arguments: explode(root#312058), false, [root#312061]
(33) Filter
Input [1]: [root#312061]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(root#312061.fields, Some(Etc/UTC)), $.stationcode)))
(34) Project
Output [3]: [root#312061.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, to_json(root#312061.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, root#312061.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289]
Input [1]: [root#312061]
(35) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#312524, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#312287, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289]
(36) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, 10), ENSURE_REQUIREMENTS, [plan_id=38147]
(37) Sort
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 ASC NULLS FIRST], false, 0
(38) Generate
Input [1]: [root#312192]
Arguments: explode(root#312192), false, [root#312195]
(39) Filter
Input [1]: [root#312195]
Condition : (CASE WHEN isnull(bigint_to_int(root#312195.capacity)) THEN false ELSE (bigint_to_int(root#312195.capacity) > 0) END AND isnotnull(root#312195.stationcode))
(40) Project
Output [4]: [root#312195.capacity AS CAPACITY_119304#312228L, to_json(root#312195.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#312229, root#312195.name AS NAME_119306#312230, root#312195.stationcode AS STATIONCODE_119307#312231]
Input [1]: [root#312195]
(41) HashAggregate
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Keys [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
(42) Exchange
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Arguments: hashpartitioning(CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231, 10), ENSURE_REQUIREMENTS, [plan_id=38141]
(43) HashAggregate
Input [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Keys [4]: [CAPACITY_119304#312228L, COORDONNEES_GEO_119305#312229, NAME_119306#312230, STATIONCODE_119307#312231]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#312228L AS INFORMATION_STA_119303_CAPACITY_119304#312565L, STATIONCODE_119307#312231 AS INFORMATION_STA_119303_STATIONCODE_119307#312568]
(44) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#312568, 10), ENSURE_REQUIREMENTS, [plan_id=38148]
(45) Sort
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#312568 ASC NULLS FIRST], false, 0
(46) SortMergeJoin
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#312568]
Join type: Inner
Join condition: CASE WHEN isnull(dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2))) THEN false ELSE (dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) > 20) END
(47) Project
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#312565L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, INFORMATION_STA_119303_CAPACITY_119304#312565L, INFORMATION_STA_119303_STATIONCODE_119307#312568]
(48) Project
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#312893]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742]
(49) Project
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_8A096969_1374_4168_B930_C219BC1F0591#312524 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527 AS COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890 AS COL_4305A823_7359_41A9_9127_BF4929F37005#313266, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#313270, COL_69842CB9_D407_4477_8F44_680AF6209358#312893 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#313271]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#312523, COL_8A096969_1374_4168_B930_C219BC1F0591#312524, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#312525, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#312526, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#312527, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#312528, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#312529, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#312530, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#312286, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#312289, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#312538, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#312539, COL_2F07F797_35B4_491C_8255_10445B86EEB9#312540, COL_222816E0_1771_4A96_9C59_DB1900C311FE#312536, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#312537, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#312742, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#312890, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#312541, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#312698, COL_69842CB9_D407_4477_8F44_680AF6209358#312893]
(50) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_4305A823_7359_41A9_9127_BF4929F37005#313266, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#313270, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#313271]
Arguments: 500000
(51) AdaptiveSparkPlan
Output [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#313249, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#313250, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#313251, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#313252, COL_74FC1904_B427_48EF_92C2_AEC628571F14#313253, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#313254, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#313255, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#313256, COL_7A95B62A_AD1E_4141_B584_F28094307084#313257, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#313258, COL_DE332716_93CF_43F0_9252_3579650ED828#313259, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#313260, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#313261, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#313262, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#313263, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#313264, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#313265, COL_4305A823_7359_41A9_9127_BF4929F37005#313266, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#313267, COL_38C57C5D_008E_44CC_9109_BF222F30A675#314013, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#313367, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#313368, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#313268, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#313269, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#313270, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#313271]
Arguments: isFinalPlan=true