digraph G {
0 [labelType="html" label="<br><b>CollectLimit</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 1 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#3269 AS COL_5DE1CAD8_5D56_4933_9548_E09D945B9E3E#3485, N_Patient_Etablissement#3270 AS COL_E670F3CF_92E5_496E_A70A_4167CFA6B30A#3486, N_Sejour#3271 AS COL_FCCA34E3_CE15_443B_89BB_D02CAB8104F2#3487, N_Mutation#3272 AS COL_802C1AF6_1531_4F3E_8799_53482603E660#3488, Date_Prelevement#3273 AS COL_5543691A_A8B6_4367_BA58_BB4A8D22710F#3489, Code_Analyse#3274 AS COL_819A3BBA_7140_4B26_9882_602CA35F8429#3490, Libelle_Analyse#3275 AS COL_39D379CD_F868_4F07_A2F9_15BA9D20E60A#3491, Valeur#3276 AS COL_3498C280_3981_4680_AFBD_D42246DA7023#3492, Unite#3277 AS COL_79ADB537_0C21_49C6_94FB_AD87CD443D13#3493, Valeur_Ref_Min#3278 AS COL_882BF15C_59DA_4391_9666_C557829CD4AB#3494, Valeur_Ref_Max#3279 AS COL_5E28B6A2_8F68_45E0_84DC_B5FD33EBF693#3495, Statut#3280 AS COL_0D481A66_F4F5_4A05_9E5E_D2DC9645BAB3#3496]
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#3269,N_Patient_Etablissement#3270,N_Sejour#3271,N_Mutation#3272,Date_Prelevement#3273,Code_Analyse#3274,Libelle_Analyse#3275,Valeur#3276,Unite#3277,Valeur_Ref_Min#3278,Valeur_Ref_Max#3279,Statut#3280] PushedFilters: [*EqualNullSafe(N_Sejour,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#3269, N_Patient_Etablissement#3270, N_Sejour#3271, N_Mutation#3272, Date_Prelevement#3273, Code_Analyse#3274, Libelle_Analyse#3275, Valeur#3276, Unite#3277, Valeur_Ref_Min#3278, Valeur_Ref_Max#3279, Statut#3280]
PushedFilters: [*EqualNullSafe(N_Sejour,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#3269 AS COL_5DE1CAD8_5D56_4933_9548_E09D945B9E3E#3485, N_Patient_Etablissement#3270 AS COL_E670F3CF_92E5_496E_A70A_4167CFA6B30A#3486, N_Sejour#3271 AS COL_FCCA34E3_CE15_443B_89BB_D02CAB8104F2#3487, N_Mutation#3272 AS COL_802C1AF6_1531_4F3E_8799_53482603E660#3488, Date_Prelevement#3273 AS COL_5543691A_A8B6_4367_BA58_BB4A8D22710F#3489, Code_Analyse#3274 AS COL_819A3BBA_7140_4B26_9882_602CA35F8429#3490, Libelle_Analyse#3275 AS COL_39D379CD_F868_4F07_A2F9_15BA9D20E60A#3491, Valeur#3276 AS COL_3498C280_3981_4680_AFBD_D42246DA7023#3492, Unite#3277 AS COL_79ADB537_0C21_49C6_94FB_AD87CD443D13#3493, Valeur_Ref_Min#3278 AS COL_882BF15C_59DA_4391_9666_C557829CD4AB#3494, Valeur_Ref_Max#3279 AS COL_5E28B6A2_8F68_45E0_84DC_B5FD33EBF693#3495, Statut#3280 AS COL_0D481A66_F4F5_4A05_9E5E_D2DC9645BAB3#3496]
Input [12]: [N_Examen#3269, N_Patient_Etablissement#3270, N_Sejour#3271, N_Mutation#3272, Date_Prelevement#3273, Code_Analyse#3274, Libelle_Analyse#3275, Valeur#3276, Unite#3277, Valeur_Ref_Min#3278, Valeur_Ref_Max#3279, Statut#3280]
(3) CollectLimit
Input [12]: [COL_5DE1CAD8_5D56_4933_9548_E09D945B9E3E#3485, COL_E670F3CF_92E5_496E_A70A_4167CFA6B30A#3486, COL_FCCA34E3_CE15_443B_89BB_D02CAB8104F2#3487, COL_802C1AF6_1531_4F3E_8799_53482603E660#3488, COL_5543691A_A8B6_4367_BA58_BB4A8D22710F#3489, COL_819A3BBA_7140_4B26_9882_602CA35F8429#3490, COL_39D379CD_F868_4F07_A2F9_15BA9D20E60A#3491, COL_3498C280_3981_4680_AFBD_D42246DA7023#3492, COL_79ADB537_0C21_49C6_94FB_AD87CD443D13#3493, COL_882BF15C_59DA_4391_9666_C557829CD4AB#3494, COL_5E28B6A2_8F68_45E0_84DC_B5FD33EBF693#3495, COL_0D481A66_F4F5_4A05_9E5E_D2DC9645BAB3#3496]
Arguments: 1500