SP1 - Details for Query 572

Submitted Time: 2026/02/24 09:27:30
Duration: 1.0 s
Succeeded Jobs: 732 733 735 739

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 (7)\n \nduration: 90 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: 503 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 93 ms"; 8 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 83.6 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 741 local merged chunks fetched: 0 shuffle write time: 3 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: 741 local bytes read: 80.1 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: 231.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: 80.1 KiB"]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 741"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 415 ms"; 15 [labelType="html" label="Generate number of output rows: 1,002"]; } 16 [labelType="html" label=" Project "]; 17 [labelType="html" label="Filter number of output rows: 1"]; 18 [labelType="html" label="Scan text number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 599.6 KiB"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.3 KiB number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 1,505 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: 1,505 local bytes read: 17.3 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: 47.0 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: 17.3 KiB"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 12 ms"; 24 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 5 ms peak memory: 256.0 KiB number of output rows: 1,505 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 25 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 128.6 KiB number of coalesced partitions: 1"]; 26 [labelType="html" label="Exchange shuffle records written: 1,505 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 11 ms (1 ms, 1 ms, 2 ms (stage 970.0: task 1327)) 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,505 local bytes read: 123.2 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 6 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 184.0 KiB (880.0 B, 36.6 KiB, 37.1 KiB (stage 970.0: task 1324)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 123.2 KiB (1008.0 B, 24.4 KiB, 24.7 KiB (stage 970.0: task 1324))"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n376 ms (13 ms, 48 ms, 77 ms (stage 970.0: task 1325))"; 28 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 317 ms (5 ms, 44 ms, 65 ms (stage 970.0: task 1325)) peak memory total (min, med, max (stageId: taskId)) 2.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 970.0: task 1330)) number of output rows: 1,505 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 29 [labelType="html" label=" Project "]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n390 ms (15 ms, 48 ms, 78 ms (stage 970.0: task 1325))"; 31 [labelType="html" label="Filter number of output rows: 1,505"]; 32 [labelType="html" label="Generate number of output rows: 1,507"]; } 33 [labelType="html" label=" Project "]; 34 [labelType="html" label="Filter number of output rows: 16"]; 35 [labelType="html" label="Scan text number of output rows: 30 number of files read: 30 metadata time: 0 ms 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; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_8A096969_1374_4168_B930_C219BC1F0591#153669 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672 AS COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334 AS COL_4305A823_7359_41A9_9127_BF4929F37005#154895, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, ... 2 more fields]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#154337]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012]

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

WholeStageCodegen (7)

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, 10), ENSURE_REQUIREMENTS, [plan_id=16596]

Project [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#153669, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]

Project [root#152489.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, to_json(root#152489.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, root#152489.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239]

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

Generate explode(root#152486), false, [root#152489]

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#152471, $.records), Some(Etc/UTC)) AS root#152486]

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#152471, $.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#152471, $.records), Some(Etc/UTC))))

FileScan text [value#152471] 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_119256173/HTTP_FILE_0.json], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<value:string>

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#153763, 10), ENSURE_REQUIREMENTS, [plan_id=16793]

HashAggregate(keys=[CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158, 10), ENSURE_REQUIREMENTS, [plan_id=16638]

HashAggregate(keys=[CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158], functions=[])

WholeStageCodegen (3)

Project [root#153079.capacity AS CAPACITY_119304#153155L, to_json(root#153079.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#153156, root#153079.name AS NAME_119306#153157, root#153079.stationcode AS STATIONCODE_119307#153158]

Filter (CASE WHEN isnull(bigint_to_int(root#153079.capacity)) THEN false ELSE (bigint_to_int(root#153079.capacity) > 0) END AND isnotnull(root#153079.stationcode))

Generate explode(root#153036), false, [root#153079]

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#152682, $.results), Some(Etc/UTC)) AS root#153036]

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#152682, $.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#152682, $.results), Some(Etc/UTC))))

FileScan text [value#152682] 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_119302173/HTTP_FILE_0..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<value:string>

Details

== 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=231.5 KiB, rowCount=741)
               :        +- 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#152471]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/json/tmp/VLIB_JSON_119256173/HTTP_FILE_0.json]
ReadSchema: struct<value:string>

(2) Filter
Input [1]: [value#152471]
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#152471, $.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#152471, $.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#152471, $.records), Some(Etc/UTC)) AS root#152486]
Input [1]: [value#152471]

(4) Generate [codegen id : 1]
Input [1]: [root#152486]
Arguments: explode(root#152486), false, [root#152489]

(5) Filter
Input [1]: [root#152489]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.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#152489.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.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#152489.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.stationcode)))

(6) Project
Output [3]: [root#152489.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, to_json(root#152489.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, root#152489.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239]
Input [1]: [root#152489]

(7) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#153669, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239]

(8) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, 10), ENSURE_REQUIREMENTS, [plan_id=16596]

(9) ShuffleQueryStage
Output [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: 0

(10) AQEShuffleRead
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: coalesced

(11) Sort [codegen id : 5]
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668 ASC NULLS FIRST], false, 0

(12) Scan text 
Output [1]: [value#152682]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/json/tmp/INFORMATION_STA_119302173/HTTP_FILE_0.json, ... 29 entries]
ReadSchema: struct<value:string>

(13) Filter
Input [1]: [value#152682]
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#152682, $.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#152682, $.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#152682, $.results), Some(Etc/UTC)) AS root#153036]
Input [1]: [value#152682]

(15) Generate [codegen id : 2]
Input [1]: [root#153036]
Arguments: explode(root#153036), false, [root#153079]

(16) Filter [codegen id : 2]
Input [1]: [root#153079]
Condition : (CASE WHEN isnull(bigint_to_int(root#153079.capacity)) THEN false ELSE (bigint_to_int(root#153079.capacity) > 0) END AND isnotnull(root#153079.stationcode))

(17) Project
Output [4]: [root#153079.capacity AS CAPACITY_119304#153155L, to_json(root#153079.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#153156, root#153079.name AS NAME_119306#153157, root#153079.stationcode AS STATIONCODE_119307#153158]
Input [1]: [root#153079]

(18) HashAggregate [codegen id : 3]
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Keys [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]

(19) Exchange
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Arguments: hashpartitioning(CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158, 10), ENSURE_REQUIREMENTS, [plan_id=16638]

(20) ShuffleQueryStage
Output [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Arguments: 1

(21) AQEShuffleRead
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Arguments: coalesced

(22) HashAggregate [codegen id : 4]
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Keys [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#153155L AS INFORMATION_STA_119303_CAPACITY_119304#153760L, STATIONCODE_119307#153158 AS INFORMATION_STA_119303_STATIONCODE_119307#153763]

(23) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#153763, 10), ENSURE_REQUIREMENTS, [plan_id=16793]

(24) ShuffleQueryStage
Output [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: 2

(25) AQEShuffleRead
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: coalesced

(26) Sort [codegen id : 6]
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#153763 ASC NULLS FIRST], false, 0

(27) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#153763]
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#153681, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 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#153681, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 100.0)), 2)) > 20) END

(28) Project [codegen id : 7]
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]

(29) Project [codegen id : 7]
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#154337]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012]

(30) Project [codegen id : 7]
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_8A096969_1374_4168_B930_C219BC1F0591#153669 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672 AS COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334 AS COL_4305A823_7359_41A9_9127_BF4929F37005#154895, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#154899, COL_69842CB9_D407_4477_8F44_680AF6209358#154337 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#154900]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_69842CB9_D407_4477_8F44_680AF6209358#154337]

(31) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_4305A823_7359_41A9_9127_BF4929F37005#154895, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#154899, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#154900]
Arguments: 500000

(32) Generate
Input [1]: [root#152486]
Arguments: explode(root#152486), false, [root#152489]

(33) Filter
Input [1]: [root#152489]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.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#152489.fields, Some(Etc/UTC)), $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.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#152489.fields, Some(Etc/UTC)), $.ebike))) THEN false ELSE (str_to_integer(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(to_json(root#152489.fields, Some(Etc/UTC)), $.stationcode)))

(34) Project
Output [3]: [root#152489.datasetid AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, to_json(root#152489.fields, Some(Etc/UTC)) AS COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, root#152489.record_timestamp AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239]
Input [1]: [root#152489]

(35) Project
Output [16]: [get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#153669, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, str_to_datez(COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, str_to_integer(get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, get_json_object(COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Input [3]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_9091B58C_8072_40BA_9B1C_4828078CF13A#153237, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239]

(36) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, 10), ENSURE_REQUIREMENTS, [plan_id=16566]

(37) Sort
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668 ASC NULLS FIRST], false, 0

(38) Generate
Input [1]: [root#153036]
Arguments: explode(root#153036), false, [root#153079]

(39) Filter
Input [1]: [root#153079]
Condition : (CASE WHEN isnull(bigint_to_int(root#153079.capacity)) THEN false ELSE (bigint_to_int(root#153079.capacity) > 0) END AND isnotnull(root#153079.stationcode))

(40) Project
Output [4]: [root#153079.capacity AS CAPACITY_119304#153155L, to_json(root#153079.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#153156, root#153079.name AS NAME_119306#153157, root#153079.stationcode AS STATIONCODE_119307#153158]
Input [1]: [root#153079]

(41) HashAggregate
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Keys [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]

(42) Exchange
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Arguments: hashpartitioning(CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158, 10), ENSURE_REQUIREMENTS, [plan_id=16560]

(43) HashAggregate
Input [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Keys [4]: [CAPACITY_119304#153155L, COORDONNEES_GEO_119305#153156, NAME_119306#153157, STATIONCODE_119307#153158]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#153155L AS INFORMATION_STA_119303_CAPACITY_119304#153760L, STATIONCODE_119307#153158 AS INFORMATION_STA_119303_STATIONCODE_119307#153763]

(44) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#153763, 10), ENSURE_REQUIREMENTS, [plan_id=16567]

(45) Sort
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#153763 ASC NULLS FIRST], false, 0

(46) SortMergeJoin
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#153763]
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#153681, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 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#153681, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 100.0)), 2)) > 20) END

(47) Project
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#153760L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, INFORMATION_STA_119303_CAPACITY_119304#153760L, INFORMATION_STA_119303_STATIONCODE_119307#153763]

(48) Project
Output [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, int_sum(array(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968)) AS COL_69842CB9_D407_4477_8F44_680AF6209358#154337]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012]

(49) Project
Output [26]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236 AS COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668 AS COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686 AS COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673 AS COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674 AS COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_8A096969_1374_4168_B930_C219BC1F0591#153669 AS COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675 AS COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683 AS COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684 AS COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672 AS COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012 AS COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 AS COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682 AS COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968 AS COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239 AS COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334 AS COL_4305A823_7359_41A9_9127_BF4929F37005#154895, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, dec_operator(PRODUIT, array(cast(COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681 as double), 100.0)) AS COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, null AS COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, null AS COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670 AS COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685 AS COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671 AS COL_129DC554_F58A_4155_9DB8_BE501866A9A2#154899, COL_69842CB9_D407_4477_8F44_680AF6209358#154337 AS COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#154900]
Input [20]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#153668, COL_8A096969_1374_4168_B930_C219BC1F0591#153669, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#153670, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#153671, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#153672, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#153673, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#153674, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#153675, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#153236, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#153239, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#153683, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#153684, COL_2F07F797_35B4_491C_8255_10445B86EEB9#153685, COL_222816E0_1771_4A96_9C59_DB1900C311FE#153681, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#153682, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#154012, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#154334, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#153686, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#153968, COL_69842CB9_D407_4477_8F44_680AF6209358#154337]

(50) CollectLimit
Input [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_4305A823_7359_41A9_9127_BF4929F37005#154895, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#154899, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#154900]
Arguments: 500000

(51) AdaptiveSparkPlan
Output [26]: [COL_58BFFB75_D002_4C94_9961_476D1A0322E5#154878, COL_1EABB019_659D_4018_A14B_0CF40C7256B7#154879, COL_82DDBD34_8120_49DF_8DBC_5F9592FBDADF#154880, COL_991B13CC_D3DA_41EE_B9FC_4AFFE07CE2C7#154881, COL_74FC1904_B427_48EF_92C2_AEC628571F14#154882, COL_D2FF02D0_E3DC_4039_9C34_32AB9FC6C729#154883, COL_C4D1C6FA_1C12_4D4E_BA2E_CBB377D3944C#154884, COL_0294E533_CC14_4CBB_9329_CAE9AED2EAAC#154885, COL_7A95B62A_AD1E_4141_B584_F28094307084#154886, COL_7EC8C1F1_6CC2_4258_A077_F8A8579095F7#154887, COL_DE332716_93CF_43F0_9252_3579650ED828#154888, COL_EF80C97F_A93C_41E2_B1F0_8B1DB35329C3#154889, COL_7015847E_7A66_48BA_ADC1_A0F09FE7321B#154890, COL_2ADDC1D2_36A3_4BAF_9185_55EC075EFA12#154891, COL_3D6B9250_10F0_4ACA_A2D2_4E7E5FAC298E#154892, COL_CC0B1D4E_79F9_460F_B1A4_F0A608E9160F#154893, COL_D39B012A_0CA7_4A23_8EB4_AE621CDB0722#154894, COL_4305A823_7359_41A9_9127_BF4929F37005#154895, COL_7C5E54B5_D803_42EF_9C0F_B977E013E7DC#154896, COL_38C57C5D_008E_44CC_9109_BF222F30A675#155651, COL_796A3BB5_55EC_4EFB_9454_D09E9B8949D1#155036, COL_5751AB0E_42E5_4F71_AAB2_1A35A13A94E8#155037, COL_F8CF123B_B018_47C0_B360_BDD2E85EB008#154897, COL_84E15116_E0DA_4BE0_9FE8_B9FDFF218CA9#154898, COL_129DC554_F58A_4155_9DB8_BE501866A9A2#154899, COL_4B99367E_E19F_461E_BBE9_B5CB67EAF462#154900]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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