EVAL1_SPC1 - Details for Query 28

Submitted Time: 2026/06/02 09:24:05
Duration: 0.9 s
Succeeded Jobs: 30 31 33

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 (9)\n \nduration: 0 ms"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 1,500 spill size: 0.0 B"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (7)\n \nduration: 0 ms"; 6 [labelType="html" label="Sort sort time: 17 ms peak memory: 65.0 MiB spill size: 0.0 B"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 1357.4 KiB number of coalesced partitions: 1"]; 8 [labelType="html" label="Exchange shuffle records written: 24,850 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 22 ms (3 ms, 3 ms, 5 ms (stage 43.0: task 44)) 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: 24,850 local bytes read: 1302.5 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 5.1 MiB (351.4 KiB, 1048.2 KiB, 1749.5 KiB (stage 43.0: task 39)) 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)) 1302.5 KiB (91.5 KiB, 263.1 KiB, 430.2 KiB (stage 43.0: task 39))"]; 9 [labelType="html" label=" Union "]; subgraph cluster10 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 146 ms"; 11 [labelType="html" label=" Project "]; 12 [labelType="html" label="Filter number of output rows: 8,319"]; } 13 [labelType="html" label="Scan csv number of output rows: 8,319 number of files read: 1 metadata time: 0 ms size of files read: 2.1 MiB"]; subgraph cluster14 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 222 ms"; 15 [labelType="html" label=" Project "]; 16 [labelType="html" label="Filter number of output rows: 6,597"]; } 17 [labelType="html" label="Scan csv number of output rows: 6,597 number of files read: 1 metadata time: 0 ms size of files read: 2.1 MiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 153 ms"; 19 [labelType="html" label=" Project "]; 20 [labelType="html" label="Filter number of output rows: 4,980"]; } 21 [labelType="html" label="Scan csv number of output rows: 4,980 number of files read: 1 metadata time: 0 ms size of files read: 2.1 MiB"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 224 ms"; 23 [labelType="html" label=" Project "]; 24 [labelType="html" label="Filter number of output rows: 3,285"]; } 25 [labelType="html" label="Scan csv number of output rows: 3,285 number of files read: 1 metadata time: 0 ms size of files read: 2.1 MiB"]; subgraph cluster26 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 195 ms"; 27 [labelType="html" label=" Project "]; 28 [labelType="html" label="Filter number of output rows: 1,669"]; } 29 [labelType="html" label="Scan csv number of output rows: 1,669 number of files read: 1 metadata time: 0 ms size of files read: 2.1 MiB"]; subgraph cluster30 { isCluster="true"; label="WholeStageCodegen (8)\n \nduration: 0 ms"; 31 [labelType="html" label="Sort sort time: 0 ms peak memory: 64.1 MiB spill size: 0.0 B"]; } 32 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 52.5 KiB number of coalesced partitions: 1"]; 33 [labelType="html" label="Exchange shuffle records written: 2,022 local merged chunks fetched: 0 shuffle write time: 3 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 2,022 local bytes read: 50.6 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: 170.2 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: 50.6 KiB"]; subgraph cluster34 { isCluster="true"; label="WholeStageCodegen (6)\n \nduration: 50 ms"; 35 [labelType="html" label=" Project "]; 36 [labelType="html" label="Filter number of output rows: 2,022"]; } 37 [labelType="html" label="Scan csv number of output rows: 2,022 number of files read: 1 metadata time: 0 ms size of files read: 196.4 KiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 9->8; 11->9; 12->11; 13->12; 15->9; 16->15; 17->16; 19->9; 20->19; 21->20; 23->9; 24->23; 25->24; 27->9; 28->27; 29->28; 31->4; 32->31; 33->32; 35->33; 36->35; 37->36; }

AdaptiveSparkPlan isFinalPlan=true

CollectLimit 1500

Project [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347 AS COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346 AS COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]

SortMergeJoin [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313], [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349], Inner

WholeStageCodegen (9)

Sort [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313 ASC NULLS FIRST], false, 0

WholeStageCodegen (7)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, 10), ENSURE_REQUIREMENTS, [plan_id=1292]

Union

Project [N_Mutation#2406 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, N_Patient_Etablissement#2407 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, N_Sejour#2408 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3309, Code_DP#2412 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, Libelle_DP#2413 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, DAS 1 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, Code_DA1#2414 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, Libelle_DA1#2415 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]

Filter isnotnull(Code_DA1#2414)

WholeStageCodegen (1)

FileScan csv [N_Mutation#2406,N_Patient_Etablissement#2407,N_Sejour#2408,Code_DP#2412,Libelle_DP#2413,Code_DA1#2414,Libelle_DA1#2415] Batched: false, DataFilters: [isnotnull(Code_DA1#2414)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnost..., PartitionFilters: [], PushedFilters: [IsNotNull(Code_DA1)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP...

Project [N_Mutation#3149 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3424, N_Patient_Etablissement#3150 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3425, N_Sejour#3151 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3426, Code_DP#3155 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3427, Libelle_DP#3156 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3428, DAS 2 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3429, Code_DA2#3159 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3430, Libelle_DA2#3160 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3431]

Filter isnotnull(Code_DA2#3159)

WholeStageCodegen (2)

FileScan csv [N_Mutation#3149,N_Patient_Etablissement#3150,N_Sejour#3151,Code_DP#3155,Libelle_DP#3156,Code_DA2#3159,Libelle_DA2#3160] Batched: false, DataFilters: [isnotnull(Code_DA2#3159)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnost..., PartitionFilters: [], PushedFilters: [IsNotNull(Code_DA2)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP...

Project [N_Mutation#3192 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3432, N_Patient_Etablissement#3193 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3433, N_Sejour#3194 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3434, Code_DP#3198 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3435, Libelle_DP#3199 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3436, DAS 3 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3437, Code_DA3#3204 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3438, Libelle_DA3#3205 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3439]

Filter isnotnull(Code_DA3#3204)

WholeStageCodegen (3)

FileScan csv [N_Mutation#3192,N_Patient_Etablissement#3193,N_Sejour#3194,Code_DP#3198,Libelle_DP#3199,Code_DA3#3204,Libelle_DA3#3205] Batched: false, DataFilters: [isnotnull(Code_DA3#3204)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnost..., PartitionFilters: [], PushedFilters: [IsNotNull(Code_DA3)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP...

Project [N_Mutation#3237 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3440, N_Patient_Etablissement#3238 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3441, N_Sejour#3239 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3442, Code_DP#3243 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3443, Libelle_DP#3244 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3444, DAS 4 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3445, Code_DA4#3251 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3446, Libelle_DA4#3252 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3447]

Filter isnotnull(Code_DA4#3251)

WholeStageCodegen (4)

FileScan csv [N_Mutation#3237,N_Patient_Etablissement#3238,N_Sejour#3239,Code_DP#3243,Libelle_DP#3244,Code_DA4#3251,Libelle_DA4#3252] Batched: false, DataFilters: [isnotnull(Code_DA4#3251)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnost..., PartitionFilters: [], PushedFilters: [IsNotNull(Code_DA4)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP...

Project [N_Mutation#3280 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3448, N_Patient_Etablissement#3281 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3449, N_Sejour#3282 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3450, Code_DP#3286 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3451, Libelle_DP#3287 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3452, DAS 5 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3453, Code_DA5#3296 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3454, Libelle_DA5#3297 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3455]

Filter isnotnull(Code_DA5#3296)

WholeStageCodegen (5)

FileScan csv [N_Mutation#3280,N_Patient_Etablissement#3281,N_Sejour#3282,Code_DP#3286,Libelle_DP#3287,Code_DA5#3296,Libelle_DA5#3297] Batched: false, DataFilters: [isnotnull(Code_DA5#3296)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnost..., PartitionFilters: [], PushedFilters: [IsNotNull(Code_DA5)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP...

Sort [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349 ASC NULLS FIRST], false, 0

WholeStageCodegen (8)

AQEShuffleRead coalesced

Exchange hashpartitioning(REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349, 10), ENSURE_REQUIREMENTS, [plan_id=1339]

Project [CCS_Categorie#2848 AS REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, CCS_Famille#2847 AS REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, Code_CIM10#2844 AS REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]

Filter (isnotnull(CCS_Famille#2847) AND isnotnull(Code_CIM10#2844))

WholeStageCodegen (6)

FileScan csv [Code_CIM10#2844,CCS_Famille#2847,CCS_Categorie#2848] Batched: false, DataFilters: [isnotnull(CCS_Famille#2847), isnotnull(Code_CIM10#2844)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/REGROUPEMENT_CO_14336/current/ccs..., PartitionFilters: [], PushedFilters: [IsNotNull(CCS_Famille), IsNotNull(Code_CIM10)], ReadSchema: struct<Code_CIM10:string,CCS_Famille:string,CCS_Categorie:string>

Details

== Physical Plan ==
AdaptiveSparkPlan (51)
+- == Final Plan ==
   CollectLimit (30)
   +- * Project (29)
      +- * SortMergeJoin Inner (28)
         :- * Sort (20)
         :  +- AQEShuffleRead (19)
         :     +- ShuffleQueryStage (18), Statistics(sizeInBytes=5.1 MiB, rowCount=2.49E+4)
         :        +- Exchange (17)
         :           +- Union (16)
         :              :- * Project (3)
         :              :  +- * Filter (2)
         :              :     +- Scan csv  (1)
         :              :- * Project (6)
         :              :  +- * Filter (5)
         :              :     +- Scan csv  (4)
         :              :- * Project (9)
         :              :  +- * Filter (8)
         :              :     +- Scan csv  (7)
         :              :- * Project (12)
         :              :  +- * Filter (11)
         :              :     +- Scan csv  (10)
         :              +- * Project (15)
         :                 +- * Filter (14)
         :                    +- Scan csv  (13)
         +- * Sort (27)
            +- AQEShuffleRead (26)
               +- ShuffleQueryStage (25), Statistics(sizeInBytes=170.2 KiB, rowCount=2.02E+3)
                  +- Exchange (24)
                     +- * Project (23)
                        +- * Filter (22)
                           +- Scan csv  (21)
+- == Initial Plan ==
   CollectLimit (50)
   +- Project (49)
      +- SortMergeJoin Inner (48)
         :- Sort (43)
         :  +- Exchange (42)
         :     +- Union (41)
         :        :- Project (32)
         :        :  +- Filter (31)
         :        :     +- Scan csv  (1)
         :        :- Project (34)
         :        :  +- Filter (33)
         :        :     +- Scan csv  (4)
         :        :- Project (36)
         :        :  +- Filter (35)
         :        :     +- Scan csv  (7)
         :        :- Project (38)
         :        :  +- Filter (37)
         :        :     +- Scan csv  (10)
         :        +- Project (40)
         :           +- Filter (39)
         :              +- Scan csv  (13)
         +- Sort (47)
            +- Exchange (46)
               +- Project (45)
                  +- Filter (44)
                     +- Scan csv  (21)


(1) Scan csv 
Output [7]: [N_Mutation#2406, N_Patient_Etablissement#2407, N_Sejour#2408, Code_DP#2412, Libelle_DP#2413, Code_DA1#2414, Libelle_DA1#2415]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnostics_cim10.csv]
PushedFilters: [IsNotNull(Code_DA1)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP:string,Code_DA1:string,Libelle_DA1:string>

(2) Filter [codegen id : 1]
Input [7]: [N_Mutation#2406, N_Patient_Etablissement#2407, N_Sejour#2408, Code_DP#2412, Libelle_DP#2413, Code_DA1#2414, Libelle_DA1#2415]
Condition : isnotnull(Code_DA1#2414)

(3) Project [codegen id : 1]
Output [8]: [N_Mutation#2406 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, N_Patient_Etablissement#2407 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, N_Sejour#2408 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3309, Code_DP#2412 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, Libelle_DP#2413 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, DAS 1 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, Code_DA1#2414 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, Libelle_DA1#2415 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Input [7]: [N_Mutation#2406, N_Patient_Etablissement#2407, N_Sejour#2408, Code_DP#2412, Libelle_DP#2413, Code_DA1#2414, Libelle_DA1#2415]

(4) Scan csv 
Output [7]: [N_Mutation#3149, N_Patient_Etablissement#3150, N_Sejour#3151, Code_DP#3155, Libelle_DP#3156, Code_DA2#3159, Libelle_DA2#3160]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnostics_cim10.csv]
PushedFilters: [IsNotNull(Code_DA2)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP:string,Code_DA2:string,Libelle_DA2:string>

(5) Filter [codegen id : 2]
Input [7]: [N_Mutation#3149, N_Patient_Etablissement#3150, N_Sejour#3151, Code_DP#3155, Libelle_DP#3156, Code_DA2#3159, Libelle_DA2#3160]
Condition : isnotnull(Code_DA2#3159)

(6) Project [codegen id : 2]
Output [8]: [N_Mutation#3149 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3424, N_Patient_Etablissement#3150 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3425, N_Sejour#3151 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3426, Code_DP#3155 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3427, Libelle_DP#3156 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3428, DAS 2 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3429, Code_DA2#3159 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3430, Libelle_DA2#3160 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3431]
Input [7]: [N_Mutation#3149, N_Patient_Etablissement#3150, N_Sejour#3151, Code_DP#3155, Libelle_DP#3156, Code_DA2#3159, Libelle_DA2#3160]

(7) Scan csv 
Output [7]: [N_Mutation#3192, N_Patient_Etablissement#3193, N_Sejour#3194, Code_DP#3198, Libelle_DP#3199, Code_DA3#3204, Libelle_DA3#3205]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnostics_cim10.csv]
PushedFilters: [IsNotNull(Code_DA3)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP:string,Code_DA3:string,Libelle_DA3:string>

(8) Filter [codegen id : 3]
Input [7]: [N_Mutation#3192, N_Patient_Etablissement#3193, N_Sejour#3194, Code_DP#3198, Libelle_DP#3199, Code_DA3#3204, Libelle_DA3#3205]
Condition : isnotnull(Code_DA3#3204)

(9) Project [codegen id : 3]
Output [8]: [N_Mutation#3192 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3432, N_Patient_Etablissement#3193 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3433, N_Sejour#3194 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3434, Code_DP#3198 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3435, Libelle_DP#3199 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3436, DAS 3 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3437, Code_DA3#3204 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3438, Libelle_DA3#3205 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3439]
Input [7]: [N_Mutation#3192, N_Patient_Etablissement#3193, N_Sejour#3194, Code_DP#3198, Libelle_DP#3199, Code_DA3#3204, Libelle_DA3#3205]

(10) Scan csv 
Output [7]: [N_Mutation#3237, N_Patient_Etablissement#3238, N_Sejour#3239, Code_DP#3243, Libelle_DP#3244, Code_DA4#3251, Libelle_DA4#3252]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnostics_cim10.csv]
PushedFilters: [IsNotNull(Code_DA4)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP:string,Code_DA4:string,Libelle_DA4:string>

(11) Filter [codegen id : 4]
Input [7]: [N_Mutation#3237, N_Patient_Etablissement#3238, N_Sejour#3239, Code_DP#3243, Libelle_DP#3244, Code_DA4#3251, Libelle_DA4#3252]
Condition : isnotnull(Code_DA4#3251)

(12) Project [codegen id : 4]
Output [8]: [N_Mutation#3237 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3440, N_Patient_Etablissement#3238 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3441, N_Sejour#3239 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3442, Code_DP#3243 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3443, Libelle_DP#3244 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3444, DAS 4 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3445, Code_DA4#3251 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3446, Libelle_DA4#3252 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3447]
Input [7]: [N_Mutation#3237, N_Patient_Etablissement#3238, N_Sejour#3239, Code_DP#3243, Libelle_DP#3244, Code_DA4#3251, Libelle_DA4#3252]

(13) Scan csv 
Output [7]: [N_Mutation#3280, N_Patient_Etablissement#3281, N_Sejour#3282, Code_DP#3286, Libelle_DP#3287, Code_DA5#3296, Libelle_DA5#3297]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/DIAGNOSTIC_14331/current/diagnostics_cim10.csv]
PushedFilters: [IsNotNull(Code_DA5)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_DP:string,Libelle_DP:string,Code_DA5:string,Libelle_DA5:string>

(14) Filter [codegen id : 5]
Input [7]: [N_Mutation#3280, N_Patient_Etablissement#3281, N_Sejour#3282, Code_DP#3286, Libelle_DP#3287, Code_DA5#3296, Libelle_DA5#3297]
Condition : isnotnull(Code_DA5#3296)

(15) Project [codegen id : 5]
Output [8]: [N_Mutation#3280 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3448, N_Patient_Etablissement#3281 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3449, N_Sejour#3282 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3450, Code_DP#3286 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3451, Libelle_DP#3287 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3452, DAS 5 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3453, Code_DA5#3296 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3454, Libelle_DA5#3297 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3455]
Input [7]: [N_Mutation#3280, N_Patient_Etablissement#3281, N_Sejour#3282, Code_DP#3286, Libelle_DP#3287, Code_DA5#3296, Libelle_DA5#3297]

(16) Union

(17) Exchange
Input [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: hashpartitioning(COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, 10), ENSURE_REQUIREMENTS, [plan_id=1292]

(18) ShuffleQueryStage
Output [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: 0

(19) AQEShuffleRead
Input [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: coalesced

(20) Sort [codegen id : 7]
Input [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313 ASC NULLS FIRST], false, 0

(21) Scan csv 
Output [3]: [Code_CIM10#2844, CCS_Famille#2847, CCS_Categorie#2848]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/REGROUPEMENT_CO_14336/current/ccs_detail_complet.csv]
PushedFilters: [IsNotNull(CCS_Famille), IsNotNull(Code_CIM10)]
ReadSchema: struct<Code_CIM10:string,CCS_Famille:string,CCS_Categorie:string>

(22) Filter [codegen id : 6]
Input [3]: [Code_CIM10#2844, CCS_Famille#2847, CCS_Categorie#2848]
Condition : (isnotnull(CCS_Famille#2847) AND isnotnull(Code_CIM10#2844))

(23) Project [codegen id : 6]
Output [3]: [CCS_Categorie#2848 AS REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, CCS_Famille#2847 AS REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, Code_CIM10#2844 AS REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Input [3]: [Code_CIM10#2844, CCS_Famille#2847, CCS_Categorie#2848]

(24) Exchange
Input [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: hashpartitioning(REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349, 10), ENSURE_REQUIREMENTS, [plan_id=1339]

(25) ShuffleQueryStage
Output [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: 1

(26) AQEShuffleRead
Input [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: coalesced

(27) Sort [codegen id : 8]
Input [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349 ASC NULLS FIRST], false, 0

(28) SortMergeJoin [codegen id : 9]
Left keys [1]: [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313]
Right keys [1]: [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Join type: Inner
Join condition: None

(29) Project [codegen id : 9]
Output [10]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347 AS COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346 AS COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]
Input [11]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]

(30) CollectLimit
Input [10]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]
Arguments: 1500

(31) Filter
Input [7]: [N_Mutation#2406, N_Patient_Etablissement#2407, N_Sejour#2408, Code_DP#2412, Libelle_DP#2413, Code_DA1#2414, Libelle_DA1#2415]
Condition : isnotnull(Code_DA1#2414)

(32) Project
Output [8]: [N_Mutation#2406 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, N_Patient_Etablissement#2407 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, N_Sejour#2408 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3309, Code_DP#2412 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, Libelle_DP#2413 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, DAS 1 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, Code_DA1#2414 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, Libelle_DA1#2415 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Input [7]: [N_Mutation#2406, N_Patient_Etablissement#2407, N_Sejour#2408, Code_DP#2412, Libelle_DP#2413, Code_DA1#2414, Libelle_DA1#2415]

(33) Filter
Input [7]: [N_Mutation#3149, N_Patient_Etablissement#3150, N_Sejour#3151, Code_DP#3155, Libelle_DP#3156, Code_DA2#3159, Libelle_DA2#3160]
Condition : isnotnull(Code_DA2#3159)

(34) Project
Output [8]: [N_Mutation#3149 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3424, N_Patient_Etablissement#3150 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3425, N_Sejour#3151 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3426, Code_DP#3155 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3427, Libelle_DP#3156 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3428, DAS 2 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3429, Code_DA2#3159 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3430, Libelle_DA2#3160 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3431]
Input [7]: [N_Mutation#3149, N_Patient_Etablissement#3150, N_Sejour#3151, Code_DP#3155, Libelle_DP#3156, Code_DA2#3159, Libelle_DA2#3160]

(35) Filter
Input [7]: [N_Mutation#3192, N_Patient_Etablissement#3193, N_Sejour#3194, Code_DP#3198, Libelle_DP#3199, Code_DA3#3204, Libelle_DA3#3205]
Condition : isnotnull(Code_DA3#3204)

(36) Project
Output [8]: [N_Mutation#3192 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3432, N_Patient_Etablissement#3193 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3433, N_Sejour#3194 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3434, Code_DP#3198 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3435, Libelle_DP#3199 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3436, DAS 3 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3437, Code_DA3#3204 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3438, Libelle_DA3#3205 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3439]
Input [7]: [N_Mutation#3192, N_Patient_Etablissement#3193, N_Sejour#3194, Code_DP#3198, Libelle_DP#3199, Code_DA3#3204, Libelle_DA3#3205]

(37) Filter
Input [7]: [N_Mutation#3237, N_Patient_Etablissement#3238, N_Sejour#3239, Code_DP#3243, Libelle_DP#3244, Code_DA4#3251, Libelle_DA4#3252]
Condition : isnotnull(Code_DA4#3251)

(38) Project
Output [8]: [N_Mutation#3237 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3440, N_Patient_Etablissement#3238 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3441, N_Sejour#3239 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3442, Code_DP#3243 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3443, Libelle_DP#3244 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3444, DAS 4 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3445, Code_DA4#3251 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3446, Libelle_DA4#3252 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3447]
Input [7]: [N_Mutation#3237, N_Patient_Etablissement#3238, N_Sejour#3239, Code_DP#3243, Libelle_DP#3244, Code_DA4#3251, Libelle_DA4#3252]

(39) Filter
Input [7]: [N_Mutation#3280, N_Patient_Etablissement#3281, N_Sejour#3282, Code_DP#3286, Libelle_DP#3287, Code_DA5#3296, Libelle_DA5#3297]
Condition : isnotnull(Code_DA5#3296)

(40) Project
Output [8]: [N_Mutation#3280 AS COL_CEE122D9_558D_4592_8A6B_52296F79A208#3448, N_Patient_Etablissement#3281 AS COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3449, N_Sejour#3282 AS COL_14313289_1315_44E6_B3A0_4723546534FD#3450, Code_DP#3286 AS COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3451, Libelle_DP#3287 AS COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3452, DAS 5 AS COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3453, Code_DA5#3296 AS COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3454, Libelle_DA5#3297 AS COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3455]
Input [7]: [N_Mutation#3280, N_Patient_Etablissement#3281, N_Sejour#3282, Code_DP#3286, Libelle_DP#3287, Code_DA5#3296, Libelle_DA5#3297]

(41) Union

(42) Exchange
Input [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: hashpartitioning(COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, 10), ENSURE_REQUIREMENTS, [plan_id=1236]

(43) Sort
Input [8]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314]
Arguments: [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313 ASC NULLS FIRST], false, 0

(44) Filter
Input [3]: [Code_CIM10#2844, CCS_Famille#2847, CCS_Categorie#2848]
Condition : (isnotnull(CCS_Famille#2847) AND isnotnull(Code_CIM10#2844))

(45) Project
Output [3]: [CCS_Categorie#2848 AS REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, CCS_Famille#2847 AS REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, Code_CIM10#2844 AS REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Input [3]: [Code_CIM10#2844, CCS_Famille#2847, CCS_Categorie#2848]

(46) Exchange
Input [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: hashpartitioning(REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349, 10), ENSURE_REQUIREMENTS, [plan_id=1237]

(47) Sort
Input [3]: [REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Arguments: [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349 ASC NULLS FIRST], false, 0

(48) SortMergeJoin
Left keys [1]: [COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313]
Right keys [1]: [REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]
Join type: Inner
Join condition: None

(49) Project
Output [10]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347 AS COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346 AS COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]
Input [11]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, REGROUPEMENT_CO_14459_CCS_CATEGORIE_14464#3346, REGROUPEMENT_CO_14459_CCS_FAMILLE_14463#3347, REGROUPEMENT_CO_14459_CODE_CIM10_14460#3349]

(50) CollectLimit
Input [10]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]
Arguments: 1500

(51) AdaptiveSparkPlan
Output [10]: [COL_CEE122D9_558D_4592_8A6B_52296F79A208#3307, COL_233A21D7_4D33_4C88_8FCD_C527F0EC5E82#3308, COL_14313289_1315_44E6_B3A0_4723546534FD#3309, COL_669DBF1F_CDDF_42A9_9F19_275679EC007E#3310, COL_92AD9452_57D9_48BC_957E_430BE16B97D6#3311, COL_3DD3B7D3_C02C_4AF1_8BF0_188F78B955E5#3312, COL_983A817F_3EA2_4B94_AD4A_A0B9FE6C2965#3313, COL_DCECAFC1_3314_45F5_A4BD_3AE816C6E132#3314, COL_B02BAA90_2A7B_44BC_8742_9B4A7465E5A5#3411, COL_8B9B7B11_CA89_4E9C_8307_D3F9085827B3#3412]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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