hdh-spark-job - Details for Query 1417

Submitted Time: 2026/08/31 15:22:25
Duration: 0.5 s
Succeeded Jobs: 1830 1831 1835

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" CollectLimit "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 30 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 396 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 73 ms"; 8 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 75.3 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 674 local merged chunks fetched: 0 shuffle write time: 2 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 674 local bytes read: 72.7 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 205.5 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 72.7 KiB"]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 674"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 266 ms"; 15 [labelType="html" label="Generate number of output rows: 1,004"]; 16 [labelType="html" label=" Project "]; } 17 [labelType="html" label="Scan json number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 599.4 KiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 0 ms"; 19 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 20 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 17.9 KiB number of coalesced partitions: 1"]; 21 [labelType="html" label="Exchange shuffle records written: 1,483 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,483 local bytes read: 16.9 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 46.3 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 16.9 KiB"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 5 ms"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="Filter number of output rows: 1,483"]; 25 [labelType="html" label="ColumnarToRow number of output rows: 1,487 number of input batches: 1"]; } 26 [labelType="html" label="Scan parquet number of files read: 1 scan time: 2 ms metadata time: 0 ms size of files read: 71.7 KiB number of output rows: 1,487"]; 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; 19->6; 20->19; 21->20; 23->21; 24->23; 25->24; 26->25; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_8A096969_1374_4168_B930_C219BC1F0591#298733 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736 AS COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091 AS COL_4305A823_7359_41A9_9127_BF4929F37005#299412, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, ... 2 more fields]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#299094]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951]

SortMergeJoin [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732], [INFORMATION_STA_119303_STATIONCODE_119307#298777], Inner, CASE WHEN isnull(dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 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#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) > 20) END

WholeStageCodegen (5)

Sort [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 ASC NULLS FIRST], false, 0

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, 10), ENSURE_REQUIREMENTS, [plan_id=99211]

Project [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#298733, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]

Project [872fb0f5-df31-4903-8b22-7dcbc814e962#298209.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, cast(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.record_timestamp as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496]

Filter ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.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(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.stationcode)))

Generate explode(b1ba6729-7be7-444f-ba38-250dbce728ba#298177), true, [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]

Project [records#298154 AS b1ba6729-7be7-444f-ba38-250dbce728ba#298177]

WholeStageCodegen (1)

FileScan json [records#298154] Batched: false, DataFilters: [], Format: JSON, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/json/execution/627AB83B_D966_456D_95BE_93512303..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<records:array<struct<datasetid:string,fields:struct<capacity:bigint,coordonnees_geo:array<...

Sort [INFORMATION_STA_119303_STATIONCODE_119307#298777 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#298777, 10), ENSURE_REQUIREMENTS, [plan_id=99244]

Project [CAPACITY_119304#298436L AS INFORMATION_STA_119303_CAPACITY_119304#298774L, STATIONCODE_119307#298439 AS INFORMATION_STA_119303_STATIONCODE_119307#298777]

Filter (CASE WHEN isnull(bigint_to_int(CAPACITY_119304#298436L)) THEN false ELSE (bigint_to_int(CAPACITY_119304#298436L) > 0) END AND isnotnull(STATIONCODE_119307#298439))

ColumnarToRow

WholeStageCodegen (2)

FileScan parquet [CAPACITY_119304#298436L,STATIONCODE_119307#298439] Batched: true, DataFilters: [CASE WHEN isnull(bigint_to_int(CAPACITY_119304#298436L)) THEN false ELSE (bigint_to_int(CAPACITY..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/INFORMATION_STA_119303], PartitionFilters: [], PushedFilters: [IsNotNull(STATIONCODE_119307)], ReadSchema: struct<CAPACITY_119304:bigint,STATIONCODE_119307:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (40)
+- == Final Plan ==
   CollectLimit (23)
   +- * Project (22)
      +- * Project (21)
         +- * Project (20)
            +- * SortMergeJoin Inner (19)
               :- * Sort (10)
               :  +- AQEShuffleRead (9)
               :     +- ShuffleQueryStage (8), Statistics(sizeInBytes=205.5 KiB, rowCount=674)
               :        +- Exchange (7)
               :           +- Project (6)
               :              +- Project (5)
               :                 +- Filter (4)
               :                    +- * Generate (3)
               :                       +- * Project (2)
               :                          +- Scan json  (1)
               +- * Sort (18)
                  +- AQEShuffleRead (17)
                     +- ShuffleQueryStage (16), Statistics(sizeInBytes=46.3 KiB, rowCount=1.48E+3)
                        +- Exchange (15)
                           +- * Project (14)
                              +- * Filter (13)
                                 +- * ColumnarToRow (12)
                                    +- Scan parquet  (11)
+- == Initial Plan ==
   CollectLimit (39)
   +- Project (38)
      +- Project (37)
         +- Project (36)
            +- SortMergeJoin Inner (35)
               :- Sort (30)
               :  +- Exchange (29)
               :     +- Project (28)
               :        +- Project (27)
               :           +- Filter (26)
               :              +- Generate (25)
               :                 +- Project (24)
               :                    +- Scan json  (1)
               +- Sort (34)
                  +- Exchange (33)
                     +- Project (32)
                        +- Filter (31)
                           +- Scan parquet  (11)


(1) Scan json 
Output [1]: [records#298154]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/json/execution/627AB83B_D966_456D_95BE_935123037D66/current/TEST.json]
ReadSchema: struct<records:array<struct<datasetid:string,fields:struct<capacity:bigint,coordonnees_geo:array<double>,duedate:timestamp,ebike:bigint,is_installed:string,is_renting:string,is_returning:string,mechanical:bigint,name:string,nom_arrondissement_communes:string,numbikesavailable:bigint,numdocksavailable:bigint,stationcode:string>,geometry:string,record_timestamp:timestamp,recordid:string>>>

(2) Project [codegen id : 1]
Output [1]: [records#298154 AS b1ba6729-7be7-444f-ba38-250dbce728ba#298177]
Input [1]: [records#298154]

(3) Generate [codegen id : 1]
Input [1]: [b1ba6729-7be7-444f-ba38-250dbce728ba#298177]
Arguments: explode(b1ba6729-7be7-444f-ba38-250dbce728ba#298177), true, [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]

(4) Filter
Input [1]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.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(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.stationcode)))

(5) Project
Output [3]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, cast(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.record_timestamp as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496]
Input [1]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]

(6) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#298733, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496]

(7) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, 10), ENSURE_REQUIREMENTS, [plan_id=99211]

(8) ShuffleQueryStage
Output [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: 0

(9) AQEShuffleRead
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: coalesced

(10) Sort [codegen id : 3]
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 ASC NULLS FIRST], false, 0

(11) Scan parquet 
Output [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/INFORMATION_STA_119303]
PushedFilters: [IsNotNull(STATIONCODE_119307)]
ReadSchema: struct<CAPACITY_119304:bigint,STATIONCODE_119307:string>

(12) ColumnarToRow [codegen id : 2]
Input [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]

(13) Filter [codegen id : 2]
Input [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]
Condition : (CASE WHEN isnull(bigint_to_int(CAPACITY_119304#298436L)) THEN false ELSE (bigint_to_int(CAPACITY_119304#298436L) > 0) END AND isnotnull(STATIONCODE_119307#298439))

(14) Project [codegen id : 2]
Output [2]: [CAPACITY_119304#298436L AS INFORMATION_STA_119303_CAPACITY_119304#298774L, STATIONCODE_119307#298439 AS INFORMATION_STA_119303_STATIONCODE_119307#298777]
Input [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]

(15) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#298777, 10), ENSURE_REQUIREMENTS, [plan_id=99244]

(16) ShuffleQueryStage
Output [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: 1

(17) AQEShuffleRead
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#298777 ASC NULLS FIRST], false, 0

(19) SortMergeJoin [codegen id : 5]
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#298777]
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#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 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#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) > 20) END

(20) Project [codegen id : 5]
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]

(21) Project [codegen id : 5]
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#299094]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951]

(22) Project [codegen id : 5]
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_8A096969_1374_4168_B930_C219BC1F0591#298733 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736 AS COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091 AS COL_4305A823_7359_41A9_9127_BF4929F37005#299412, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#299416, COL_69842CB9_D407_4477_8F44_680AF6209358#299094 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#299417]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_69842CB9_D407_4477_8F44_680AF6209358#299094]

(23) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_4305A823_7359_41A9_9127_BF4929F37005#299412, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#299416, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#299417]
Arguments: 500000

(24) Project
Output [1]: [records#298154 AS b1ba6729-7be7-444f-ba38-250dbce728ba#298177]
Input [1]: [records#298154]

(25) Generate
Input [1]: [b1ba6729-7be7-444f-ba38-250dbce728ba#298177]
Arguments: explode(b1ba6729-7be7-444f-ba38-250dbce728ba#298177), true, [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]

(26) Filter
Input [1]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.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(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)), $.stationcode)))

(27) Project
Output [3]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, to_json(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, cast(872fb0f5-df31-4903-8b22-7dcbc814e962#298209.record_timestamp as string) AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496]
Input [1]: [872fb0f5-df31-4903-8b22-7dcbc814e962#298209]

(28) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#298733, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#298494, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496]

(29) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, 10), ENSURE_REQUIREMENTS, [plan_id=99182]

(30) Sort
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 ASC NULLS FIRST], false, 0

(31) Filter
Input [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]
Condition : (CASE WHEN isnull(bigint_to_int(CAPACITY_119304#298436L)) THEN false ELSE (bigint_to_int(CAPACITY_119304#298436L) > 0) END AND isnotnull(STATIONCODE_119307#298439))

(32) Project
Output [2]: [CAPACITY_119304#298436L AS INFORMATION_STA_119303_CAPACITY_119304#298774L, STATIONCODE_119307#298439 AS INFORMATION_STA_119303_STATIONCODE_119307#298777]
Input [2]: [CAPACITY_119304#298436L, STATIONCODE_119307#298439]

(33) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#298777, 10), ENSURE_REQUIREMENTS, [plan_id=99183]

(34) Sort
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#298777 ASC NULLS FIRST], false, 0

(35) SortMergeJoin
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#298777]
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#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 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#298745, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) > 20) END

(36) Project
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#298774L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, INFORMATION_STA_119303_CAPACITY_119304#298774L, INFORMATION_STA_119303_STATIONCODE_119307#298777]

(37) Project
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#299094]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951]

(38) Project
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_8A096969_1374_4168_B930_C219BC1F0591#298733 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736 AS COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091 AS COL_4305A823_7359_41A9_9127_BF4929F37005#299412, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#299416, COL_69842CB9_D407_4477_8F44_680AF6209358#299094 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#299417]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#298732, COL_8A096969_1374_4168_B930_C219BC1F0591#298733, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#298734, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#298735, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#298736, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#298737, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#298738, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#298739, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#298493, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#298496, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#298747, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#298748, COL_2F07F797_35B4_491C_8255_10445B86EEB9#298749, COL_222816E0_1771_4A96_9C59_DB1900C311FE#298745, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#298746, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#298951, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#299091, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#298750, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#298907, COL_69842CB9_D407_4477_8F44_680AF6209358#299094]

(39) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_4305A823_7359_41A9_9127_BF4929F37005#299412, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#299416, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#299417]
Arguments: 500000

(40) AdaptiveSparkPlan
Output [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#299395, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#299396, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#299397, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#299398, COL_74FC1904_B427_48EF_92C2_AEC628571F14#299399, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#299400, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#299401, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#299402, COL_7A95B62A_AD1E_4141_B584_F28094307084#299403, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#299404, COL_DE332716_93CF_43F0_9252_3579650ED828#299405, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#299406, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#299407, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#299408, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#299409, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#299410, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#299411, COL_4305A823_7359_41A9_9127_BF4929F37005#299412, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#299413, COL_38C57C5D_008E_44CC_9109_BF222F30A675#299739, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#299462, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#299463, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#299414, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#299415, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#299416, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#299417]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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