digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 2 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>SortMergeJoin</b><br><br>number of output rows: 10<br>spill size: 0.0 B"];
}
subgraph cluster4 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 57 ms";
5 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
6 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 276.0 B<br>number of coalesced partitions: 1"];
7 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 10<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 10<br>local bytes read: 272.0 B<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 800.0 B<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 272.0 B"];
subgraph cluster8 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 18 ms";
9 [labelType="html" label="<br><b>LocalLimit</b><br><br>"];
10 [labelType="html" label="<br><b>Project</b><br><br>"];
11 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"id_ligne\", \"code_uo\", \"usager_id\", \"code_prestation\", \"date\", \"quantite_nuit\" FROM \"seraphin\".\"uo_nuit\") as x) [numPartitions=1] </b><br><br>number of output rows: 10"];
}
subgraph cluster12 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 0 ms";
13 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
14 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 2.9 KiB<br>number of coalesced partitions: 1"];
15 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 35<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 35<br>local bytes read: 2.8 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 3.3 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 2.8 KiB"];
subgraph cluster16 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 4 ms";
17 [labelType="html" label="<br><b>Project</b><br><br>"];
18 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"code_prestation\", \"niveau\", \"libelle\", \"code_parent\" FROM \"seraphin\".\"nomenclature_prestations_directes\") as x) [numPartitions=1] </b><br><br>number of output rows: 35"];
}
2->0;
3->2;
5->3;
6->5;
7->6;
9->7;
10->9;
11->10;
13->3;
14->13;
15->14;
17->15;
18->17;
}
19
AdaptiveSparkPlan isFinalPlan=true
Project [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#834810, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#834811, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#834812, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#834813, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#834814, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#834815, NOMENCLATURE_PR_424747_NIVEAU_424749#834719 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#834816, NOMENCLATURE_PR_424747_LIBELLE_424750#834718 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#834817, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#834818]
SortMergeJoin [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703], [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717], LeftOuter
WholeStageCodegen (5)
Sort [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 ASC NULLS FIRST], false, 0
WholeStageCodegen (3)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, 10), ENSURE_REQUIREMENTS, [plan_id=111999]
LocalLimit 500000
Project [id_ligne#834604 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, code_uo#834605 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, usager_id#834606 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, code_prestation#834607 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, cast(date#834608 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, cast(REFORMAT_FOR_DOUBLE(quantite_nuit#834609) as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] [id_ligne#834604,code_uo#834605,usager_id#834606,code_prestation#834607,date#834608,quantite_nuit#834609] PushedFilters: [*EqualNullSafe(usager_id,U002)], ReadSchema: struct<id_ligne:int,code_uo:string,usager_id:string,code_prestation:string,date:date,quantite_nui...
WholeStageCodegen (1)
Sort [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717 ASC NULLS FIRST], false, 0
WholeStageCodegen (4)
AQEShuffleRead coalesced
Exchange hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, 10), ENSURE_REQUIREMENTS, [plan_id=112011]
Project [code_parent#834547 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, code_prestation#834544 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, libelle#834546 AS NOMENCLATURE_PR_424747_LIBELLE_424750#834718, niveau#834545 AS NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] [code_parent#834547,code_prestation#834544,libelle#834546,niveau#834545] PushedFilters: [*IsNotNull(code_prestation)], ReadSchema: struct<code_parent:string,code_prestation:string,libelle:string,niveau:int>
WholeStageCodegen (2)
== Physical Plan ==
AdaptiveSparkPlan (23)
+- == Final Plan ==
* Project (15)
+- * SortMergeJoin LeftOuter (14)
:- * Sort (7)
: +- AQEShuffleRead (6)
: +- ShuffleQueryStage (5), Statistics(sizeInBytes=800.0 B, rowCount=10)
: +- Exchange (4)
: +- * LocalLimit (3)
: +- * Project (2)
: +- * Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] (1)
+- * Sort (13)
+- AQEShuffleRead (12)
+- ShuffleQueryStage (11), Statistics(sizeInBytes=3.3 KiB, rowCount=35)
+- Exchange (10)
+- * Project (9)
+- * Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] (8)
+- == Initial Plan ==
CollectLimit (22)
+- Project (21)
+- SortMergeJoin LeftOuter (20)
:- Sort (17)
: +- Exchange (16)
: +- LocalLimit (3)
: +- Project (2)
: +- Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] (1)
+- Sort (19)
+- Exchange (18)
+- Project (9)
+- Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] (8)
(1) Scan JDBCRelation((SELECT "id_ligne", "code_uo", "usager_id", "code_prestation", "date", "quantite_nuit" FROM "seraphin"."uo_nuit") as x) [numPartitions=1] [codegen id : 1]
Output [6]: [id_ligne#834604, code_uo#834605, usager_id#834606, code_prestation#834607, date#834608, quantite_nuit#834609]
PushedFilters: [*EqualNullSafe(usager_id,U002)]
ReadSchema: struct<id_ligne:int,code_uo:string,usager_id:string,code_prestation:string,date:date,quantite_nuit:float>
(2) Project [codegen id : 1]
Output [6]: [id_ligne#834604 AS COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, code_uo#834605 AS COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, usager_id#834606 AS COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, code_prestation#834607 AS COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, cast(date#834608 as timestamp) AS COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, cast(REFORMAT_FOR_DOUBLE(quantite_nuit#834609) as double) AS COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Input [6]: [id_ligne#834604, code_uo#834605, usager_id#834606, code_prestation#834607, date#834608, quantite_nuit#834609]
(3) LocalLimit [codegen id : 1]
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: 500000
(4) Exchange
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, 10), ENSURE_REQUIREMENTS, [plan_id=111999]
(5) ShuffleQueryStage
Output [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: 0
(6) AQEShuffleRead
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: coalesced
(7) Sort [codegen id : 3]
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 ASC NULLS FIRST], false, 0
(8) Scan JDBCRelation((SELECT "code_prestation", "niveau", "libelle", "code_parent" FROM "seraphin"."nomenclature_prestations_directes") as x) [numPartitions=1] [codegen id : 2]
Output [4]: [code_parent#834547, code_prestation#834544, libelle#834546, niveau#834545]
PushedFilters: [*IsNotNull(code_prestation)]
ReadSchema: struct<code_parent:string,code_prestation:string,libelle:string,niveau:int>
(9) Project [codegen id : 2]
Output [4]: [code_parent#834547 AS NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, code_prestation#834544 AS NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, libelle#834546 AS NOMENCLATURE_PR_424747_LIBELLE_424750#834718, niveau#834545 AS NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Input [4]: [code_parent#834547, code_prestation#834544, libelle#834546, niveau#834545]
(10) Exchange
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, 10), ENSURE_REQUIREMENTS, [plan_id=112011]
(11) ShuffleQueryStage
Output [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: 1
(12) AQEShuffleRead
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: coalesced
(13) Sort [codegen id : 4]
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717 ASC NULLS FIRST], false, 0
(14) SortMergeJoin [codegen id : 5]
Left keys [1]: [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703]
Right keys [1]: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717]
Join type: LeftOuter
Join condition: None
(15) Project [codegen id : 5]
Output [9]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#834810, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#834811, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#834812, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#834813, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#834814, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#834815, NOMENCLATURE_PR_424747_NIVEAU_424749#834719 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#834816, NOMENCLATURE_PR_424747_LIBELLE_424750#834718 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#834817, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#834818]
Input [10]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
(16) Exchange
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: hashpartitioning(COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, 10), ENSURE_REQUIREMENTS, [plan_id=111985]
(17) Sort
Input [6]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705]
Arguments: [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 ASC NULLS FIRST], false, 0
(18) Exchange
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: hashpartitioning(NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, 10), ENSURE_REQUIREMENTS, [plan_id=111986]
(19) Sort
Input [4]: [NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
Arguments: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717 ASC NULLS FIRST], false, 0
(20) SortMergeJoin
Left keys [1]: [COL_BEE328D2_279D_490C_A8A7_45465541A509#834703]
Right keys [1]: [NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717]
Join type: LeftOuter
Join condition: None
(21) Project
Output [9]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700 AS COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#834810, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701 AS COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#834811, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702 AS COL_E631054E_686B_4907_A404_653F7ADC1F83#834812, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703 AS COL_4918BC29_3253_443D_B454_0165E3F8531A#834813, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704 AS COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#834814, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705 AS COL_26B90232_B8A6_4D4A_97AE_238FA947112F#834815, NOMENCLATURE_PR_424747_NIVEAU_424749#834719 AS COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#834816, NOMENCLATURE_PR_424747_LIBELLE_424750#834718 AS COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#834817, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716 AS COL_F3958FFA_03F2_4130_A389_801FA8B82D38#834818]
Input [10]: [COL_8DC2CD87_6495_49F7_B987_EC7A28E1A864#834700, COL_B4FAD06F_32A2_44B5_9051_3917F64BF3A9#834701, COL_AD83259E_A0C4_47EC_86E1_708F3767830E#834702, COL_BEE328D2_279D_490C_A8A7_45465541A509#834703, COL_6BE720CC_03D1_4940_B472_CDFBB3AE0F88#834704, COL_AC4D6B8D_C136_43BA_AD78_873EACEDFDD7#834705, NOMENCLATURE_PR_424747_CODE_PARENT_424751#834716, NOMENCLATURE_PR_424747_CODE_PRESTATION_424748#834717, NOMENCLATURE_PR_424747_LIBELLE_424750#834718, NOMENCLATURE_PR_424747_NIVEAU_424749#834719]
(22) CollectLimit
Input [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#834810, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#834811, COL_E631054E_686B_4907_A404_653F7ADC1F83#834812, COL_4918BC29_3253_443D_B454_0165E3F8531A#834813, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#834814, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#834815, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#834816, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#834817, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#834818]
Arguments: 500000
(23) AdaptiveSparkPlan
Output [9]: [COL_A850DB54_98E0_4C0D_80E3_2B3EEFCA9633#834810, COL_8AA9B273_7AB8_4855_957E_1A9AC849BB4F#834811, COL_E631054E_686B_4907_A404_653F7ADC1F83#834812, COL_4918BC29_3253_443D_B454_0165E3F8531A#834813, COL_03F9066C_77CE_4ED8_82F5_A28FFB318447#834814, COL_26B90232_B8A6_4D4A_97AE_238FA947112F#834815, COL_E361731B_D696_439D_B387_7ABBFC1AFBE4#834816, COL_43C36E66_4EF4_48B9_B033_E108D6A3B2CE#834817, COL_F3958FFA_03F2_4130_A389_801FA8B82D38#834818]
Arguments: isFinalPlan=true