hdh-spark-job - Details for Query 1221

Submitted Time: 2026/08/31 13:33:59
Duration: 0.2 s
Succeeded Jobs: 1597 1600 1604 1614

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 1 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="SortMergeJoin number of output rows: 12 spill size: 0.0 B"]; } subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 2 ms"; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="SortMergeJoin number of output rows: 12 spill size: 0.0 B"]; } subgraph cluster7 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 4 ms"; 8 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 9 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 818.0 B number of coalesced partitions: 1"]; 10 [labelType="html" label="Exchange shuffle records written: 12 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 12 local bytes read: 792.0 B 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: 768.0 B 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: 792.0 B"]; subgraph cluster11 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 11 ms"; 12 [labelType="html" label=" Project "]; 13 [labelType="html" label="Filter number of output rows: 12"]; } 14 [labelType="html" label="Scan csv number of output rows: 12 number of files read: 1 metadata time: 0 ms size of files read: 623.0 B"]; subgraph cluster15 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 3 ms"; 16 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 17 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 944.0 B number of coalesced partitions: 1"]; 18 [labelType="html" label="Exchange shuffle records written: 12 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 12 local bytes read: 882.0 B 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: 768.0 B 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: 882.0 B"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 5 ms"; 20 [labelType="html" label=" Project "]; 21 [labelType="html" label="Filter number of output rows: 12"]; } 22 [labelType="html" label="Scan csv number of output rows: 12 number of files read: 1 metadata time: 0 ms size of files read: 781.0 B"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 2 ms"; 24 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 25 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 935.0 B number of coalesced partitions: 1"]; 26 [labelType="html" label="Exchange shuffle records written: 12 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 12 local bytes read: 894.0 B 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: 768.0 B 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: 894.0 B"]; subgraph cluster27 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 8 ms"; 28 [labelType="html" label=" Project "]; 29 [labelType="html" label="Filter number of output rows: 12"]; } 30 [labelType="html" label="Scan csv number of output rows: 12 number of files read: 1 metadata time: 0 ms size of files read: 848.0 B"]; 2->0; 3->2; 5->3; 6->5; 8->6; 9->8; 10->9; 12->10; 13->12; 14->13; 16->6; 17->16; 18->17; 20->18; 21->20; 22->21; 24->3; 25->24; 26->25; 28->26; 29->28; 30->29; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 AS COL_9A58785B_4900_4FE3_B7CE_CE6E81240F53#267177, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799 AS COL_A5BCBDFE_DF9F_4A36_B310_6931DFE62403#267178, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800 AS COL_7A7F91DE_1AF1_4694_A115_D189944821E2#267179, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801 AS COL_B622F002_6A8D_44AD_A580_A7D99A0CED55#267180, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802 AS COL_2F316675_5C97_4502_BB32_400428154307#267181, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803 AS COL_C37546A2_EA04_4B5D_BF41_B71CB4F3247F#267182, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179 AS COL_8AEE4B45_F122_4D56_B30D_1F7AF760ACAD#267183, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180 AS COL_A66CB2A4_9307_40C3_98D6_CFDF2779D4DD#267184, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181 AS COL_9D9F7070_7D9D_4A05_A0BF_D1266A3C85CA#267185, COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182 AS COL_1370ED8E_1D22_494F_B7AE_F450782FBDEE#267186, COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183 AS COL_902129CD_0FE1_4BEF_B5DB_BE12B4A5B721#267187, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316 AS COL_241393F0_7F5E_4208_BBE8_E27678B93770#267188, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317 AS COL_9BB3CCC2_49D1_464A_AECA_EC559AE5DB46#267189, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318 AS COL_0879BD0A_361A_40C3_B9FE_B69C3C64EE86#267190, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319 AS COL_740D251F_6088_4F63_8596_CA2E1596E294#267191, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320 AS COL_DE43712C_23AF_424F_8B2A_4C9EB4AB552E#267192, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179)) AS COL_BC090F95_F6A0_4A60_97CA_50B20BC891A1#267193, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316)) AS COL_AA7FDF67_7BF1_4179_B758_9D6D8828FC8C#267194, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180)) AS COL_BEA58BDB_71BF_4D2D_B33B_8E2D45BCBF63#267195, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317)) AS COL_970FCC76_248D_4BA1_A2A5_7EE3DB741B89#267196, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181)) AS COL_1A22737F_4C18_4BBD_8A6D_9ACFF29EC769#267197, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318)) AS COL_E78D28F0_DD11_4FB6_81C3_E029B4D8CE52#267198]

SortMergeJoin [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798], [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315], Cross

WholeStageCodegen (8)

Project [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864 AS COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865 AS COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866 AS COL_22107307_F80B_42A0_8976_8860CCB59A07#264181, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867 AS COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868 AS COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183]

SortMergeJoin [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798], [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863], Cross

WholeStageCodegen (6)

Sort [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, 10), ENSURE_REQUIREMENTS, [plan_id=93238]

Project [_c0#263313 AS COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, Nb de séjour (GHS) 2021#263314 AS COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, Valorisation initiale (GHS) 2021#263315 AS COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, Valorisation totale (GHS) 2021#263316 AS COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, Valorisation Forfait (GHS) 2021#263317 AS COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, Activité Notifiée (GHS) 2021#263318 AS COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]

Filter isnotnull(_c0#263313)

WholeStageCodegen (1)

FileScan csv [_c0#263313,Nb de séjour (GHS) 2021#263314,Valorisation initiale (GHS) 2021#263315,Valorisation totale (GHS) 2021#263316,Valorisation Forfait (GHS) 2021#263317,Activité Notifiée (GHS) 2021#263318] Batched: false, DataFilters: [isnotnull(_c0#263313)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/635A7D57_0A0C_4596_9D01_24A897274..., PartitionFilters: [], PushedFilters: [IsNotNull(_c0)], ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2021:double,Valorisation initiale (GHS) 2021:double,Valorisa...

Sort [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863 ASC NULLS FIRST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, 10), ENSURE_REQUIREMENTS, [plan_id=93299]

Project [_c0#262162 AS DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, Nb de séjour (GHS) 2020#262163 AS DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, Valorisation initiale (GHS) 2020#262164 AS DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, Valorisation totale (GHS) 2020#262165 AS DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, Valorisation Forfait (GHS) 2020#262166 AS DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, Activité Notifiée (GHS) 2020#262167 AS DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]

Filter isnotnull(_c0#262162)

WholeStageCodegen (2)

FileScan csv [_c0#262162,Nb de séjour (GHS) 2020#262163,Valorisation initiale (GHS) 2020#262164,Valorisation totale (GHS) 2020#262165,Valorisation Forfait (GHS) 2020#262166,Activité Notifiée (GHS) 2020#262167] Batched: false, DataFilters: [isnotnull(_c0#262162)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/56E51CD5_DA8C_46A5_969D_865651F31..., PartitionFilters: [], PushedFilters: [IsNotNull(_c0)], ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2020:double,Valorisation initiale (GHS) 2020:double,Valorisa...

Sort [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315 ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, 10), ENSURE_REQUIREMENTS, [plan_id=93361]

Project [_c0#262739 AS DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, Nb de séjour (GHS) 2019#262740 AS DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, Valorisation initiale (GHS) 2019#262741 AS DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, Valorisation totale (GHS) 2019#262742 AS DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, Valorisation Forfait (GHS) 2019#262743 AS DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, Activité Notifiée (GHS) 2019#262744 AS DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]

Filter isnotnull(_c0#262739)

WholeStageCodegen (3)

FileScan csv [_c0#262739,Nb de séjour (GHS) 2019#262740,Valorisation initiale (GHS) 2019#262741,Valorisation totale (GHS) 2019#262742,Valorisation Forfait (GHS) 2019#262743,Activité Notifiée (GHS) 2019#262744] Batched: false, DataFilters: [isnotnull(_c0#262739)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/E68B7426_52DA_4227_8043_BE20ADDAA..., PartitionFilters: [], PushedFilters: [IsNotNull(_c0)], ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2019:double,Valorisation initiale (GHS) 2019:double,Valorisa...

Details

== Physical Plan ==
AdaptiveSparkPlan (43)
+- == Final Plan ==
   * Project (25)
   +- * SortMergeJoin Cross (24)
      :- * Project (16)
      :  +- * SortMergeJoin Cross (15)
      :     :- * Sort (7)
      :     :  +- AQEShuffleRead (6)
      :     :     +- ShuffleQueryStage (5), Statistics(sizeInBytes=768.0 B, rowCount=12)
      :     :        +- Exchange (4)
      :     :           +- * Project (3)
      :     :              +- * Filter (2)
      :     :                 +- Scan csv  (1)
      :     +- * Sort (14)
      :        +- AQEShuffleRead (13)
      :           +- ShuffleQueryStage (12), Statistics(sizeInBytes=768.0 B, rowCount=12)
      :              +- Exchange (11)
      :                 +- * Project (10)
      :                    +- * Filter (9)
      :                       +- Scan csv  (8)
      +- * Sort (23)
         +- AQEShuffleRead (22)
            +- ShuffleQueryStage (21), Statistics(sizeInBytes=768.0 B, rowCount=12)
               +- Exchange (20)
                  +- * Project (19)
                     +- * Filter (18)
                        +- Scan csv  (17)
+- == Initial Plan ==
   CollectLimit (42)
   +- Project (41)
      +- SortMergeJoin Cross (40)
         :- Project (35)
         :  +- SortMergeJoin Cross (34)
         :     :- Sort (29)
         :     :  +- Exchange (28)
         :     :     +- Project (27)
         :     :        +- Filter (26)
         :     :           +- Scan csv  (1)
         :     +- Sort (33)
         :        +- Exchange (32)
         :           +- Project (31)
         :              +- Filter (30)
         :                 +- Scan csv  (8)
         +- Sort (39)
            +- Exchange (38)
               +- Project (37)
                  +- Filter (36)
                     +- Scan csv  (17)


(1) Scan csv 
Output [6]: [_c0#263313, Nb de séjour (GHS) 2021#263314, Valorisation initiale (GHS) 2021#263315, Valorisation totale (GHS) 2021#263316, Valorisation Forfait (GHS) 2021#263317, Activité Notifiée (GHS) 2021#263318]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/635A7D57_0A0C_4596_9D01_24A897274FB6/current/extract_idProfil2_2021.csv]
PushedFilters: [IsNotNull(_c0)]
ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2021:double,Valorisation initiale (GHS) 2021:double,Valorisation totale (GHS) 2021:double,Valorisation Forfait (GHS) 2021:double,Activité Notifiée (GHS) 2021:double>

(2) Filter [codegen id : 1]
Input [6]: [_c0#263313, Nb de séjour (GHS) 2021#263314, Valorisation initiale (GHS) 2021#263315, Valorisation totale (GHS) 2021#263316, Valorisation Forfait (GHS) 2021#263317, Activité Notifiée (GHS) 2021#263318]
Condition : isnotnull(_c0#263313)

(3) Project [codegen id : 1]
Output [6]: [_c0#263313 AS COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, Nb de séjour (GHS) 2021#263314 AS COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, Valorisation initiale (GHS) 2021#263315 AS COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, Valorisation totale (GHS) 2021#263316 AS COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, Valorisation Forfait (GHS) 2021#263317 AS COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, Activité Notifiée (GHS) 2021#263318 AS COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Input [6]: [_c0#263313, Nb de séjour (GHS) 2021#263314, Valorisation initiale (GHS) 2021#263315, Valorisation totale (GHS) 2021#263316, Valorisation Forfait (GHS) 2021#263317, Activité Notifiée (GHS) 2021#263318]

(4) Exchange
Input [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: hashpartitioning(COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, 10), ENSURE_REQUIREMENTS, [plan_id=93238]

(5) ShuffleQueryStage
Output [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: 0

(6) AQEShuffleRead
Input [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: coalesced

(7) Sort [codegen id : 4]
Input [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 ASC NULLS FIRST], false, 0

(8) Scan csv 
Output [6]: [_c0#262162, Nb de séjour (GHS) 2020#262163, Valorisation initiale (GHS) 2020#262164, Valorisation totale (GHS) 2020#262165, Valorisation Forfait (GHS) 2020#262166, Activité Notifiée (GHS) 2020#262167]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/56E51CD5_DA8C_46A5_969D_865651F311B5/current/extract_idProfil2_2020.csv]
PushedFilters: [IsNotNull(_c0)]
ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2020:double,Valorisation initiale (GHS) 2020:double,Valorisation totale (GHS) 2020:double,Valorisation Forfait (GHS) 2020:double,Activité Notifiée (GHS) 2020:double>

(9) Filter [codegen id : 2]
Input [6]: [_c0#262162, Nb de séjour (GHS) 2020#262163, Valorisation initiale (GHS) 2020#262164, Valorisation totale (GHS) 2020#262165, Valorisation Forfait (GHS) 2020#262166, Activité Notifiée (GHS) 2020#262167]
Condition : isnotnull(_c0#262162)

(10) Project [codegen id : 2]
Output [6]: [_c0#262162 AS DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, Nb de séjour (GHS) 2020#262163 AS DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, Valorisation initiale (GHS) 2020#262164 AS DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, Valorisation totale (GHS) 2020#262165 AS DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, Valorisation Forfait (GHS) 2020#262166 AS DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, Activité Notifiée (GHS) 2020#262167 AS DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Input [6]: [_c0#262162, Nb de séjour (GHS) 2020#262163, Valorisation initiale (GHS) 2020#262164, Valorisation totale (GHS) 2020#262165, Valorisation Forfait (GHS) 2020#262166, Activité Notifiée (GHS) 2020#262167]

(11) Exchange
Input [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: hashpartitioning(DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, 10), ENSURE_REQUIREMENTS, [plan_id=93299]

(12) ShuffleQueryStage
Output [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: 1

(13) AQEShuffleRead
Input [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: coalesced

(14) Sort [codegen id : 5]
Input [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863 ASC NULLS FIRST], false, 0

(15) SortMergeJoin [codegen id : 6]
Left keys [1]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798]
Right keys [1]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863]
Join type: Cross
Join condition: None

(16) Project [codegen id : 6]
Output [11]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864 AS COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865 AS COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866 AS COL_22107307_F80B_42A0_8976_8860CCB59A07#264181, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867 AS COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868 AS COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183]
Input [12]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]

(17) Scan csv 
Output [6]: [_c0#262739, Nb de séjour (GHS) 2019#262740, Valorisation initiale (GHS) 2019#262741, Valorisation totale (GHS) 2019#262742, Valorisation Forfait (GHS) 2019#262743, Activité Notifiée (GHS) 2019#262744]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/E68B7426_52DA_4227_8043_BE20ADDAAFD9/current/extract_idProfil2_2019.csv]
PushedFilters: [IsNotNull(_c0)]
ReadSchema: struct<_c0:string,Nb de séjour (GHS) 2019:double,Valorisation initiale (GHS) 2019:double,Valorisation totale (GHS) 2019:double,Valorisation Forfait (GHS) 2019:double,Activité Notifiée (GHS) 2019:double>

(18) Filter [codegen id : 3]
Input [6]: [_c0#262739, Nb de séjour (GHS) 2019#262740, Valorisation initiale (GHS) 2019#262741, Valorisation totale (GHS) 2019#262742, Valorisation Forfait (GHS) 2019#262743, Activité Notifiée (GHS) 2019#262744]
Condition : isnotnull(_c0#262739)

(19) Project [codegen id : 3]
Output [6]: [_c0#262739 AS DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, Nb de séjour (GHS) 2019#262740 AS DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, Valorisation initiale (GHS) 2019#262741 AS DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, Valorisation totale (GHS) 2019#262742 AS DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, Valorisation Forfait (GHS) 2019#262743 AS DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, Activité Notifiée (GHS) 2019#262744 AS DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Input [6]: [_c0#262739, Nb de séjour (GHS) 2019#262740, Valorisation initiale (GHS) 2019#262741, Valorisation totale (GHS) 2019#262742, Valorisation Forfait (GHS) 2019#262743, Activité Notifiée (GHS) 2019#262744]

(20) Exchange
Input [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: hashpartitioning(DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, 10), ENSURE_REQUIREMENTS, [plan_id=93361]

(21) ShuffleQueryStage
Output [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: 2

(22) AQEShuffleRead
Input [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: coalesced

(23) Sort [codegen id : 7]
Input [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315 ASC NULLS FIRST], false, 0

(24) SortMergeJoin [codegen id : 8]
Left keys [1]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798]
Right keys [1]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315]
Join type: Cross
Join condition: None

(25) Project [codegen id : 8]
Output [22]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 AS COL_9A58785B_4900_4FE3_B7CE_CE6E81240F53#267177, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799 AS COL_A5BCBDFE_DF9F_4A36_B310_6931DFE62403#267178, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800 AS COL_7A7F91DE_1AF1_4694_A115_D189944821E2#267179, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801 AS COL_B622F002_6A8D_44AD_A580_A7D99A0CED55#267180, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802 AS COL_2F316675_5C97_4502_BB32_400428154307#267181, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803 AS COL_C37546A2_EA04_4B5D_BF41_B71CB4F3247F#267182, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179 AS COL_8AEE4B45_F122_4D56_B30D_1F7AF760ACAD#267183, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180 AS COL_A66CB2A4_9307_40C3_98D6_CFDF2779D4DD#267184, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181 AS COL_9D9F7070_7D9D_4A05_A0BF_D1266A3C85CA#267185, COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182 AS COL_1370ED8E_1D22_494F_B7AE_F450782FBDEE#267186, COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183 AS COL_902129CD_0FE1_4BEF_B5DB_BE12B4A5B721#267187, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316 AS COL_241393F0_7F5E_4208_BBE8_E27678B93770#267188, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317 AS COL_9BB3CCC2_49D1_464A_AECA_EC559AE5DB46#267189, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318 AS COL_0879BD0A_361A_40C3_B9FE_B69C3C64EE86#267190, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319 AS COL_740D251F_6088_4F63_8596_CA2E1596E294#267191, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320 AS COL_DE43712C_23AF_424F_8B2A_4C9EB4AB552E#267192, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179)) AS COL_BC090F95_F6A0_4A60_97CA_50B20BC891A1#267193, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316)) AS COL_AA7FDF67_7BF1_4179_B758_9D6D8828FC8C#267194, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180)) AS COL_BEA58BDB_71BF_4D2D_B33B_8E2D45BCBF63#267195, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317)) AS COL_970FCC76_248D_4BA1_A2A5_7EE3DB741B89#267196, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181)) AS COL_1A22737F_4C18_4BBD_8A6D_9ACFF29EC769#267197, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318)) AS COL_E78D28F0_DD11_4FB6_81C3_E029B4D8CE52#267198]
Input [17]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181, COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182, COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183, DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]

(26) Filter
Input [6]: [_c0#263313, Nb de séjour (GHS) 2021#263314, Valorisation initiale (GHS) 2021#263315, Valorisation totale (GHS) 2021#263316, Valorisation Forfait (GHS) 2021#263317, Activité Notifiée (GHS) 2021#263318]
Condition : isnotnull(_c0#263313)

(27) Project
Output [6]: [_c0#263313 AS COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, Nb de séjour (GHS) 2021#263314 AS COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, Valorisation initiale (GHS) 2021#263315 AS COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, Valorisation totale (GHS) 2021#263316 AS COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, Valorisation Forfait (GHS) 2021#263317 AS COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, Activité Notifiée (GHS) 2021#263318 AS COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Input [6]: [_c0#263313, Nb de séjour (GHS) 2021#263314, Valorisation initiale (GHS) 2021#263315, Valorisation totale (GHS) 2021#263316, Valorisation Forfait (GHS) 2021#263317, Activité Notifiée (GHS) 2021#263318]

(28) Exchange
Input [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: hashpartitioning(COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, 10), ENSURE_REQUIREMENTS, [plan_id=93173]

(29) Sort
Input [6]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803]
Arguments: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 ASC NULLS FIRST], false, 0

(30) Filter
Input [6]: [_c0#262162, Nb de séjour (GHS) 2020#262163, Valorisation initiale (GHS) 2020#262164, Valorisation totale (GHS) 2020#262165, Valorisation Forfait (GHS) 2020#262166, Activité Notifiée (GHS) 2020#262167]
Condition : isnotnull(_c0#262162)

(31) Project
Output [6]: [_c0#262162 AS DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, Nb de séjour (GHS) 2020#262163 AS DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, Valorisation initiale (GHS) 2020#262164 AS DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, Valorisation totale (GHS) 2020#262165 AS DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, Valorisation Forfait (GHS) 2020#262166 AS DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, Activité Notifiée (GHS) 2020#262167 AS DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Input [6]: [_c0#262162, Nb de séjour (GHS) 2020#262163, Valorisation initiale (GHS) 2020#262164, Valorisation totale (GHS) 2020#262165, Valorisation Forfait (GHS) 2020#262166, Activité Notifiée (GHS) 2020#262167]

(32) Exchange
Input [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: hashpartitioning(DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, 10), ENSURE_REQUIREMENTS, [plan_id=93176]

(33) Sort
Input [6]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]
Arguments: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863 ASC NULLS FIRST], false, 0

(34) SortMergeJoin
Left keys [1]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798]
Right keys [1]: [DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863]
Join type: Cross
Join condition: None

(35) Project
Output [11]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864 AS COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865 AS COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866 AS COL_22107307_F80B_42A0_8976_8860CCB59A07#264181, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867 AS COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868 AS COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183]
Input [12]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, DB_EXTRACT_IDPR_42852_COL_4216CDEF_C237_4D2B_9914_773A1C9802FD#263863, DB_EXTRACT_IDPR_42852_COL_173CD594_36F4_4F78_A2F4_140D261F2D55#263864, DB_EXTRACT_IDPR_42852_COL_B560D27D_B0E6_461B_A6B2_CD7A90BA07B6#263865, DB_EXTRACT_IDPR_42852_COL_2BAF6F13_28A6_47AA_956A_136BC6002D26#263866, DB_EXTRACT_IDPR_42852_COL_ED1DA3D3_1536_4EFB_9048_F98373D4EEC3#263867, DB_EXTRACT_IDPR_42852_COL_4ECF18E8_B967_4DED_B30F_14C24B690C39#263868]

(36) Filter
Input [6]: [_c0#262739, Nb de séjour (GHS) 2019#262740, Valorisation initiale (GHS) 2019#262741, Valorisation totale (GHS) 2019#262742, Valorisation Forfait (GHS) 2019#262743, Activité Notifiée (GHS) 2019#262744]
Condition : isnotnull(_c0#262739)

(37) Project
Output [6]: [_c0#262739 AS DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, Nb de séjour (GHS) 2019#262740 AS DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, Valorisation initiale (GHS) 2019#262741 AS DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, Valorisation totale (GHS) 2019#262742 AS DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, Valorisation Forfait (GHS) 2019#262743 AS DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, Activité Notifiée (GHS) 2019#262744 AS DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Input [6]: [_c0#262739, Nb de séjour (GHS) 2019#262740, Valorisation initiale (GHS) 2019#262741, Valorisation totale (GHS) 2019#262742, Valorisation Forfait (GHS) 2019#262743, Activité Notifiée (GHS) 2019#262744]

(38) Exchange
Input [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: hashpartitioning(DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, 10), ENSURE_REQUIREMENTS, [plan_id=93199]

(39) Sort
Input [6]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]
Arguments: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315 ASC NULLS FIRST], false, 0

(40) SortMergeJoin
Left keys [1]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798]
Right keys [1]: [DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315]
Join type: Cross
Join condition: None

(41) Project
Output [22]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798 AS COL_9A58785B_4900_4FE3_B7CE_CE6E81240F53#267177, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799 AS COL_A5BCBDFE_DF9F_4A36_B310_6931DFE62403#267178, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800 AS COL_7A7F91DE_1AF1_4694_A115_D189944821E2#267179, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801 AS COL_B622F002_6A8D_44AD_A580_A7D99A0CED55#267180, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802 AS COL_2F316675_5C97_4502_BB32_400428154307#267181, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803 AS COL_C37546A2_EA04_4B5D_BF41_B71CB4F3247F#267182, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179 AS COL_8AEE4B45_F122_4D56_B30D_1F7AF760ACAD#267183, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180 AS COL_A66CB2A4_9307_40C3_98D6_CFDF2779D4DD#267184, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181 AS COL_9D9F7070_7D9D_4A05_A0BF_D1266A3C85CA#267185, COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182 AS COL_1370ED8E_1D22_494F_B7AE_F450782FBDEE#267186, COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183 AS COL_902129CD_0FE1_4BEF_B5DB_BE12B4A5B721#267187, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316 AS COL_241393F0_7F5E_4208_BBE8_E27678B93770#267188, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317 AS COL_9BB3CCC2_49D1_464A_AECA_EC559AE5DB46#267189, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318 AS COL_0879BD0A_361A_40C3_B9FE_B69C3C64EE86#267190, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319 AS COL_740D251F_6088_4F63_8596_CA2E1596E294#267191, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320 AS COL_DE43712C_23AF_424F_8B2A_4C9EB4AB552E#267192, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179)) AS COL_BC090F95_F6A0_4A60_97CA_50B20BC891A1#267193, dec_operator(DIFFERENCE, array(COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316)) AS COL_AA7FDF67_7BF1_4179_B758_9D6D8828FC8C#267194, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180)) AS COL_BEA58BDB_71BF_4D2D_B33B_8E2D45BCBF63#267195, dec_operator(DIFFERENCE, array(COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317)) AS COL_970FCC76_248D_4BA1_A2A5_7EE3DB741B89#267196, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181)) AS COL_1A22737F_4C18_4BBD_8A6D_9ACFF29EC769#267197, dec_operator(DIFFERENCE, array(COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318)) AS COL_E78D28F0_DD11_4FB6_81C3_E029B4D8CE52#267198]
Input [17]: [COL_4B2DC306_FA93_4EB5_9864_725672BF4DD7#263798, COL_A22B4AC6_A34E_44A1_983A_3CE930ACBBFF#263799, COL_6375036D_DEA4_4C63_BEAF_B8779B040BCD#263800, COL_C3559263_2BAC_4F28_BFB9_FF2CD98A11F2#263801, COL_DBEA6281_D92C_4C4C_B291_C434344DC11F#263802, COL_23409CBA_0492_48D1_9703_FFE3D7761E40#263803, COL_6D1B76C6_E771_429D_A4D8_7942D1360BAA#264179, COL_2D28EBD2_1423_46BE_A2CE_22AD2C5A425E#264180, COL_22107307_F80B_42A0_8976_8860CCB59A07#264181, COL_45FFBBAD_7516_41E0_B896_AE8A6B3C5E5B#264182, COL_21CC1F10_EBE2_437A_850A_5A53D7A17108#264183, DB_GHS_2019_42867_COL_CE4A44A5_4A75_4108_ABCE_DB422D12C582#264315, DB_GHS_2019_42867_COL_C29D4FA1_097E_4520_8B6C_B1906B200C37#264316, DB_GHS_2019_42867_COL_9134FAA5_0482_4362_8DF5_888C6EF49107#264317, DB_GHS_2019_42867_COL_CC72B9A3_3DAE_4F47_929E_766F24A23EEB#264318, DB_GHS_2019_42867_COL_035406D0_55CF_4421_9743_2B00368412A0#264319, DB_GHS_2019_42867_COL_81F828BD_0C96_4C59_9357_1FBAD417D2F5#264320]

(42) CollectLimit
Input [22]: [COL_9A58785B_4900_4FE3_B7CE_CE6E81240F53#267177, COL_A5BCBDFE_DF9F_4A36_B310_6931DFE62403#267178, COL_7A7F91DE_1AF1_4694_A115_D189944821E2#267179, COL_B622F002_6A8D_44AD_A580_A7D99A0CED55#267180, COL_2F316675_5C97_4502_BB32_400428154307#267181, COL_C37546A2_EA04_4B5D_BF41_B71CB4F3247F#267182, COL_8AEE4B45_F122_4D56_B30D_1F7AF760ACAD#267183, COL_A66CB2A4_9307_40C3_98D6_CFDF2779D4DD#267184, COL_9D9F7070_7D9D_4A05_A0BF_D1266A3C85CA#267185, COL_1370ED8E_1D22_494F_B7AE_F450782FBDEE#267186, COL_902129CD_0FE1_4BEF_B5DB_BE12B4A5B721#267187, COL_241393F0_7F5E_4208_BBE8_E27678B93770#267188, COL_9BB3CCC2_49D1_464A_AECA_EC559AE5DB46#267189, COL_0879BD0A_361A_40C3_B9FE_B69C3C64EE86#267190, COL_740D251F_6088_4F63_8596_CA2E1596E294#267191, COL_DE43712C_23AF_424F_8B2A_4C9EB4AB552E#267192, COL_BC090F95_F6A0_4A60_97CA_50B20BC891A1#267193, COL_AA7FDF67_7BF1_4179_B758_9D6D8828FC8C#267194, COL_BEA58BDB_71BF_4D2D_B33B_8E2D45BCBF63#267195, COL_970FCC76_248D_4BA1_A2A5_7EE3DB741B89#267196, COL_1A22737F_4C18_4BBD_8A6D_9ACFF29EC769#267197, COL_E78D28F0_DD11_4FB6_81C3_E029B4D8CE52#267198]
Arguments: 500000

(43) AdaptiveSparkPlan
Output [22]: [COL_9A58785B_4900_4FE3_B7CE_CE6E81240F53#267177, COL_A5BCBDFE_DF9F_4A36_B310_6931DFE62403#267178, COL_7A7F91DE_1AF1_4694_A115_D189944821E2#267179, COL_B622F002_6A8D_44AD_A580_A7D99A0CED55#267180, COL_2F316675_5C97_4502_BB32_400428154307#267181, COL_C37546A2_EA04_4B5D_BF41_B71CB4F3247F#267182, COL_8AEE4B45_F122_4D56_B30D_1F7AF760ACAD#267183, COL_A66CB2A4_9307_40C3_98D6_CFDF2779D4DD#267184, COL_9D9F7070_7D9D_4A05_A0BF_D1266A3C85CA#267185, COL_1370ED8E_1D22_494F_B7AE_F450782FBDEE#267186, COL_902129CD_0FE1_4BEF_B5DB_BE12B4A5B721#267187, COL_241393F0_7F5E_4208_BBE8_E27678B93770#267188, COL_9BB3CCC2_49D1_464A_AECA_EC559AE5DB46#267189, COL_0879BD0A_361A_40C3_B9FE_B69C3C64EE86#267190, COL_740D251F_6088_4F63_8596_CA2E1596E294#267191, COL_DE43712C_23AF_424F_8B2A_4C9EB4AB552E#267192, COL_BC090F95_F6A0_4A60_97CA_50B20BC891A1#267193, COL_AA7FDF67_7BF1_4179_B758_9D6D8828FC8C#267194, COL_BEA58BDB_71BF_4D2D_B33B_8E2D45BCBF63#267195, COL_970FCC76_248D_4BA1_A2A5_7EE3DB741B89#267196, COL_1A22737F_4C18_4BBD_8A6D_9ACFF29EC769#267197, COL_E78D28F0_DD11_4FB6_81C3_E029B4D8CE52#267198]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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