digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 8 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Scan JDBCRelation((SELECT \"N_Examen\", \"N_Patient_Etablissement\", \"N_Sejour\", \"N_Mutation\", \"Date_Prelevement\", \"Code_Analyse\", \"Libelle_Analyse\", \"Valeur\", \"Unite\", \"Valeur_Ref_Min\", \"Valeur_Ref_Max\", \"Statut\" FROM \"formation\".\"biologie_patient\") as x) [numPartitions=1] </b><br><br>number of output rows: 0"];
}
2->0;
3->2;
}
4
CollectLimit 1500
Project [N_Examen#133 AS COL_188D100B_B683_43E0_B815_65C369A5E10A#446, N_Patient_Etablissement#134 AS COL_54EDC2F3_4A9E_4C74_9369_C0036F6AE9D6#447, N_Sejour#135 AS COL_B9789512_067C_46F3_AF09_0BD98EEF65C6#450, N_Mutation#136 AS COL_E966981D_75E9_4035_8534_743888034485#452, Date_Prelevement#137 AS COL_ADCF649F_4608_42A5_BFAD_E0CA03DE831E#454, Code_Analyse#138 AS COL_D7AFC58D_26E5_4D21_A4D3_7DEC83F0820C#456, Libelle_Analyse#139 AS COL_910987FD_539D_4620_88D1_2BEBF230176C#457, Valeur#140 AS COL_F23F8FB5_1D28_4E4F_95C2_7B6B3A08F332#460, Unite#141 AS COL_9B093C31_EA13_4C74_BD59_0D17C478FAC4#461, Valeur_Ref_Min#142 AS COL_7CF067F3_97BF_4839_BADF_18BF6CD67850#463, Valeur_Ref_Max#143 AS COL_4E0DB2BC_D197_447A_9656_B4A4B5C8BCB4#465, Statut#144 AS COL_AECD090C_EA39_40F0_A782_D578E776E659#467]
Scan JDBCRelation((SELECT "N_Examen", "N_Patient_Etablissement", "N_Sejour", "N_Mutation", "Date_Prelevement", "Code_Analyse", "Libelle_Analyse", "Valeur", "Unite", "Valeur_Ref_Min", "Valeur_Ref_Max", "Statut" FROM "formation"."biologie_patient") as x) [numPartitions=1] [N_Examen#133,N_Patient_Etablissement#134,N_Sejour#135,N_Mutation#136,Date_Prelevement#137,Code_Analyse#138,Libelle_Analyse#139,Valeur#140,Unite#141,Valeur_Ref_Min#142,Valeur_Ref_Max#143,Statut#144] PushedFilters: [*EqualNullSafe(Libelle_Analyse,A)], ReadSchema: struct<N_Examen:string,N_Patient_Etablissement:string,N_Sejour:string,N_Mutation:string,Date_Prel...
WholeStageCodegen (1)
== Physical Plan ==
CollectLimit (3)
+- * Project (2)
+- * Scan JDBCRelation((SELECT "N_Examen", "N_Patient_Etablissement", "N_Sejour", "N_Mutation", "Date_Prelevement", "Code_Analyse", "Libelle_Analyse", "Valeur", "Unite", "Valeur_Ref_Min", "Valeur_Ref_Max", "Statut" FROM "formation"."biologie_patient") as x) [numPartitions=1] (1)
(1) Scan JDBCRelation((SELECT "N_Examen", "N_Patient_Etablissement", "N_Sejour", "N_Mutation", "Date_Prelevement", "Code_Analyse", "Libelle_Analyse", "Valeur", "Unite", "Valeur_Ref_Min", "Valeur_Ref_Max", "Statut" FROM "formation"."biologie_patient") as x) [numPartitions=1] [codegen id : 1]
Output [12]: [N_Examen#133, N_Patient_Etablissement#134, N_Sejour#135, N_Mutation#136, Date_Prelevement#137, Code_Analyse#138, Libelle_Analyse#139, Valeur#140, Unite#141, Valeur_Ref_Min#142, Valeur_Ref_Max#143, Statut#144]
PushedFilters: [*EqualNullSafe(Libelle_Analyse,A)]
ReadSchema: struct<N_Examen:string,N_Patient_Etablissement:string,N_Sejour:string,N_Mutation:string,Date_Prelevement:timestamp,Code_Analyse:string,Libelle_Analyse:string,Valeur:double,Unite:string,Valeur_Ref_Min:double,Valeur_Ref_Max:double,Statut:string>
(2) Project [codegen id : 1]
Output [12]: [N_Examen#133 AS COL_188D100B_B683_43E0_B815_65C369A5E10A#446, N_Patient_Etablissement#134 AS COL_54EDC2F3_4A9E_4C74_9369_C0036F6AE9D6#447, N_Sejour#135 AS COL_B9789512_067C_46F3_AF09_0BD98EEF65C6#450, N_Mutation#136 AS COL_E966981D_75E9_4035_8534_743888034485#452, Date_Prelevement#137 AS COL_ADCF649F_4608_42A5_BFAD_E0CA03DE831E#454, Code_Analyse#138 AS COL_D7AFC58D_26E5_4D21_A4D3_7DEC83F0820C#456, Libelle_Analyse#139 AS COL_910987FD_539D_4620_88D1_2BEBF230176C#457, Valeur#140 AS COL_F23F8FB5_1D28_4E4F_95C2_7B6B3A08F332#460, Unite#141 AS COL_9B093C31_EA13_4C74_BD59_0D17C478FAC4#461, Valeur_Ref_Min#142 AS COL_7CF067F3_97BF_4839_BADF_18BF6CD67850#463, Valeur_Ref_Max#143 AS COL_4E0DB2BC_D197_447A_9656_B4A4B5C8BCB4#465, Statut#144 AS COL_AECD090C_EA39_40F0_A782_D578E776E659#467]
Input [12]: [N_Examen#133, N_Patient_Etablissement#134, N_Sejour#135, N_Mutation#136, Date_Prelevement#137, Code_Analyse#138, Libelle_Analyse#139, Valeur#140, Unite#141, Valeur_Ref_Min#142, Valeur_Ref_Max#143, Statut#144]
(3) CollectLimit
Input [12]: [COL_188D100B_B683_43E0_B815_65C369A5E10A#446, COL_54EDC2F3_4A9E_4C74_9369_C0036F6AE9D6#447, COL_B9789512_067C_46F3_AF09_0BD98EEF65C6#450, COL_E966981D_75E9_4035_8534_743888034485#452, COL_ADCF649F_4608_42A5_BFAD_E0CA03DE831E#454, COL_D7AFC58D_26E5_4D21_A4D3_7DEC83F0820C#456, COL_910987FD_539D_4620_88D1_2BEBF230176C#457, COL_F23F8FB5_1D28_4E4F_95C2_7B6B3A08F332#460, COL_9B093C31_EA13_4C74_BD59_0D17C478FAC4#461, COL_7CF067F3_97BF_4839_BADF_18BF6CD67850#463, COL_4E0DB2BC_D197_447A_9656_B4A4B5C8BCB4#465, COL_AECD090C_EA39_40F0_A782_D578E776E659#467]
Arguments: 1500