EVAL1_SPC1 - Details for Query 20

Submitted Time: 2026/06/02 09:22:46
Duration: 1 s
Succeeded Jobs: 19 20 22

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: total (min, med, max (stageId: taskId))\n600 ms (289 ms, 311 ms, 311 ms (stage 32.0: task 27))"; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label="SortMergeJoin number of output rows: 55,314 spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32.0: task 26))"]; } subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: total (min, med, max (stageId: taskId))\n709 ms (343 ms, 366 ms, 366 ms (stage 32.0: task 27))"; 6 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 73 ms (34 ms, 39 ms, 39 ms (stage 32.0: task 27)) peak memory total (min, med, max (stageId: taskId)) 130.0 MiB (65.0 MiB, 65.0 MiB, 65.0 MiB (stage 32.0: task 26)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32.0: task 26))"]; } 7 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 2.8 MiB (1129.4 KiB, 1721.6 KiB, 1721.6 KiB (driver)) number of coalesced partitions: 2"]; 8 [labelType="html" label="Exchange shuffle records written: 55,314 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 14 ms (5 ms, 9 ms, 9 ms (stage 25.0: task 22)) 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: 55,314 local bytes read total (min, med, max (stageId: taskId)) 2.6 MiB (1087.2 KiB, 1618.9 KiB, 1618.9 KiB (stage 32.0: task 27)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 32.0: task 26)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 4 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 10.9 MiB (3.1 MiB, 7.8 MiB, 7.8 MiB (stage 25.0: task 22)) 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)) 2.6 MiB (762.8 KiB, 1943.2 KiB, 1943.2 KiB (stage 25.0: task 22))"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n783 ms (290 ms, 493 ms, 493 ms (stage 25.0: task 22))"; 10 [labelType="html" label=" Project "]; } 11 [labelType="html" label="Scan csv number of output rows: 55,314 number of files read: 1 metadata time: 0 ms size of files read: 5.6 MiB"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 666 ms"; 13 [labelType="html" label="Sort sort time total (min, med, max (stageId: taskId)) 6 ms (3 ms, 3 ms, 3 ms (stage 32.0: task 26)) peak memory total (min, med, max (stageId: taskId)) 128.4 MiB (64.1 MiB, 64.2 MiB, 64.2 MiB (stage 32.0: task 27)) spill size total (min, med, max (stageId: taskId)) 0.0 B (0.0 B, 0.0 B, 0.0 B (stage 32.0: task 26))"]; } 14 [labelType="html" label="AQEShuffleRead number of partitions: 2 partition data size total (min, med, max (stageId: taskId)) 387.8 KiB (153.6 KiB, 234.2 KiB, 234.2 KiB (driver)) number of coalesced partitions: 2"]; 15 [labelType="html" label="Exchange shuffle records written: 9,960 local merged chunks fetched: 0 shuffle write time: 4 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: 9,960 local bytes read total (min, med, max (stageId: taskId)) 371.6 KiB (148.5 KiB, 223.0 KiB, 223.0 KiB (stage 32.0: task 27)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 32.0: task 26)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 2 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1342.1 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: 371.6 KiB"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 187 ms"; 17 [labelType="html" label=" Project "]; 18 [labelType="html" label="Filter number of output rows: 9,960"]; } 19 [labelType="html" label="Scan csv number of output rows: 9,960 number of files read: 1 metadata time: 0 ms size of files read: 904.5 KiB"]; 1->0; 3->1; 4->3; 6->4; 7->6; 8->7; 10->8; 11->10; 13->4; 14->13; 15->14; 17->15; 18->17; 19->18; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=1500, orderBy=[COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST,COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775 ASC NULLS FIRST,COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST,COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778 ASC NULLS FIRST,COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777 ASC NULLS FIRST], output=[COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773,COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774,COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775,COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776,COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777,COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778,COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779,COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780,COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781,COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782,COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783,COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784,COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856,COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857,COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858,COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859,COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860])

Project [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, MUTATION_14407_N_SEJOUR_14410#1810 AS COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, MUTATION_14407_CODE_SERVICE_14411#1804 AS COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, MUTATION_14407_LIBELLE_SERVICE_14412#1807 AS COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805 AS COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, MUTATION_14407_DATE_FIN_MUTATI_14414#1806 AS COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]

SortMergeJoin [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776], [MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808], LeftOuter

WholeStageCodegen (5)

Sort [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST], false, 0

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, 10), ENSURE_REQUIREMENTS, [plan_id=729]

Project [N_Examen#1591 AS COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, N_Patient_Etablissement#1592 AS COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, N_Sejour#1593 AS COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, N_Mutation#1594 AS COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, cast(Date_Prelevement#1595 as timestamp) AS COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, Code_Analyse#1596 AS COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, Libelle_Analyse#1597 AS COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, cast(REFORMAT_FOR_DOUBLE(Valeur#1598) as double) AS COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, Unite#1599 AS COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Min#1600) as double) AS COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Max#1601) as double) AS COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, Statut#1602 AS COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]

WholeStageCodegen (1)

FileScan csv [N_Examen#1591,N_Patient_Etablissement#1592,N_Sejour#1593,N_Mutation#1594,Date_Prelevement#1595,Code_Analyse#1596,Libelle_Analyse#1597,Valeur#1598,Unite#1599,Valeur_Ref_Min#1600,Valeur_Ref_Max#1601,Statut#1602] Batched: false, DataFilters: [], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/BIOLOGIE_14335/current/biologie.csv], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<N_Examen:string,N_Patient_Etablissement:string,N_Sejour:string,N_Mutation:string,Date_Prel...

Sort [MUTATION_14407_N_PATIENT_ETABL_14409#1809 ASC NULLS FIRST, MUTATION_14407_N_MUTATION_14408#1808 ASC NULLS FIRST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808, 10), ENSURE_REQUIREMENTS, [plan_id=749]

Project [Code_Service#1172 AS MUTATION_14407_CODE_SERVICE_14411#1804, cast(Date_Debut_Mutation#1174 as timestamp) AS MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, cast(Date_Fin_Mutation#1175 as timestamp) AS MUTATION_14407_DATE_FIN_MUTATI_14414#1806, Libelle_Service#1173 AS MUTATION_14407_LIBELLE_SERVICE_14412#1807, N_Mutation#1169 AS MUTATION_14407_N_MUTATION_14408#1808, N_Patient_Etablissement#1170 AS MUTATION_14407_N_PATIENT_ETABL_14409#1809, N_Sejour#1171 AS MUTATION_14407_N_SEJOUR_14410#1810]

Filter (isnotnull(N_Patient_Etablissement#1170) AND isnotnull(N_Mutation#1169))

WholeStageCodegen (2)

FileScan csv [N_Mutation#1169,N_Patient_Etablissement#1170,N_Sejour#1171,Code_Service#1172,Libelle_Service#1173,Date_Debut_Mutation#1174,Date_Fin_Mutation#1175] Batched: false, DataFilters: [isnotnull(N_Patient_Etablissement#1170), isnotnull(N_Mutation#1169)], Format: CSV, Location: InMemoryFileIndex(1 paths)[file:/data/input/depot/csv/execution/MUTATION_14330/current/mutations...., PartitionFilters: [], PushedFilters: [IsNotNull(N_Patient_Etablissement), IsNotNull(N_Mutation)], ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_Service:string,Libel...

Details

== Physical Plan ==
AdaptiveSparkPlan (27)
+- == Final Plan ==
   TakeOrderedAndProject (16)
   +- * Project (15)
      +- * SortMergeJoin LeftOuter (14)
         :- * Sort (6)
         :  +- AQEShuffleRead (5)
         :     +- ShuffleQueryStage (4), Statistics(sizeInBytes=10.9 MiB, rowCount=5.53E+4)
         :        +- Exchange (3)
         :           +- * Project (2)
         :              +- Scan csv  (1)
         +- * Sort (13)
            +- AQEShuffleRead (12)
               +- ShuffleQueryStage (11), Statistics(sizeInBytes=1342.1 KiB, rowCount=9.96E+3)
                  +- Exchange (10)
                     +- * Project (9)
                        +- * Filter (8)
                           +- Scan csv  (7)
+- == Initial Plan ==
   TakeOrderedAndProject (26)
   +- Project (25)
      +- SortMergeJoin LeftOuter (24)
         :- Sort (19)
         :  +- Exchange (18)
         :     +- Project (17)
         :        +- Scan csv  (1)
         +- Sort (23)
            +- Exchange (22)
               +- Project (21)
                  +- Filter (20)
                     +- Scan csv  (7)


(1) Scan csv 
Output [12]: [N_Examen#1591, N_Patient_Etablissement#1592, N_Sejour#1593, N_Mutation#1594, Date_Prelevement#1595, Code_Analyse#1596, Libelle_Analyse#1597, Valeur#1598, Unite#1599, Valeur_Ref_Min#1600, Valeur_Ref_Max#1601, Statut#1602]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/BIOLOGIE_14335/current/biologie.csv]
ReadSchema: struct<N_Examen:string,N_Patient_Etablissement:string,N_Sejour:string,N_Mutation:string,Date_Prelevement:string,Code_Analyse:string,Libelle_Analyse:string,Valeur:string,Unite:string,Valeur_Ref_Min:string,Valeur_Ref_Max:string,Statut:string>

(2) Project [codegen id : 1]
Output [12]: [N_Examen#1591 AS COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, N_Patient_Etablissement#1592 AS COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, N_Sejour#1593 AS COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, N_Mutation#1594 AS COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, cast(Date_Prelevement#1595 as timestamp) AS COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, Code_Analyse#1596 AS COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, Libelle_Analyse#1597 AS COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, cast(REFORMAT_FOR_DOUBLE(Valeur#1598) as double) AS COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, Unite#1599 AS COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Min#1600) as double) AS COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Max#1601) as double) AS COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, Statut#1602 AS COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Input [12]: [N_Examen#1591, N_Patient_Etablissement#1592, N_Sejour#1593, N_Mutation#1594, Date_Prelevement#1595, Code_Analyse#1596, Libelle_Analyse#1597, Valeur#1598, Unite#1599, Valeur_Ref_Min#1600, Valeur_Ref_Max#1601, Statut#1602]

(3) Exchange
Input [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: hashpartitioning(COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, 10), ENSURE_REQUIREMENTS, [plan_id=729]

(4) ShuffleQueryStage
Output [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: 0

(5) AQEShuffleRead
Input [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: coalesced

(6) Sort [codegen id : 3]
Input [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST], false, 0

(7) Scan csv 
Output [7]: [N_Mutation#1169, N_Patient_Etablissement#1170, N_Sejour#1171, Code_Service#1172, Libelle_Service#1173, Date_Debut_Mutation#1174, Date_Fin_Mutation#1175]
Batched: false
Location: InMemoryFileIndex [file:/data/input/depot/csv/execution/MUTATION_14330/current/mutations.csv]
PushedFilters: [IsNotNull(N_Patient_Etablissement), IsNotNull(N_Mutation)]
ReadSchema: struct<N_Mutation:string,N_Patient_Etablissement:string,N_Sejour:string,Code_Service:string,Libelle_Service:string,Date_Debut_Mutation:string,Date_Fin_Mutation:string>

(8) Filter [codegen id : 2]
Input [7]: [N_Mutation#1169, N_Patient_Etablissement#1170, N_Sejour#1171, Code_Service#1172, Libelle_Service#1173, Date_Debut_Mutation#1174, Date_Fin_Mutation#1175]
Condition : (isnotnull(N_Patient_Etablissement#1170) AND isnotnull(N_Mutation#1169))

(9) Project [codegen id : 2]
Output [7]: [Code_Service#1172 AS MUTATION_14407_CODE_SERVICE_14411#1804, cast(Date_Debut_Mutation#1174 as timestamp) AS MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, cast(Date_Fin_Mutation#1175 as timestamp) AS MUTATION_14407_DATE_FIN_MUTATI_14414#1806, Libelle_Service#1173 AS MUTATION_14407_LIBELLE_SERVICE_14412#1807, N_Mutation#1169 AS MUTATION_14407_N_MUTATION_14408#1808, N_Patient_Etablissement#1170 AS MUTATION_14407_N_PATIENT_ETABL_14409#1809, N_Sejour#1171 AS MUTATION_14407_N_SEJOUR_14410#1810]
Input [7]: [N_Mutation#1169, N_Patient_Etablissement#1170, N_Sejour#1171, Code_Service#1172, Libelle_Service#1173, Date_Debut_Mutation#1174, Date_Fin_Mutation#1175]

(10) Exchange
Input [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: hashpartitioning(MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808, 10), ENSURE_REQUIREMENTS, [plan_id=749]

(11) ShuffleQueryStage
Output [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: 1

(12) AQEShuffleRead
Input [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: coalesced

(13) Sort [codegen id : 4]
Input [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: [MUTATION_14407_N_PATIENT_ETABL_14409#1809 ASC NULLS FIRST, MUTATION_14407_N_MUTATION_14408#1808 ASC NULLS FIRST], false, 0

(14) SortMergeJoin [codegen id : 5]
Left keys [2]: [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776]
Right keys [2]: [MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808]
Join type: LeftOuter
Join condition: None

(15) Project [codegen id : 5]
Output [17]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, MUTATION_14407_N_SEJOUR_14410#1810 AS COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, MUTATION_14407_CODE_SERVICE_14411#1804 AS COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, MUTATION_14407_LIBELLE_SERVICE_14412#1807 AS COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805 AS COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, MUTATION_14407_DATE_FIN_MUTATI_14414#1806 AS COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]
Input [19]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]

(16) TakeOrderedAndProject
Input [17]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]
Arguments: 1500, [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775 ASC NULLS FIRST, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778 ASC NULLS FIRST, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777 ASC NULLS FIRST], [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]

(17) Project
Output [12]: [N_Examen#1591 AS COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, N_Patient_Etablissement#1592 AS COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, N_Sejour#1593 AS COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, N_Mutation#1594 AS COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, cast(Date_Prelevement#1595 as timestamp) AS COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, Code_Analyse#1596 AS COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, Libelle_Analyse#1597 AS COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, cast(REFORMAT_FOR_DOUBLE(Valeur#1598) as double) AS COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, Unite#1599 AS COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Min#1600) as double) AS COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, cast(REFORMAT_FOR_DOUBLE(Valeur_Ref_Max#1601) as double) AS COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, Statut#1602 AS COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Input [12]: [N_Examen#1591, N_Patient_Etablissement#1592, N_Sejour#1593, N_Mutation#1594, Date_Prelevement#1595, Code_Analyse#1596, Libelle_Analyse#1597, Valeur#1598, Unite#1599, Valeur_Ref_Min#1600, Valeur_Ref_Max#1601, Statut#1602]

(18) Exchange
Input [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: hashpartitioning(COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, 10), ENSURE_REQUIREMENTS, [plan_id=627]

(19) Sort
Input [12]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784]
Arguments: [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST], false, 0

(20) Filter
Input [7]: [N_Mutation#1169, N_Patient_Etablissement#1170, N_Sejour#1171, Code_Service#1172, Libelle_Service#1173, Date_Debut_Mutation#1174, Date_Fin_Mutation#1175]
Condition : (isnotnull(N_Patient_Etablissement#1170) AND isnotnull(N_Mutation#1169))

(21) Project
Output [7]: [Code_Service#1172 AS MUTATION_14407_CODE_SERVICE_14411#1804, cast(Date_Debut_Mutation#1174 as timestamp) AS MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, cast(Date_Fin_Mutation#1175 as timestamp) AS MUTATION_14407_DATE_FIN_MUTATI_14414#1806, Libelle_Service#1173 AS MUTATION_14407_LIBELLE_SERVICE_14412#1807, N_Mutation#1169 AS MUTATION_14407_N_MUTATION_14408#1808, N_Patient_Etablissement#1170 AS MUTATION_14407_N_PATIENT_ETABL_14409#1809, N_Sejour#1171 AS MUTATION_14407_N_SEJOUR_14410#1810]
Input [7]: [N_Mutation#1169, N_Patient_Etablissement#1170, N_Sejour#1171, Code_Service#1172, Libelle_Service#1173, Date_Debut_Mutation#1174, Date_Fin_Mutation#1175]

(22) Exchange
Input [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: hashpartitioning(MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808, 10), ENSURE_REQUIREMENTS, [plan_id=628]

(23) Sort
Input [7]: [MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]
Arguments: [MUTATION_14407_N_PATIENT_ETABL_14409#1809 ASC NULLS FIRST, MUTATION_14407_N_MUTATION_14408#1808 ASC NULLS FIRST], false, 0

(24) SortMergeJoin
Left keys [2]: [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776]
Right keys [2]: [MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_MUTATION_14408#1808]
Join type: LeftOuter
Join condition: None

(25) Project
Output [17]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, MUTATION_14407_N_SEJOUR_14410#1810 AS COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, MUTATION_14407_CODE_SERVICE_14411#1804 AS COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, MUTATION_14407_LIBELLE_SERVICE_14412#1807 AS COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805 AS COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, MUTATION_14407_DATE_FIN_MUTATI_14414#1806 AS COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]
Input [19]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, MUTATION_14407_CODE_SERVICE_14411#1804, MUTATION_14407_DATE_DEBUT_MUTA_14413#1805, MUTATION_14407_DATE_FIN_MUTATI_14414#1806, MUTATION_14407_LIBELLE_SERVICE_14412#1807, MUTATION_14407_N_MUTATION_14408#1808, MUTATION_14407_N_PATIENT_ETABL_14409#1809, MUTATION_14407_N_SEJOUR_14410#1810]

(26) TakeOrderedAndProject
Input [17]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]
Arguments: 1500, [COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774 ASC NULLS FIRST, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775 ASC NULLS FIRST, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776 ASC NULLS FIRST, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778 ASC NULLS FIRST, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777 ASC NULLS FIRST], [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]

(27) AdaptiveSparkPlan
Output [17]: [COL_5600BA14_4BF4_4844_895B_5BED1AABD061#1773, COL_21FE68DA_7812_4E10_B7FA_1CFA23C27FB3#1774, COL_5C8C43F9_7864_47C2_A339_2909A7BCD734#1775, COL_3F3F1D84_AE9D_4449_9C67_EBB38C82D56F#1776, COL_387C2EC6_681F_4463_B370_20D61F7E655F#1777, COL_29C7D487_F26B_4C3F_B484_A8F2F506CBE6#1778, COL_B779FDB2_DB54_4148_A902_15993814EAF1#1779, COL_20461869_36C4_4DFA_B69D_3894C14DCADD#1780, COL_039B33DA_620E_4720_A744_CDA6AABD4094#1781, COL_30C3FB39_43A2_4350_A5A6_8184C785014F#1782, COL_30D674A7_2610_42CE_ABD6_354C9BCBCACC#1783, COL_4ABF923B_ABA5_409A_B248_F9B4AC293CAC#1784, COL_D8ECB2A1_C1E6_485B_8404_22CAFCB4910D#1856, COL_1B495B70_0170_44D4_ACA6_8AE6628C2A83#1857, COL_9CF44E7D_F809_42E7_9EC1_E93218A95D33#1858, COL_878AFB88_DBE7_4DF6_A365_EFA0503B263D#1859, COL_AD5C9A81_BFF7_4AB7_AA15_4EE8E1E429BA#1860]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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