SP1 - Details for Query 547

Submitted Time: 2026/02/24 09:26:46
Duration: 0.9 s
Succeeded Jobs: 709 712 713 714

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: 47 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: 483 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 237 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: 78.5 KiB number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 701 local merged chunks fetched: 0 shuffle write time: 7 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: 701 local bytes read: 75.2 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: 219.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: 75.2 KiB"]; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="Filter number of output rows: 701"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 247 ms"; 14 [labelType="html" label="ColumnarToRow number of output rows: 1,002 number of input batches: 1"]; } 15 [labelType="html" label="Scan parquet number of files read: 1 scan time: 11 ms metadata time: 0 ms size of files read: 153.6 KiB number of output rows: 1,002"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 0 ms"; 17 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 18 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 18.3 KiB number of coalesced partitions: 1"]; 19 [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 cluster20 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 10 ms"; 21 [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"]; } 22 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 128.6 KiB number of coalesced partitions: 1"]; 23 [labelType="html" label="Exchange shuffle records written: 1,505 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 12 ms (1 ms, 2 ms, 2 ms (stage 935.0: task 1290)) 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 935.0: task 1287)) 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 935.0: task 1287))"]; subgraph cluster24 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n197 ms (10 ms, 23 ms, 38 ms (stage 935.0: task 1288))"; 25 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 148 ms (7 ms, 17 ms, 31 ms (stage 935.0: task 1288)) peak memory total (min, med, max (stageId: taskId)) 2.3 MiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 935.0: task 1293)) number of output rows: 1,505 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 26 [labelType="html" label=" Project "]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n203 ms (11 ms, 22 ms, 37 ms (stage 935.0: task 1288))"; 28 [labelType="html" label="Filter number of output rows: 1,505"]; 29 [labelType="html" label="Generate number of output rows: 1,507"]; } 30 [labelType="html" label=" Project "]; 31 [labelType="html" label="Filter number of output rows: 16"]; 32 [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; 14->12; 15->14; 17->6; 18->17; 19->18; 21->19; 22->21; 23->22; 25->23; 26->25; 28->26; 29->28; 30->29; 31->30; 32->31; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 500000

Project [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464 AS COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918 AS COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936 AS COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920 AS COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921 AS COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467 AS COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923 AS COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924 AS COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_8A096969_1374_4168_B930_C219BC1F0591#150919 AS COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925 AS COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 AS COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 AS COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922 AS COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283 AS COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932 AS COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187 AS COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, null AS COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, null AS COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, null AS COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935 AS COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187]

Project [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283]

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

WholeStageCodegen (7)

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, 10), ENSURE_REQUIREMENTS, [plan_id=15784]

Project [get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, get_json_object(FIELDS_119275#147971, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#150919, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, str_to_datez(RECORD_TIMESTAM_119277#147974, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, get_json_object(FIELDS_119275#147971, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, get_json_object(FIELDS_119275#147971, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, get_json_object(FIELDS_119275#147971, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, DATASETID_119274#147970 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, RECORD_TIMESTAM_119277#147974 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, str_to_integer(get_json_object(FIELDS_119275#147971, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, str_to_integer(get_json_object(FIELDS_119275#147971, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, get_json_object(FIELDS_119275#147971, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]

Filter ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(FIELDS_119275#147971, $.stationcode)))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [DATASETID_119274#147970,FIELDS_119275#147971,RECORD_TIMESTAM_119277#147974] Batched: true, DataFilters: [(str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(FIELD..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/uet/VLIB_JSON_119273], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<DATASETID_119274:string,FIELDS_119275:string,RECORD_TIMESTAM_119277:string>

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

WholeStageCodegen (6)

AQEShuffleRead coalesced

Exchange hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#151013, 10), ENSURE_REQUIREMENTS, [plan_id=15942]

HashAggregate(keys=[CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298], functions=[])

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298, 10), ENSURE_REQUIREMENTS, [plan_id=15835]

HashAggregate(keys=[CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298], functions=[])

WholeStageCodegen (3)

Project [root#150114.capacity AS CAPACITY_119304#150295L, to_json(root#150114.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#150296, root#150114.name AS NAME_119306#150297, root#150114.stationcode AS STATIONCODE_119307#150298]

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

Generate explode(root#150111), false, [root#150114]

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

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

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

Details

== Physical Plan ==
AdaptiveSparkPlan (46)
+- == Final Plan ==
   CollectLimit (28)
   +- * Project (27)
      +- * Project (26)
         +- * Project (25)
            +- * SortMergeJoin Inner (24)
               :- * Sort (8)
               :  +- AQEShuffleRead (7)
               :     +- ShuffleQueryStage (6), Statistics(sizeInBytes=219.3 KiB, rowCount=701)
               :        +- Exchange (5)
               :           +- Project (4)
               :              +- Filter (3)
               :                 +- * ColumnarToRow (2)
               :                    +- Scan parquet  (1)
               +- * Sort (23)
                  +- AQEShuffleRead (22)
                     +- ShuffleQueryStage (21), Statistics(sizeInBytes=47.0 KiB, rowCount=1.51E+3)
                        +- Exchange (20)
                           +- * HashAggregate (19)
                              +- AQEShuffleRead (18)
                                 +- ShuffleQueryStage (17), Statistics(sizeInBytes=184.0 KiB, rowCount=1.51E+3)
                                    +- Exchange (16)
                                       +- * HashAggregate (15)
                                          +- Project (14)
                                             +- * Filter (13)
                                                +- * Generate (12)
                                                   +- Project (11)
                                                      +- Filter (10)
                                                         +- Scan text  (9)
+- == Initial Plan ==
   CollectLimit (45)
   +- Project (44)
      +- Project (43)
         +- Project (42)
            +- SortMergeJoin Inner (41)
               :- Sort (32)
               :  +- Exchange (31)
               :     +- Project (30)
               :        +- Filter (29)
               :           +- Scan parquet  (1)
               +- Sort (40)
                  +- Exchange (39)
                     +- HashAggregate (38)
                        +- Exchange (37)
                           +- HashAggregate (36)
                              +- Project (35)
                                 +- Filter (34)
                                    +- Generate (33)
                                       +- Project (11)
                                          +- Filter (10)
                                             +- Scan text  (9)


(1) Scan parquet 
Output [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/uet/VLIB_JSON_119273]
ReadSchema: struct<DATASETID_119274:string,FIELDS_119275:string,RECORD_TIMESTAM_119277:string>

(2) ColumnarToRow [codegen id : 1]
Input [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]

(3) Filter
Input [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(FIELDS_119275#147971, $.stationcode)))

(4) Project
Output [16]: [get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, get_json_object(FIELDS_119275#147971, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#150919, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, str_to_datez(RECORD_TIMESTAM_119277#147974, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, get_json_object(FIELDS_119275#147971, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, get_json_object(FIELDS_119275#147971, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, get_json_object(FIELDS_119275#147971, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, DATASETID_119274#147970 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, RECORD_TIMESTAM_119277#147974 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, str_to_integer(get_json_object(FIELDS_119275#147971, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, str_to_integer(get_json_object(FIELDS_119275#147971, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, get_json_object(FIELDS_119275#147971, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Input [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]

(5) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, 10), ENSURE_REQUIREMENTS, [plan_id=15784]

(6) ShuffleQueryStage
Output [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: 0

(7) AQEShuffleRead
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: coalesced

(8) Sort [codegen id : 5]
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918 ASC NULLS FIRST], false, 0

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

(10) Filter
Input [1]: [value#149638]
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#149638, $.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#149638, $.results), Some(Etc/UTC))))

(11) 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#149638, $.results), Some(Etc/UTC)) AS root#150111]
Input [1]: [value#149638]

(12) Generate [codegen id : 2]
Input [1]: [root#150111]
Arguments: explode(root#150111), false, [root#150114]

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

(14) Project
Output [4]: [root#150114.capacity AS CAPACITY_119304#150295L, to_json(root#150114.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#150296, root#150114.name AS NAME_119306#150297, root#150114.stationcode AS STATIONCODE_119307#150298]
Input [1]: [root#150114]

(15) HashAggregate [codegen id : 3]
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Keys [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]

(16) Exchange
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Arguments: hashpartitioning(CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298, 10), ENSURE_REQUIREMENTS, [plan_id=15835]

(17) ShuffleQueryStage
Output [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Arguments: 1

(18) AQEShuffleRead
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Arguments: coalesced

(19) HashAggregate [codegen id : 4]
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Keys [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#150295L AS INFORMATION_STA_119303_CAPACITY_119304#151010L, STATIONCODE_119307#150298 AS INFORMATION_STA_119303_STATIONCODE_119307#151013]

(20) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#151013, 10), ENSURE_REQUIREMENTS, [plan_id=15942]

(21) ShuffleQueryStage
Output [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: 2

(22) AQEShuffleRead
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: coalesced

(23) Sort [codegen id : 6]
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#151013 ASC NULLS FIRST], false, 0

(24) SortMergeJoin [codegen id : 7]
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#151013]
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#150931, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 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#150931, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 100.0)), 2)) > 20) END

(25) Project [codegen id : 7]
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]

(26) Project [codegen id : 7]
Output [19]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283]

(27) Project [codegen id : 7]
Output [25]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464 AS COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918 AS COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936 AS COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920 AS COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921 AS COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467 AS COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923 AS COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924 AS COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_8A096969_1374_4168_B930_C219BC1F0591#150919 AS COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925 AS COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 AS COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 AS COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922 AS COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283 AS COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932 AS COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187 AS COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, null AS COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, null AS COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, null AS COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935 AS COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]
Input [19]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187]

(28) CollectLimit
Input [25]: [COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]
Arguments: 500000

(29) Filter
Input [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]
Condition : ((str_remove_accent(upper(str_if_with_rule((CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END AND CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike))) THEN false ELSE (str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) > 0) END, Electriques, Pas de disponibilité))))) <=> MECANIQUES + ELECTRIQUES) AND isnotnull(get_json_object(FIELDS_119275#147971, $.stationcode)))

(30) Project
Output [16]: [get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, get_json_object(FIELDS_119275#147971, $.nom_arrondissement_communes) AS COL_8A096969_1374_4168_B930_C219BC1F0591#150919, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[0]) AS COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, get_json_object(FIELDS_119275#147971, $.coordonnees_geo[1]) AS COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, str_to_datez(RECORD_TIMESTAM_119277#147974, yyyy-MM-dd'T'HH:mm:ss.SSSXXX, Europe/Paris, fr_FR) AS COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, get_json_object(FIELDS_119275#147971, $.is_renting) AS COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, get_json_object(FIELDS_119275#147971, $.is_installed) AS COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, get_json_object(FIELDS_119275#147971, $.is_returning) AS COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, DATASETID_119274#147970 AS COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, RECORD_TIMESTAM_119277#147974 AS COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, str_to_integer(get_json_object(FIELDS_119275#147971, $.numbikesavailable)) AS COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, str_to_integer(get_json_object(FIELDS_119275#147971, $.numdocksavailable)) AS COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, str_to_integer(get_json_object(FIELDS_119275#147971, $.ebike)) AS COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, str_to_integer(get_json_object(FIELDS_119275#147971, $.mechanical)) AS COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, get_json_object(FIELDS_119275#147971, $.name) AS COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, get_json_object(FIELDS_119275#147971, $.stationcode) AS COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Input [3]: [DATASETID_119274#147970, FIELDS_119275#147971, RECORD_TIMESTAM_119277#147974]

(31) Exchange
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: hashpartitioning(COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, 10), ENSURE_REQUIREMENTS, [plan_id=15696]

(32) Sort
Input [16]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936]
Arguments: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918 ASC NULLS FIRST], false, 0

(33) Generate
Input [1]: [root#150111]
Arguments: explode(root#150111), false, [root#150114]

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

(35) Project
Output [4]: [root#150114.capacity AS CAPACITY_119304#150295L, to_json(root#150114.coordonnees_geo, Some(Etc/UTC)) AS COORDONNEES_GEO_119305#150296, root#150114.name AS NAME_119306#150297, root#150114.stationcode AS STATIONCODE_119307#150298]
Input [1]: [root#150114]

(36) HashAggregate
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Keys [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Functions: []
Aggregate Attributes: []
Results [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]

(37) Exchange
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Arguments: hashpartitioning(CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298, 10), ENSURE_REQUIREMENTS, [plan_id=15690]

(38) HashAggregate
Input [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Keys [4]: [CAPACITY_119304#150295L, COORDONNEES_GEO_119305#150296, NAME_119306#150297, STATIONCODE_119307#150298]
Functions: []
Aggregate Attributes: []
Results [2]: [CAPACITY_119304#150295L AS INFORMATION_STA_119303_CAPACITY_119304#151010L, STATIONCODE_119307#150298 AS INFORMATION_STA_119303_STATIONCODE_119307#151013]

(39) Exchange
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: hashpartitioning(INFORMATION_STA_119303_STATIONCODE_119307#151013, 10), ENSURE_REQUIREMENTS, [plan_id=15697]

(40) Sort
Input [2]: [INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]
Arguments: [INFORMATION_STA_119303_STATIONCODE_119307#151013 ASC NULLS FIRST], false, 0

(41) SortMergeJoin
Left keys [1]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918]
Right keys [1]: [INFORMATION_STA_119303_STATIONCODE_119307#151013]
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#150931, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 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#150931, int_sum(array(bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L), COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 100.0)), 2)) > 20) END

(42) Project
Output [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, bigint_to_int(INFORMATION_STA_119303_CAPACITY_119304#151010L) AS COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, str_if_with_rule((CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END AND CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END), Mécaniques + Electriques, str_if_with_rule(CASE WHEN isnull(COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934) THEN false ELSE (COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 > 0) END, Mécaniques, str_if_with_rule(CASE WHEN isnull(COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933) THEN false ELSE (COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 > 0) END, Electriques, Pas de disponibilité))) AS COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, INFORMATION_STA_119303_CAPACITY_119304#151010L, INFORMATION_STA_119303_STATIONCODE_119307#151013]

(43) Project
Output [19]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283, dec_to_int(dec_round(dec_operator(PRODUIT, array(dec_operator(DIVISION, array(COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, int_sum(array(COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931)))), 100.0)), 2)) AS COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187]
Input [18]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283]

(44) Project
Output [25]: [COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464 AS COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918 AS COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936 AS COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920 AS COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921 AS COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467 AS COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923 AS COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924 AS COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_8A096969_1374_4168_B930_C219BC1F0591#150919 AS COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925 AS COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933 AS COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934 AS COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922 AS COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283 AS COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931 AS COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932 AS COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187 AS COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, null AS COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, < 10 %, less_or_equal, [10], [0], #EE4806, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 10 à 20 %, between, [10], [20], #E47F0A, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 20 à 30 %, between, [20], [30], #D7A80D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 30 à 40 %, between, [30], [40], #CECE11, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 40 à 50 %, between, [40], [50], #99C515, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 50 à 60 %, between, [50], [60], #6BB918, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 60 à 70 %, between, [60], [70], #45B01B, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 70 à 80 %, between, [70], [80], #2BA91D, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, de 80 à 90, between, [80], [90], #1FA133, , null), RANKING_INTEGER(COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, > 90 %, greater_or_equal, [90], [0], #219A48, , null))) AS COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449 AS COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, null AS COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, null AS COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935 AS COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]
Input [19]: [COL_613DB6B3_74E6_4C99_93FD_E5777B617C86#150918, COL_8A096969_1374_4168_B930_C219BC1F0591#150919, COL_D8B2CF53_3DEF_4008_84F6_ABD7C7D519D1#150920, COL_38FFE468_A29D_4849_A2C9_0363FA03FF42#150921, COL_97AB7E74_3BCE_49E7_8A3B_33031418EF69#150922, COL_AD1312C1_6861_42B9_A7D0_EA7744E2B8A3#150923, COL_7FD543F8_0D7D_449F_A24D_451CCEB7A4C5#150924, COL_AEF551A3_1A52_41DE_834C_26049DF5418E#150925, COL_5420F0A0_5A46_4C41_B880_E8F826EA971B#150464, COL_23FAB29C_0A26_4042_8FB0_7DE3807A5522#150467, COL_5A4A810B_AA07_436A_BF5B_A1602E4CABC6#150933, COL_5AF84147_5C5A_4A25_947C_12826B5080D0#150934, COL_2F07F797_35B4_491C_8255_10445B86EEB9#150935, COL_222816E0_1771_4A96_9C59_DB1900C311FE#150931, COL_3E307331_E38A_4A82_B27C_DCEDD6728DCC#150932, COL_A5D96D13_F6F6_434E_A452_7C76A1CECD86#151283, COL_53FAED45_3ABA_424E_8D67_03AC323B7720#151449, COL_709AD995_7169_493D_9A7D_D64AFB1CC85D#150936, COL_1D0F6719_56CC_493A_8046_1C0E7DFF06FE#151187]

(45) CollectLimit
Input [25]: [COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]
Arguments: 500000

(46) AdaptiveSparkPlan
Output [25]: [COL_F54B7341_D13E_4312_AACA_D9ECD7792DD1#151823, COL_B2D606CA_7EA7_46C8_89F3_E9AE1C65AFD8#151824, COL_37B4351C_F0CC_4BD8_87A3_FB249AC0F158#151825, COL_754AFE5D_6560_42BD_9B1F_6EB7273C067B#151826, COL_14FE20DC_F213_4F1B_BFF4_CAF07DFA207D#151827, COL_154BBE44_39BE_4C61_859A_1DAC7BC0DA68#151828, COL_EAF358F5_1D5C_4B24_BDB7_C418861C06D8#151829, COL_294E4891_367B_4046_8001_BCAD2C5FCBB4#151830, COL_4F4AEEE5_DC04_4D44_BE21_F71ED23C9354#151831, COL_9A077145_93B8_40AD_B738_64998927F18D#151832, COL_4280A993_B781_4588_BC24_E6ED0CACB8AC#151833, COL_35167909_34D4_425E_B588_D2413A80F263#151834, COL_533D0E1B_0DFD_4F02_93BF_E342B1E562F9#151835, COL_D3C59287_86FB_49C7_8FE2_86950A5308B3#151836, COL_5A02C7D6_4E25_40EA_9209_D6075B462275#151837, COL_A2916306_90E2_42D0_AE19_17D6DEFA8555#151838, COL_0AA9BA3D_494F_45A9_9173_8B1988F0C5B1#151839, COL_5A4EA164_4D7A_4D13_A439_D2E6F96CC7B7#151840, COL_75E7F8B3_63FD_4524_8797_9FD49D003F5A#152140, COL_8EEEF292_73FC_47F8_B118_86C9AC2ABEB2#151841, COL_B7B4A31B_71BA_4BD5_9077_FE832E523A5F#151842, COL_12D1802E_E528_45F4_8F72_01F3CEBE1019#151843, COL_A9E1E351_0ABF_4F6E_ADA0_C362DA5D385C#152144, COL_2B168EB8_8E98_4B30_8FBC_A3ED1FB1B4DA#152145, COL_E27BF8B7_FC37_4320_BE6D_8130C502B41C#151844]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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